Power Platform Community Forum Thread Details

Hello, i am trying to create a flow that has two conditions and can't get it to work. I have a sharepoint list and need to send an automated email dependent on two columns.

The scenario is this:

I have a column named Grant Agreement that is a multiple choice - yes, no, and n/a responses and a column named Department with multiple choice of department numbers - 120, 130, 141, etc. When a staff person modifies the line and changes Grant Agreement to the yes response, I need an automated email to be sent to a different staff person, however who the email goes to depends on the Department number. i keep getting hung up on the switch action, it keeps putting in a for each action and im about at the end of the road. please help thanks!

Screenshot 2026-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Using flows

@CT-11051751-0

1. In SharePoint, first confirm your columns:
- Grant Agreement = Choice column (Yes/No)
- Department = Choice column

2. Create a new Automated Cloud Flow in Power Automate

3. Use trigger:
- “When an item is created or modified”

4. Add a Condition action:
- Left side = Grant Agreement Value
- Operator = is equal to
- Right side = Yes

5. In the YES branch:
- Add a Switch action

6. In the Switch “On” field use:
- Department Value
If Power Automate creates an Apply to each, delete it and instead use this expression in the Switch field:

text triggerOutputs()?['body/Department/Value']

7. Add Switch cases:
- Case 120
→ Add “Send an email (V2)”
→ Send to staffperson120@email.com

- Case 130
→ Add “Send an email (V2)”
→ Send to staffperson130@email.com

- Case 141
→ Add “Send an email (V2)”
→ Send to staffperson141@email.com

8. In each email action, customize subject/body as needed.

9. Save the flow and test by editing a SharePoint item:
- Set Grant Agreement = Yes
- Select a Department number
- The correct email should send automatically.

If the loop still appears, it means the Department column is still configured as multi-select in SharePoint.