How to Combine Two SharePoint Lists into a Collection Using an ID | Power Apps | 2024 Tutorial

[@intboom]

This is the only sane and functional description of how to use PowerApps+Sharepoint Lists that I've ever seen. You basically saved my life with this one concise video.

[@michaelalex2322]

Happy to hear lol

[@onesoldierserving]

I dare not describe the gymnastics I have been trying to do in order to accomplish this thing that you made so simple. I just KNEW there was an easy way to do it. But, my google-fu failed me until I remembered SQL and used the word "Join." Thank you SO much for making this video!

[@michaelalex2322]

@@onesoldierserving lol glad it helped!

[@andrianarowe4946]

Great video! Any way you could show how to do this with a list that has multiple columns and you want to connect to the master and pull in all the columns.

[@steph50s]

Great video! Is there a way of using Power App to go the other way around? Create a SharePoint list from the master collection?

[@onesoldierserving]

You could invoke a Power Automate flow from the Power App and pass in and iterate over the collection to create a list.

[@SandyZhao-Sunshine]

Thanks, Michael, That's really what I want. May I have a question, we both know that the collection does not support delegation. Can I directly use the AddColumns instead of using the ClearCollect. I tried but failed. Do I miss something?

[@HeyTezza]

Awesome thank you so much, now I just have to work out how to modify as mine is a number field, I'm assuming wrapping in Value()

[@darrenhickey1923]

Is PowerApps the best way to do a count of items in multiple lists, and if so, can filters be applied to that count?