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

Deval 26 Reputation points Microsoft Employee
2021-11-03T11:34:13.863+00:00

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
146158-image.png

Below is the input I get in Power Automate:
146186-image.png

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,920 questions
No comments
1 vote

2 answers

Sort by: Most helpful
  1. MayankBargali-MSFT 49,711 Reputation points Microsoft Employee
    2021-11-05T07:48:21.987+00:00

    @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.

    No comments

  2. lmatt 1 Reputation point
    2022-05-06T20:37:10.483+00:00

    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
          })
    
    No comments