cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RBMN187
Frequent Visitor

Dropdown with multiple lists

Hello, so I built an app that can update columns in a sharepoint lists and I am looking for a solution so that the user can select from multiple sharepoint lists with the same column names from a dropdown menu. The selected list should then populate a gallery and the user could then update just the selected list. If needed he can go back to the selection screen and choose another list and do it again.

I have searched all over the web for something similar but all I find is how to patch multiple lists with a single input or how to combine multiple lists into one list.

Any help is appreciated.

Thanks,
M.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@RBMN187 

You cannot dynamically change lists on a Gallery.  

There are several ways to do this, but by far the best is to have your Dropdown get the records it needs from the appropriate list in a common schema, then reference those records for your gallery.

 

Other options include trying to create a common schema in the items property of the gallery, but this tends to end up with a lot of unneeded logic statements and formulas.

 

I hope this is helpful for you.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@RBMN187 

You cannot dynamically change lists on a Gallery.  

There are several ways to do this, but by far the best is to have your Dropdown get the records it needs from the appropriate list in a common schema, then reference those records for your gallery.

 

Other options include trying to create a common schema in the items property of the gallery, but this tends to end up with a lot of unneeded logic statements and formulas.

 

I hope this is helpful for you.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
RBMN187
Frequent Visitor

Just what I needed to hear and read. Thanks!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,148)