How to create a Collection from your Selection in Power Apps

[@kingmrrah4490]

Hey Andrew loving the new videos, may I ask if you can do a tutorial in all the ways we can achieve version history for SharePoint list eg for item or the whole list history to power app.

[@andrewhess123]

Interesting, sorry for the late reply still catching up on tasks. I will write this one down.

[@IllinoisREI23]

Really looking forward to seeing you use the collections straight into Power Automate. Great video!

[@andrewhess123]

Thanks IllinoisREI, Thanks for your support hopefully we can get a few videos out of that functionality! Stay tuned 😀

[@MikeKerul]

This is awesome! My question is; How can you do your Collection Selection idea using a Editable From (Form_Edit) and based off selecting a field inside using utcNOW for when it was touched, then applying that date to a multiline text column "appending" each selected FIELD with date stamp and field that was "selected"/touched?

[@andrewhess123]

Interesting question, you want utcnow for the exact time each field was pressed/selected?

[@MikeKerul]

@@andrewhess123 Yes correct and when selected take that utcnow, throw it into your collection; lets say 4 fields were pressed/selected and utcnow stored in our collection; i want to PATCH to a Multiline Text column in SP List and append the field in order from newest to oldest (descending). I have this methodology already in use as "comments" for (employees), but wanted it for tracking/modifying purposes for (supervisors). I hope this makes sense

[@geralddahl9159]

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.😂😅😊

[@andrewhess123]

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.

[@geralddahl9159]

FYI - related example RE pass a collection to flow: kzbin.info/www/bejne/qpumco2uhrR1lbcsi=5TzPAMicnH7iu8mu

[@DomiVersaix]

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!

[@andrewhess123]

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.

[@imran002ali]

Hi Andrew, very nice, I liked the idea, selection, collection 😁, awesome, thank you for sharing your knowledge, it is very beneficial👍

[@andrewhess123]

Imran! Thank you very much once again!

[@jrpool88]

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

[@andrewhess123]

Hey Reggie, so I do have an older video and maybe its time to make a new one. But here is an older video:😀kzbin.info/www/bejne/nmTQXohtn7ahg7M&t I will write down to remake this video better!

[@jrpool88]

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 KZbin page).

[@andrewhess123]

@@jrpool88 Hi jr, I have a new video based on your question that will release on September 16th.

[@andrewhess123]

@@jrpool88 Hope that helps 😁

[@PatrickDoran]

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)

[@andrewhess123]

Patrick! Maybe it's a Canvas Virus Crisis? 😆😆😆 Thanks Patrick hope to chat again soon!