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 🙏🏻
@ricardobunge59572 жыл бұрын
Thanks Deepak - excellent! Some great techniques in there! Looking forward to your next video - your contributions to the community are much appreciated!
@DeepakShrivastava2 жыл бұрын
Thanks a ton for watching.
@ricouxstephane16283 ай бұрын
Absolutely glorious! It is exactly what I was looking for. Very clear explanations and very good guide!
@vinayayinapurapu2 жыл бұрын
Glad I have watched this first thing in morning. I was researching on select and you have explained to my need.
@DeepakShrivastava2 жыл бұрын
Glad it was helpful! Than k You.
@rahatsyed6038 Жыл бұрын
Thank you for such a nice informative video.
@rohitthakur9622 жыл бұрын
Thank you so much Deep. I was getting stuck in regular expressions 😃
@ajaykumarporeddiwar92262 жыл бұрын
Thanks Deepak. Easy explanation of use case scenarios, much appreciated.
@DeepakShrivastava2 жыл бұрын
Most welcome!
@navarrocloud2 жыл бұрын
You can use Coalesce() to return an empty string when the value is null. Great content as always.
@DeepakShrivastava2 жыл бұрын
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?
@dougydoe2 жыл бұрын
Really good video. I actually recreated alongside as I watched it. Thanks for sharing. I picked up a lot of tips.
@DeepakShrivastava2 жыл бұрын
Thanks a lot for watching 👍🏻
@frenamakenson98442 жыл бұрын
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 !
@DeepakShrivastava2 жыл бұрын
🙏🏻
@ammadkhan46879 ай бұрын
YOU ARE REALLY GENIUS .. Salute!!!!
@shaiksamad15622 жыл бұрын
Excellent Video Deepak..Thanks for sharing
@DeepakShrivastava2 жыл бұрын
Thank you 🙏🏻
@jasont80 Жыл бұрын
This helped me out BIG TIME!
@imranbasha4113 Жыл бұрын
Awesome, it works like a charm
@SubhashMahatoK2 жыл бұрын
Parsing part that what I was looking when response is rturn and that is really nice
@god_hacker5812 жыл бұрын
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?
@DeepakShrivastava2 жыл бұрын
It won’t affect but Response action is premium
@babukurapati56112 жыл бұрын
Thank you so much Deepak!!
@DeepakShrivastava2 жыл бұрын
My pleasure
@taimoorrasheed5615 ай бұрын
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?
@nancynombo91419 ай бұрын
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.
@ssccservlearn8 ай бұрын
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.
@karukarthi26092 жыл бұрын
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..
@DeepakShrivastava2 жыл бұрын
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.
@daliasaffarini31549 ай бұрын
Great video. Many thanks!
@DeepakShrivastava8 ай бұрын
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
@kmuralikrishna15822 жыл бұрын
Really helpful.. I did the same but the collection returns blank
@prabhatsingh83327 ай бұрын
im not able to get the option " Ask in powerapps " why ??
@benjaminlahsen67218 ай бұрын
You saved my life :)
@DeepakShrivastava8 ай бұрын
Thank you!
@juanpierrejesusgonzales9332 жыл бұрын
Many Thanks Deepak!!! Awesome work!. I was thinking, what about null values?
@DeepakShrivastava2 жыл бұрын
Thanks for watching. For Null as I said you should pass empty string in "Select".
@radiance7906 Жыл бұрын
For datetime how can we Regular expression
@chandrasekharmekapothula118111 ай бұрын
Nice video!😊
@bhavyygupta3996 Жыл бұрын
How did u get that regex at 21:39
@piotrrusak2 жыл бұрын
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 ❤️
@DeepakShrivastava2 жыл бұрын
Thank you for watching! You gave me something to think of 🤓👍. I will try.
@Almazees2 жыл бұрын
Awsome!
@DeepakShrivastava2 жыл бұрын
Thanks 🙏🏻
@sundrapillay66682 жыл бұрын
Thanks Deepak
@DeepakShrivastava2 жыл бұрын
Welcome
@paullee2217 Жыл бұрын
is there anyone who can explain where variable named "objResult" come from ?? @20:44
@tofu64654 ай бұрын
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.
@fpgroups2 жыл бұрын
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?
@DeepakShrivastava2 жыл бұрын
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.
@andrewvalenzuela17902 жыл бұрын
_/api/web/sitegroups gave me an error. Unauthorized Access Exception. Any ideas?