Answered

IF condition for dropdown

(0) Share

Report

Posted on by venky232

i have 2 dropdown choice column from sharepoint , when user select 1st dropdown ,it automatically display required value in 2nd dropdown.

below code i added in dropdown on change of 2nd one but it is not working any idea how to fix it ?

If(DataCardValue7.Selected.Value="A","Approved","rejected")

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

This should be added in the 'Default' property of the dropdown, not the change property.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

i added below code in default properties of dropdown of other coloumn. it is not working.
If(DataCardValue7.Selected.Value="A","Approved","rejected")

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

It may be a ComboBox and not an actual dropdown. If there is a property called 'DefaultSelectedItems', then your formula should go there.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

Issue
Expected Record value.
The property on this control expects Record
values. The rule produces Text values which are
incompatible.
Location
DataCardVaIue8
. Default
Haw to fix
Change the rule to produce a {0} value.

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report
Copy link

Link copied!
I need to know a little bit more about your 2nd dropdown. I think it might be a combobox. You can verify this by selected the dropdown and looking at the top of the data pane.

If it is a combobox, you will need to put the formula in the 'DefaultSelectedItems' property and not the Default property.

Try changing it like this:

If( DataCardValue7.Selected.Value="A", ["Approved"], ["Rejected"] )

You will also want to provide some logic as to when this applies. This ensures that if the item is in view mode or being edited, it keeps the original value until it's changed. Something like this:

Switch( DataCard7.Selected.Value, "A", If(FormX.Mode <> FormMode.View, ["Approved"], ["Rejected"], Parent.Default )

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

yes it is combobox it is working if i add if condition in 'DefaultSelectedItems' property.
but where to add switch condition. my combobox is in view mode

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

The Switch condition is just an expanded version of the first condition. Now that you know the first condition works, replace it with the Switch condition and then test. It uses the Mode of the entire form, not the combobox.

When someone opens an item in SharePoint without clicking edit, it's initially in View mode. When in view mode it needs to show the current saved value. When the form is in Edit or New mode it will display the value based on the selection in DataCardValue7.

Was this reply helpful? Yes No