Choice column value based off another choice column

Occasional Visitor


I have a choice column (20+ choices) and a yes/no column on the same SharePoint list. When a specific choice is deselected from the choice column I want the Yes/No column to change from No to Yes. What's the best way to do this? I've been trying to do it through column formatting and it hasn't worked.

Thanks in advance!

1 Reply

@Dwood24 an easy way to do this is with a flow in Power Automate that just looks at whether the choice column has changed. But I don't quite understand what you mean by "when a specific choice is deselecrted". Do you mean that you want to change the Yes/No column when any choice value changes  to something else? Or is it that if the choice value is specifically Galicia and that is the one you are interested in, if you make it a blank value then change the Yes/No column to Yes?


Los Gallardos
Microsoft Power Automate Community Super User