How to create Enums Dropdown in Power App

[Anonymous]

Hello Experts i want to achieve below functionality.

i want to crate one dropdown containing two options 1. Projects 2. opportunities 

when user will chose projects two dropdown should come down too chose ProjectID and Project Name , similarly when user will chose opportunities OpportunitieID and OpportunitieName  should come. 

Projects and opportunities i am fetching from SQL table. both are different table , please advise any blog or video for the same if any  

[v-jefferni · Accepted solution]

Hi @Anonymous ,

Could you please share more details about your scenario? Would you like to use one Dropdown Box to let user choose which table and field would display in the other two Dropdown Boxes?

If so, and if the column names are the same in that two tables, which means both tables have ID and Name fields, you could follow below steps:

1\ Add a Dropdown box, set Items to:

["Projects","Opportunities"]

2\ Add two Combo boxes Combo1 & Combo2, set Items of both:

Switch(Dropdown.Selected.Value,"Projects",'[dbo].[Projects]',"Opportunities",'[dbo].[Oppertunities]')

set DisplayFields of Combo1 to ["{ID}"] and Combo2 to ["{Name}"] on the right hand pane

3\ Set "Allow searching" and "Allow multiple selection" to Off on both Combos.

If the two table have different field names, you may have to add 4 combo boxes, 2 of them set Items to Projects and the other set to Opportunities. Then you could control which two combos would show up by set the Visible property, for example, combos of Projects set to:

If(Dropdown.Selected.Value = "Project", true, false)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Anonymous]

hello @v-jefferni  , You are awesome Thank you so much for helping me, this is exactly my requirement is and i have implemented that as per the steps you suggested. 

I have one more requirement here i want cascade between ProjectID ProjectName and OpportubityID opportunity name , mean when i will chose Project ID only the respected Project name should come not all. 

i have used the first method where my column name are same in both table.

I am writing this to my combobox2 but not working 

Filter( ["NAME"],["ID"]=ComboBox1.Selected.value)

Please advise 

[v-jefferni · Accepted solution]

Hi @Anonymous ,

Try set DefaultSelectedItems of the Combo2 to:

LookUp(Switch(Dropdown.Selected.Value,"Projects",'[dbo].[Projects]',"Opportunities",'[dbo].[Oppertunities]'),ID = Combo1.Selected.Value)

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Anonymous]

Hello @v-jefferni , Thank you so much again and appreciate your contribution  , This is working as i was expecting. 

Have a great day