Showing results for 
Search instead for 
Did you mean: 
Level 8

Re: Data Sources as a Dropdown

If you add each sharepoint list to powerapps then you get connection names for instance like: TimeEUR,ReqEUR, TimeAPAC, ReqAPAC, etc (the assumption was they are limited to few sharepoint lists and not unlimited)


Then you do this on screen

OnVisible = ClearCollect(DataSources,{DSName:"EUR Request"}, {DSName:"APAC Request"}) 
//etc source friendly names

and on the gallery:


Switch(  Dropdown1.Selected.Value,
       "EUR Request", ReqEUR,
       "APAC Request", ReqAPAC

of course you bind also the dropdown to Datasources collection: Items = Datasources, Value = DSName

Level 10

Re: Data Sources as a Dropdown

Thanks for all your help! I appreciate it. I will try this out, but i am currently blocked on another issue:

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,021)