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 Apps Super User Class of 2020

Check it out!


Power Apps 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


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

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