web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Choice of a field depe...

Power Apps

Suggested Answer

Choice of a field depend on choices of an another field

(1) Share

Report

Report

Posted on by ED-03090921-0

277

Hi,

I'm building my app and I have a problem. I have two drop down list but I want that for the choices of the second dropdown list depends on the choices of the first drop down list.

- For example below (if "Mesure" or "Scie" Or "Niveau" is selected from the field "VSM concerné", the choice of the field "Responsable concerné" is "Sandro".

For the 2 other option is like that :

- if "Pince" is selected from the field "VSM concerné", the choice of the field "Responsable concerné" is "Antoine"

- if "Logistique" is selected from the field "VSM concerné", the choice of the field "Responsable concerné" is "Adrien"

Can u help me pls ?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi

I created an example for you and I will explain.

1. You need to use the DefaultSelectedItems Property of the Second Combo

You need to reference the Value property of the First, and then do a LookUp to find the value you need. And you have to use Choice Selection Syntax.

What I have is 2 ComboBoxes. Both set to Single Selection.

Each is using the Same Choice, but its only an example so its ok.

I have ComboBox4 (the first)

And ComboBox4_1 (the second)

Now in the second ComboBox4_1 we add the following

Switch(ComboBox4.Selected.Value, [@'MyChoice2 (TableAS)'].'1', LookUp(Choices('MyChoice2 (TableAS)'), Value = [@'MyChoice2 (TableAS)'].'3'), [@'MyChoice2 (TableAS)'].'2', LookUp(Choices('MyChoice2 (TableAS)'), Value = [@'MyChoice2 (TableAS)'].'1'), [@'MyChoice2 (TableAS)'].'3', LookUp(Choices('MyChoice2 (TableAS)'), Value = [@'MyChoice2 (TableAS)'].'2') )

In your case, since ComboBox 1 has another Choice, you will change MyChoice2 to whatever the Choice is for ComboBox 1

In the LookUp, you need to change to be the Second ComboBox Choice.

You are using a lookup instead of a filter, because you only want 1 item selected in ComboBox2

But follow the syntax above.

Was this reply helpful? Yes No
ED-03090921-0 277 on at

Like
a
(0)

Report
Copy link

Link copied!

FLMike

Thank you for your help.

I tried this formula (no error in the formula):

Switch(DataCardValue3.Selected.Value;
'VSM concernée (Table_Data_SAP_Worflow)'.Mesure;
LookUp(Choices('Responsable concerné (Table_Data_SAP_Worflow)'); Value = 'Responsable concerné (Table_Data_SAP_Worflow)'.Sandro);
'VSM concernée (Table_Data_SAP_Worflow)'.Pince;
LookUp(Choices('Responsable concerné (Table_Data_SAP_Worflow)'); Value = 'Responsable concerné (Table_Data_SAP_Worflow)'.Antoine);
'VSM concernée (Table_Data_SAP_Worflow)'.Logistique;
LookUp(Choices('Responsable concerné (Table_Data_SAP_Worflow)'); Value = 'Responsable concerné (Table_Data_SAP_Worflow)'.Adrien)
)

But I have this error "invalid argument type
Location: DataCardValue9"

But anyway it's working.

Just now when I selected "Mesure" in combobox 1, I have only the choice "Sandro" in combobox 2
(see below). But what I want it's when I have "Mesure", it's select automatically "Sandro"
Can you help me to finish ?

Was this reply helpful? Yes No

Join the conversation