Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Data Sources as a Dropdown

Hi Everyone,


Is there a way to populate a drop down control with all data sources currently connected to a particular application. For Example If i have 5 sharepoint lists with the same fields and want to be able to select a specific list to view its content. 


Thanks for the help,



Responsive Resident
Responsive Resident

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


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

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (15,996)