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

Congrats Bro, u really helped me Deep😁😁

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

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!

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

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

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

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

Thank you for such a nice informative video.

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

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 !

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

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.

Thank you so much Deepak!!

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?

Excellent Video Deepak..Thanks for sharing

Great video. Many thanks!

YOU ARE REALLY GENIUS .. Salute!!!!

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

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.

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

This helped me out BIG TIME!

You saved my life :)

For datetime how can we Regular expression

Awesome, it works like a charm

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

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.

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?

Nice video!😊

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

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

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

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

How did u get that regex at 21:39

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 ❤️

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

RegEx doesnt work

Thanks Deepak

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.

Awsome!

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?

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