question

DevalLathigara-2905 avatar image
0 Votes"
DevalLathigara-2905 asked lmatt edited

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

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-supported
image.png (75.5 KiB)
image.png (158.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

lmatt avatar image
0 Votes"
lmatt answered lmatt edited

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
       })
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.