Answered

Dropdown answers filtering

(0) Share

Report

Posted on by Dobryden

Hi,

I would like to ask if somebody could help me with this problem. I have a form with 5 dropdown menus which are generated from the SharePoint list data. In my SharePoint list I have a lot of different choices so I wanted to make a way which would filter the possible answers from following dropdown menus based on the answer from previous one.

Simply said: If I choose answer1 in dropdown1, it will filter possible answers in dropdown2.

I have this code which I pasted in dropdown2 (Items property). It works well but if replicate the process to dropdown3 I get error.

The part that is always red is: "Text(DataCardValue18.Selected.Value)". Could anybody please help me with it?

Thanks

If(
 Text(DataCardValue17.Selected.Value) = "FRONT";["X1"; "X2"; "X3"; "X4"; "X5"];
 Text(DataCardValue17.Selected.Value) = "REAR";["X6"; "X7"; "X8"; "X9"; "10"];
 []
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dobryden

Try this formula,

If(
DataCardValue17.Selected.Value = "FRONT",
["X1", "X2", "X3", "X4", "X5"],
DataCardValue17.Selected.Value = "REAR",
["X6", "X7", "X8", "X9", "X10"],
[]
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Dobryden 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for fast reply @Rajkumar_404,
I tried it but now I am getting error on the part with Value (look on image attached). Is there any other way?
Thanks for your help!

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What is the column name type displayed following DataCardValue19.Selected. ?

Was this reply helpful? Yes No
Dobryden 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure what you mean by the "column name type". Could you be more specific please?
Thanks

Was this reply helpful? Yes No
Anousha 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dobryden , instead of Selected.Value you should have options for the column names as specified above. If you remove .Value you should see the column options.
Here is a screenshot of your combobox columns.
Here is a screenshot of the column options you should see.

Was this reply helpful? Yes No
Verified answer

Dobryden 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Problem solved in the end. As I am European we have here slightly different syntax and sadly PowerApps wont tell you that. For reference: https://powerusers.microsoft.com/t5/Building-Power-Apps/Syntax-changes-according-to-language/td-p/502854

Was this reply helpful? Yes No