Create Cascading DropDown with multi condition

(0) Share

Report

Posted on by Edvhdy

101

Good morning all,

I'm stuck on my app.

I want to do Cascading DropDown with several comboboxes from a collection.

I have a collection called colaA 3 columns:
Customer;
ValidClient;
tblClient (is this a column?)

In my first combobox I get the name of the customer,
then in the second combobox I retrieve the title according to the name of the customer chosen in the first combobox.
I added a third combobox which must recover the season but I can't do it I have an error message.

Can you help me ?

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zaphod88 502 on at

Like
a
(1)

Report
Copy link

Link copied!

If I get it right here, the last two comboboxes both depend on the first one. So you can try:

ComboBox4.Selected.tblclient.Saison

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Edvhdy ,
What do you mean about “recover the season” for your third combobox? From your formula/screenshot, I think you want to get the Saison column value based on above selection.
Since your second combobox is populated based on selection in the first combobox, you can try this formula for your third combobox:
LookUp(colCaA;Client=ComboBox4.Selected.Client).tblClient.Saison
Best regards,
Allen

Was this reply helpful? Yes No
Edvhdy 101 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-albai-msft

Yes I wanted to recover the season depending on the result of the combobox.

Your answer works perfectly. Thank you very much.

out of curiosity, what does the entity: tblClient correspond to?
is this a colCaA "collection"?

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Edvhdy ,
There is not a specific term to describe this tblClient, I usually think of him as an nested table(a table with only one record).
Best regards,
Allen

Was this reply helpful? Yes No