Thx for this. Please consider the following power automate/collections use case. A user requires more than 20 ‘ask in Power Apps’ inputs for flow. Resolve issue by creating collection with perhaps 32 fields per record (eg, Name and attendance value for each of 31 monthly dates) and pass the entire record as a json string/object into a singular ‘ask in Power Apps’ flow input. Further requirements might include ForAll in collection to capture values for multiple students and subsequent related steps in Power Automate to parse/select records accordingly. I’ve managed this on my own once, but it was a mind-bender and I’m no longer confident that I can reverse engineer what I’ve done previously in order to repeat it now if I had to. Thanks for considering this as a future topic in case this sort of documentation would be beneficial to the community.😂😅😊
Hi gerald, Thanks for still watching the videos! I do think the way you did this is correct. To pass all the "20 ask in Power Apps" which has changed now to PowerApps V2 and instead pass it as a JSON table. Then once you have the JSON table you would use a select action in Power Automate. This select action can then be parsed to get each of the rows in a ForAll loop. My next video does some of these steps but then it takes that for all loop and creates a brand new excel file in the end. Instead of creating excel you could do other things with the data. Thank you though, I'm going to create a few videos on this topic, this seems like a good one.
So if you tried to vaccinate a Power App value - and failed - would that be Collection Selection Infection Protection Rejection? 😆 (Great video - sharing it with my coworkers)
Thank you for your vid! I understand collections better but I think applying this to data 'selected' in a Form vs the Gallery table is confusing for me. It looks like your 'galDetails' is my 'formPage1'...back to the drawing board!
Hi Domi, interesting I'm glad the video helped clarify collections. Many times people watch my videos and find even better ways than I do it. Doing data selected from a form though would normally be 1 row instead of many. There's many options find the one you like the best.
Hi Andrew. Great video on an useful topic. I am still in the learning mode and enjoy your content, so keep up the good work. Quick newbie question... how were the original Horizontal Container and Gallery elements created? Is there a video on how to set up this specific scenario? Specifically, how do the horizontal allery elements exist in the horizontal container with the individual container elements per gallery item. Is that a manual process? Any suggested videos or documentation would be appreciated. Sorry for the long comment/question. ~ Reggie
Hey Reggie, so I do have an older video and maybe its time to make a new one. But here is an older video:😀ruclips.net/video/h3m-U7jQnMQ/видео.html&t I will write down to remake this video better!
Thanks Andrew, super helpful. I do have a quick follow up question. I just ran across the modern tools blank vertical gallery. In your opinion, is that that the new method for achieving the column format, or are there pluses and minuses. (Sorry, I thought I could DM you but it can’t find anything like that on uour RUclips page).
Really looking forward to seeing you use the collections straight into Power Automate. Great video!
Thanks IllinoisREI, Thanks for your support hopefully we can get a few videos out of that functionality! Stay tuned 😀
Hi Andrew, very nice, I liked the idea, selection, collection 😁, awesome, thank you for sharing your knowledge, it is very beneficial👍
Imran! Thank you very much once again!
Thx for this. Please consider the following power automate/collections use case. A user requires more than 20 ‘ask in Power Apps’ inputs for flow. Resolve issue by creating collection with perhaps 32 fields per record (eg, Name and attendance value for each of 31 monthly dates) and pass the entire record as a json string/object into a singular ‘ask in Power Apps’ flow input. Further requirements might include ForAll in collection to capture values for multiple students and subsequent related steps in Power Automate to parse/select records accordingly. I’ve managed this on my own once, but it was a mind-bender and I’m no longer confident that I can reverse engineer what I’ve done previously in order to repeat it now if I had to. Thanks for considering this as a future topic in case this sort of documentation would be beneficial to the community.😂😅😊
Hi gerald, Thanks for still watching the videos! I do think the way you did this is correct. To pass all the "20 ask in Power Apps" which has changed now to PowerApps V2 and instead pass it as a JSON table. Then once you have the JSON table you would use a select action in Power Automate. This select action can then be parsed to get each of the rows in a ForAll loop. My next video does some of these steps but then it takes that for all loop and creates a brand new excel file in the end. Instead of creating excel you could do other things with the data. Thank you though, I'm going to create a few videos on this topic, this seems like a good one.
FYI - related example RE pass a collection to flow: ruclips.net/video/tjCAZxQOB_U/видео.htmlsi=5TzPAMicnH7iu8mu
So if you tried to vaccinate a Power App value - and failed - would that be Collection Selection Infection Protection Rejection? 😆
(Great video - sharing it with my coworkers)
Patrick! Maybe it's a Canvas Virus Crisis? 😆😆😆 Thanks Patrick hope to chat again soon!
Thank you for your vid! I understand collections better but I think applying this to data 'selected' in a Form vs the Gallery table is confusing for me. It looks like your 'galDetails' is my 'formPage1'...back to the drawing board!
Hi Domi, interesting I'm glad the video helped clarify collections. Many times people watch my videos and find even better ways than I do it. Doing data selected from a form though would normally be 1 row instead of many. There's many options find the one you like the best.
Hi Andrew. Great video on an useful topic. I am still in the learning mode and enjoy your content, so keep up the good work. Quick newbie question... how were the original Horizontal Container and Gallery elements created? Is there a video on how to set up this specific scenario? Specifically, how do the horizontal allery elements exist in the horizontal container with the individual container elements per gallery item. Is that a manual process? Any suggested videos or documentation would be appreciated. Sorry for the long comment/question. ~ Reggie
Hey Reggie, so I do have an older video and maybe its time to make a new one. But here is an older video:😀ruclips.net/video/h3m-U7jQnMQ/видео.html&t
I will write down to remake this video better!
Thanks Andrew, super helpful. I do have a quick follow up question. I just ran across the modern tools blank vertical gallery. In your opinion, is that that the new method for achieving the column format, or are there pluses and minuses. (Sorry, I thought I could DM you but it can’t find anything like that on uour RUclips page).
@@jrpool88 Hi jr, I have a new video based on your question that will release on September 16th.
@@jrpool88 Hope that helps 😁