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

[@LucasAlves-eh2jl]

Congrats Bro, u really helped me Deep😁😁

[@DeepakShrivastava]

Thanks 🙏🏻

[@dotabota]

Me too 🙏🙏

[@chrisJohnson-w3t]

deep!

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

[@ricouxstephane1628]

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

[@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?

[@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 👍🏻

[@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]

🙏🏻

[@ammadkhan4687]

YOU ARE REALLY GENIUS .. Salute!!!!

[@shaiksamad1562]

Excellent Video Deepak..Thanks for sharing

[@DeepakShrivastava]

Thank you 🙏🏻

[@jasont80]

This helped me out BIG TIME!

[@imranbasha4113]

Awesome, it works like a charm

[@SubhashMahatoK]

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

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

[@babukurapati5611]

Thank you so much Deepak!!

[@DeepakShrivastava]

My pleasure

[@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?

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

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

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

[@SachinMehta-nx2ro]

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

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

[@daliasaffarini3154]

Great video. Many thanks!

[@DeepakShrivastava]

Thank you too!

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

[@kmuralikrishna1582]

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

[@prabhatsingh8332]

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

[@benjaminlahsen6721]

You saved my life :)

[@DeepakShrivastava]

Thank you!

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

[@radiance7906]

For datetime how can we Regular expression

[@chandrasekharmekapothula1181]

Nice video!😊

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

[@Almazees]

Awsome!

[@DeepakShrivastava]

Thanks 🙏🏻

[@sundrapillay6668]

Thanks Deepak

[@DeepakShrivastava]

Welcome

[@paullee2217]

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

[@tofu6465]

RegEx doesnt work

[@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?