Send Array/JSON Response from Power Automate Flow to Power Apps

This video tutorial will teach you how to send an array or JSON response from Power Automate to Power Apps without using any premium connector.
I will use a use-case to create a power app that will show all the SharePoint groups and users inside each group.
Apply the same logic to any other response that you may need to send from Power Automate to Power App.
#PowerApps #PowerAutomate #HttpResponse

[@LucasAlves-eh2jl]

Congrats Bro, u really helped me Deep😁😁

[@DeepakShrivastava]

Thanks 🙏🏻

[@dotabota]

Me too 🙏🙏

[@chrisJohnson-w3t]

deep!

[@ricouxstephane1628]

Absolutely glorious! It is exactly what I was looking for. Very clear explanations and very good guide!

[@ChuckClarkonline]

Deepak, you are a genius! Great work on getting data from a Power Automate into a Power Apps collection. This is a major breakthrough! Thank you very much!

[@DeepakShrivastava]

Thank you 🙏🏻

[@ricardobunge5957]

Thanks Deepak - excellent! Some great techniques in there! Looking forward to your next video - your contributions to the community are much appreciated!

[@DeepakShrivastava]

Thanks a ton for watching.

[@vinayayinapurapu]

Glad I have watched this first thing in morning. I was researching on select and you have explained to my need.

[@DeepakShrivastava]

Glad it was helpful! Than k You.

[@rahatsyed6038]

Thank you for such a nice informative video.

[@rohitthakur962]

Thank you so much Deep. I was getting stuck in regular expressions 😃

[@ajaykumarporeddiwar9226]

Thanks Deepak. Easy explanation of use case scenarios, much appreciated.

[@DeepakShrivastava]

Most welcome!

[@navarrocloud]

You can use Coalesce() to return an empty string when the value is null. Great content as always.

[@DeepakShrivastava]

Thank You

[@premsaini4289]

You mean coalesce function in power automate? So do I need to create compose and ask site In powerapps and then add Coalesce function?

[@ammadkhan4687]

YOU ARE REALLY GENIUS .. Salute!!!!

[@frenamakenson9844]

I get this work on a collection , I convert the collection with the json function with indentfour format , I get the string similar in this video…
Thx a lot for sharing Man !

[@DeepakShrivastava]

🙏🏻

[@dougydoe]

Really good video. I actually recreated alongside as I watched it. Thanks for sharing. I picked up a lot of tips.

[@DeepakShrivastava]

Thanks a lot for watching 👍🏻

[@SubhashMahatoK]

Parsing part that what I was looking when response is rturn and that is really nice

[@shaiksamad1562]

Excellent Video Deepak..Thanks for sharing

[@DeepakShrivastava]

Thank you 🙏🏻

[@jasont80]

This helped me out BIG TIME!

[@nancynombo9141]

Thank you so much Deepak. You're such a blessing. I was wondering how to retrieve the date if one of the element is an array insted of a string or integer.

[@imranbasha4113]

Awesome, it works like a charm

[@daliasaffarini3154]

Great video. Many thanks!

[@DeepakShrivastava]

Thank you too!

[@benjaminlahsen6721]

You saved my life :)

[@DeepakShrivastava]

Thank you!

[@chandrasekharmekapothula1181]

Nice video!😊

[@taimoorrasheed561]

here when i do body('Select') it is throwing me error
Flow save failed with code 'WorkflowUnsupportedSplitOnTriggerForResponseAction' and message 'The workflow with 'Response' action type should not have triggers with 'splitOn' property defined: 'manual'.'. Any idea?

[@ssccservlearn]

Is there a limit to how many terms you can have in MatchAll? This works perfectly for the first four items in my array, but when I add a fifth, it returns nothing.

[@kmuralikrishna1582]

Really helpful..
I did the same but the collection returns blank

[@god_hacker581]

Awesome video.!!! Thanks for sharing.
Quick question ----> if we use "Response" action from power automate to send response to power apps instead of Respond to power apps or flow, will it affects performance?

[@DeepakShrivastava]

It won’t affect but Response action is premium

[@radiance7906]

For datetime how can we Regular expression

[@mchandramohan6833]

Hi Deepak, this looks amazing. But unfortunately it didn't work for me. i got text data to power variable but MatchAll didn't give any rows to collection. no error either.

[@prabhatsingh8332]

im not able to get the option " Ask in powerapps " why ??

[@karukarthi2609]

Thanks for sharing Deepak.. In case if json object returns more than 2000 records, clear collect only holds powerapps settings value that would not exceed more than 2000. Any thoughts on this..

[@DeepakShrivastava]

Collections can hold as many records as you want, 2000 limit is actually delegation limit. Because we are sending response from power automate you should be good. Only think you need to keep an eye is on performance because more data can impact the performance.

[@juanpierrejesusgonzales933]

Many Thanks Deepak!!! Awesome work!. I was thinking, what about null values?

[@DeepakShrivastava]

Thanks for watching. For Null as I said you should pass empty string in "Select".

[@sundrapillay6668]

Thanks Deepak

[@DeepakShrivastava]

Welcome

[@mattwilsn]

Hi Deepak, I'm following your video but when I get to 24:07 i'm getting a message that says "We didn't find any data" and I don't have a visible table. I think this is because my API response is a nested array, i.e. [[{k:v}, {k:v}]] - any idea how to work around this? thanks

[@bhavyygupta3996]

How did u get that regex at 21:39

[@piotrrusak]

How you will solve case when in string values there will be double apostrophe characters '"'? Then delimiter from regex will go crazy 😞 Any clever ideas to make it bulletproof? But at the end very nice video - thank you for sharing. Your content is always awesome ❤️

[@DeepakShrivastava]

Thank you for watching! You gave me something to think of 🤓👍. I will try.

[@babukurapati5611]

Thank you so much Deepak!!

[@DeepakShrivastava]

My pleasure

[@tofu6465]

RegEx doesnt work

[@paullee2217]

is there anyone who can explain where variable named "objResult" come from ?? @20:44

[@bujjibabukj9616]

Hi Sir
Request you help me to extract the data directly from Sharepoint List to gallery filter by Date
Data is patching in JSON format from Canvas app to Sharepoint list daily
Ex:
Record -1
[{"Date":"2023-02-20","Employee_ID":"500","Employee_Name":"H DHARMENDER","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"12","Shift":"A"}]
Record - 2
[{"Date":"2023-02-20","Employee_ID":"501","Employee_Name":"S BALARAJU","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"123","Shift":"B"}]
Each record is having square brackets [ ] in Sharepoint List
Your immediate response will be highly appreciated.

[@fpgroups]

This video helped me get passed the response from flow but I cannot get MatchAll() to populate my Collection.
In my case, the returned payload from SQL is just a single column rowID with integer value so the returned string looks like this
[{"rowID"}:1092]
This string is captured in variable like so: Set(varPatchResponse, ....); and I am trying to create the collection using
ClearCollect(colPatchResponse,MatchAll(varPatchResponse,"(""rowID"":(?[^""]*))");
When I view the collection, it is blank but it shows column headings as one would expect, no value - The variable shows value as shown above.
I have removed and recreated the flow a number of times ... I check the run history and all steps pass and content shown is consistent with what I am getting and yet, I cannot get the collection to populate using above regular expression.
Too long looking at it to identify problem, and I think I never will find it no matter how much longer I continue to look at it - What am I missing?

[@DeepakShrivastava]

I need to look into the response to better undersatnd the issue. "Match All" function use RegeX that is sometime hard to get right. i genrally use this regex101.com/r/cO8lqs/17 to test the Rejex. give it a try.

[@andrewvalenzuela1790]

_/api/web/sitegroups gave me an error. Unauthorized Access Exception. Any ideas?

[@SachinMehta-nx2ro]

can we also check for boolean
if yes what would be the right syntax

[@Almazees]

Awsome!

[@DeepakShrivastava]

Thanks 🙏🏻