Forum Discussion
If list multi-select choice column contains certain value, auto-populate flag column in related list
I have a SharePoint list called List1 with columns ID (single-line text) and Type (multi-select choice): ID Type ---- ------ ID1 Apple ID2 Apple, Pear ID3 Pear, Banana, Apple ID4...
You can do this with a simple Power Automate flow.
When an item is created or updated in List1, check whether the Type column contains "Pear". If it does, update the related item in List2 and set Has_Pear = Yes. If not, set it to No.
Since the value (lookup)is coming from another list, a calculated column won't work here. A Power Automate flow is the simplest and most reliable solution.