How to set a dropdown field when another dropdown field is chosen.

(1) Share

Report

Posted on by vez

I have two fields, both dropdowns.

Field A: Status (Closed, Cancelled, In process)

Field B: At Risk (Yes, No)

I would like, when field A is chosen to be either, closed or cancelled, field B be automatically set to no. I would also like for me to edit field b if necessary. I am trying this but it is not working. Can someone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

TylerPA 201 on at

Like (0)

Report
Copy link

Link copied!
Can you try this for your Field B (yes/no) dropdown?

If(Or(DataCardValue6.Selected.Value="Closed", DataCardValue6.Selected.Value="Cancelled"), "No")

With this setup I did not need to add anything else

Was this reply helpful? Yes No
vez 33 on at

Like (0)

Report
Copy link

Link copied!

It did not work. This is showing as a datacardvalue in the tree view not a dropdown.

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report
Copy link

Link copied!

Can you show your DataCardValue6 Items property? and the Items property of your field B dropdown

Was this reply helpful? Yes No
vez 33 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help!

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report
Copy link

Link copied!
No worries - thank you for helping work through it

So just to confirm, you are setup with below (unless I have your names incorrect), and still an error?

DataCardValue6 // items Choices([@'Shared Request Tracker'].'Request Status') and your dropdown // items Choices([@'Shared Request Tracker'].'At Risk') // default If(Or(DataCardValue6.Selected.Value="Closed", DataCardValue6.Selected.Value="Cancelled"), "No")

Was this reply helpful? Yes No
vez 33 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I keep getting an error.

Was this reply helpful? Yes No