Setting a dropdown field based on another dropdown field

[jjohnson]

Hello,

I am trying to set a dropdown value of a choice field (from SharePoint column) based on the value of another column. This is for submitting a helpdesk ticket. Column 1 is "Issue Category" which is a dropdown. If this field = "COVID-19" then set field "Is this creating a work stoppage?" to YES.

If(DataCardValue11.Selected.Value,
"COVID-19",
ThisItem.WS.Value
)

The above and a few others that i tried are not working. Any suggestions?

Thank you, in advance.

[KimBim · Accepted solution]

Hey @jjohnson, 

if you have a Choice Field then you might use the "DefaultSelectedItems" Property and put the following code into it:

If(dcvIssueCat.Selected.Value="COVID-19";

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
Id:0;
Value:"YOURVALUE"
};
Parent.Default
)

I'm from germany, so you might replace the ; with ,

Hope this helps you 🙂 

[jjohnson]

Thank you, @KimBim! This worked perfectly!