JSON function in PowerApps is adding unnecessary "Value" field name for single column collections. How to get resolve this?

Question

Hi Team, I am using PowerApps and Power-Automate integration for one automation requirement for customer. In this I am triggering a flow from PowerApps and passing some input value in form of JSON. This JSON is later used within the Power automate for some functionality. My basic structure is something like below:

Below is my PowerApps form

Below is the input I get in Power Automate:

As you can see the JSON input in Power Automate is something like this:

{"prop1":"val1","prop2":[{"Value":"Test1"},{"Value":"Test2"},{"Value":"Test3"},{"Value":"Test7"}]}

Where as as per my requirements I need below input in Power Automate:

{"prop1":"val1","prop2":["Test1","Test2","Test3"]}

I know that I can parse the JSON in power automate, initialise an array variable, then set my JSON again with the new array variable.

But unfortunately this will not work in my case, as the schema of input will always not be same for multiple scenarios.

The app and flow I am posting here are just examples to explain my issue in simple manner.

In actual scenario both and App and Flow has some complex logic and complex functionality.

Due to which I am not in position to iterate through all properties of the input in Power automate and then assign some array.

Can you please help me on how I can avoid the additional "Value" property name being added in the input passed from PowerApps.

Answer 1

@Deval Power apps/automate is not currently supported here on QnA. They're actively answering questions in dedicated forums here.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Answer 2

For people like me. I had the same issue.
Instead of:

data: [{
        x: Estimate,
        y: ID
      }, {
        x: Start,
        y: ID
      }]

write the following

data: Table({
        x: Estimate,
        y: ID
      }, {
        x: Start,
        y: ID
      })