Answered

Data Sources Within A Dropdown list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Im trying to create a Dropdown list that contains different data-sources as options within that dropdown list, From that selection on the dropdown list, Im trying to access the data from the data-source within my next screen where they edit the data.

All Help would be appreciated,

Blake

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
In general, this might be able to accomplished this using a SWITCH function on the screen where the data is edited. Something like this would be your code in the Items property of your control

Switch(DropDown.SelectedText,
“Option1”, your_datasource_one,
“Option2”, your_datasource_two,
“Option3”, your_datasource_three)

But the more difficult part comes after: setting up several controls that can handle any data source.

—-
Please Accept As Solution if this post answered your question so others may find it faster. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Im trying to set the database from the initial page. So its where i have my dropdown list which the project numbers (all have corrisponding sheets and data sources with the project numbers), Then once the user presses the button, It selects the datasource into the variable called datasource then redirects the user to a second page which has the galary with all the data presented. I would preferably want some advice that did not revolve around altering much on the editing page.

Thanks,
Blake

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I think this cannot be achieved so far. DataSources cannot be displayed inside any control. You can only check them in design mode. Consider to add an idea in below forum if you really need this feature:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Mona

Was this reply helpful? Yes No