Data Sources as a Dropdown

[bdodu]

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

[RussellGove]

Thanks for all your help! I appreciate it. I will try this out, but i am currently blocked on another issue: https://powerusers.microsoft.com/t5/General-Discussion/Getting-message-quot-An-Error-occurred-on-the...