Answered

query on cascading dropdown menus not working

(0) Share

Report

Posted on by SM-24091201-0

Hi all. Trying to do a simple cascading dropdown ie one list with the Title column as the first dropdown set of options using Distinct. Then I need the 2nd dropdown to return the result (text) to the second dropdown to then select the next option in column 2. For some reason I cannot set it to return a "result" and only a value, which then in turn gives me a pointless count of the resultant text in the TItle column. It seems so simple but I've watched multiple videos on cascading dropdown menus for days on end and tried everything but nothing works. I'm assuming it's because my output is a "value" and not a "text result". There is no way to switch this around though. Any advice please?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @SM-24091201-0,

Your code actually looks fine. You don’t need to change the formula.

Just make sure in the Dropdown properties you set the Value field to the column you want to display as the choice.
So:
Value → select the field you want users to see (text column)

If this solution fixed your issue, please mark it as the verified/accepted solution.

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

SM-24091201-0 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Great, thanks very much. That seems to have worked. Previously there was no way to select the 2nd column from the list and suddenly it appeared. I don't know what I pushed but since I started this whole project the 2nd column would not appear as an option for some strange reason. Not sure how it magically started appearing but I'll take it. Thanks very much for your help @Kalathiya .

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @SM-24091201-0, Great!

If this solution helped, please mark it as the verified answer so it can help others in the community 😊

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No