If you are watching this video I 100% recommend the next video I created for the next week. There is a formula in the description as well using the Ungroup function instead: th-cam.com/video/XCjHb9djlCE/w-d-xo.html
Hi Andrews, wouldn't be more efficient and easier to use ungroup function : Ungroup(AddColumns(colMyCollection;splittedValues;Split(values;","));splittedValues)
After doing a little reading, this is what I've found, I do think Ungroup is another video though! 😍 Thank you! When to use each: Use Ungroup when you need to simply flatten a grouped dataset, and you're not performing individual transformations on each record. So with a SharePoint multi-select this is perfect. Use ForAll when the column is separated by a comma delimiter in a single line text field.
Hi Alexandre, I will be using your comment/question in my next video. Thank you so much for the idea! Will put the link in tomorrow morning 😀Thanks again!
I cannot, for the life of me, get this to work in my RL scenario. :( My data source is a sharepoint list with the comma separated data already set as a single line text column. I keep getting hung up on the This Record part. Is this possible for pre-existing data as opposed to creating the table as you did within PowerApps ?
@@andrewhess123 Hi Andrew...I was using the split but I wasn't working for me Miraculously, it started to work just now but somehow it isn't myNewTable but I got the splits on the original MyCollection !! LOL Thank you so much for your invaluable assistance !!!!!!
If you are watching this video I 100% recommend the next video I created for the next week. There is a formula in the description as well using the Ungroup function instead: th-cam.com/video/XCjHb9djlCE/w-d-xo.html
Nice! I was just suggesting this as an alternative to doing nested galleries - next time I'll send the video!
Ahhh! Interesting good point!
Hi, Andrew! Great YT channel!!
(V.B.)
Hey VB! Thanks for the truth and light! 😀
Hi Andrews, wouldn't be more efficient and easier to use ungroup function : Ungroup(AddColumns(colMyCollection;splittedValues;Split(values;","));splittedValues)
Seems pretty good. Will have to try it out.
After doing a little reading, this is what I've found, I do think Ungroup is another video though! 😍 Thank you!
When to use each:
Use Ungroup when you need to simply flatten a grouped dataset, and you're not performing individual transformations on each record. So with a SharePoint multi-select this is perfect.
Use ForAll when the column is separated by a comma delimiter in a single line text field.
Hi Alexandre, I will be using your comment/question in my next video. Thank you so much for the idea! Will put the link in tomorrow morning 😀Thanks again!
@@andrewhess123 my pleasure
Formulas are in the description if you just want the answer 😀
Awesome…thank you so much ! I was having the hardest time with the nesting for all !!
I cannot, for the life of me, get this to work in my RL scenario. :(
My data source is a sharepoint list with the comma separated data already set as a single line text column. I keep getting hung up on the This Record part. Is this possible for pre-existing data as opposed to creating the table as you did within PowerApps ?
@@cddl629 Are you using the split command? Since it's comma delimited you need to split it.
@@andrewhess123
Hi Andrew...I was using the split but I wasn't working for me
Miraculously, it started to work just now but somehow it isn't myNewTable but I got the splits on the original MyCollection !! LOL
Thank you so much for your invaluable assistance !!!!!!