How to send JSON data to Power Apps from Power Automate (MS Flow)

Question

I am getting the list Item attachments using the Get Attachments action in the flow.

As the output, I have the JSON object which contains the information of attachments.

Now, I want to send this JSON to the Power Apps.

Respond to Power Apps action allows us to send only single items, not objects.

How can I achieve the above?

Note: Please suggest a way which does not contain the use of a premium connector.

I was able to achieve the similar requirement using "Response" action in Power automate (which is premium action). I think as of now there is no other way to achieve this and you have to use this premium action. let me know if this helps and If you want to use it I can explain more on this. — Ganesh Sanap - Microsoft MVP, Jul 2, 2020 at 11:06
Thanks, I will let you know if I need help with Premium action — Dhruvil Prajapati, Jul 2, 2020 at 12:56

Ganesh Sanap - Microsoft MVP · Accepted Answer · 2022-09-20 11:46:17Z

Solution 1 - Using Response action (Premium/Paid):

You can use Premium Response action to send complex data back to Power Apps from Power Automate.

Source: Respond from FLOW to Power Apps

Solution 2 - Respond to Power App action (Free but Complex):

You cannot directly pass JSON object to Power App from Power Automate. You can only pass String/Text value.

As a workaround you can send your JSON object to power app as a string by using a Join action in Power automate.

Then you need to parse that string to JSON using multiple Split functions and complex logic.

Check below link, it will help you to achieve what you want.

Update:

Power Apps now supports experimental ParseJSON function which might be helpful to you.

Check below links for detailed information:

Yes, I already tried this approach. It is a success but requires very complex logic based on your data structure. — Dhruvil Prajapati, Jul 10, 2020 at 4:46
Yes, true. it is free but you need to build complex logic. and yes, logic will change according to your data. — Ganesh Sanap - Microsoft MVP, Jul 10, 2020 at 4:49

Ganesh Sanap - Microsoft MVP · Accepted Answer · 2022-01-05 12:34:53Z

0

Using the Respond action this can be achieved and with help of formulas we can construct back to the collection again in PowerApps.

Follow below article for detailed information:

41.3k21 gold badges30 silver badges57 bronze badges

answered Jan 5, 2022 at 11:41

112 bronze badges

Add a comment |

2 Answers 2