How to send email for certain leave type in Power automate in sharepoi

Hello,

To achieve this in Power Automate (formerly Microsoft Flow) for your SharePoint Online Leave Request List, you can create a flow that only sends email notifications when the Leave Type is "VACATION" or "PTO".

Here’s how to do it step by step:

1. Trigger:

Trigger: When an item is created or modified
Site Address: Select your SharePoint site
List Name: Your Leave Request list

2. Condition: Check Leave Type

After the trigger, add a Condition control:

Expression:

or(equals(triggerOutputs()?['body/LeaveType'], 'VACATION'), equals(triggerOutputs()?['body/LeaveType'], 'PTO'))

3. If Yes (LeaveType is VACATION or PTO):

Add an action: Send an email (V2)
- To: Person field (e.g., Created By or Manager)
- Subject: Leave Request: @{triggerOutputs()?['body/LeaveType']}
- Body: Include request details (dates, type, requester, etc.)

4. If No:

Leave it empty (no actions).

Good Luck!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari1y ago
Hello,

To achieve this in Power Automate (formerly Microsoft Flow) for your SharePoint Online Leave Request List, you can create a flow that only sends email notifications when the Leave Type is "VACATION" or "PTO".

Here’s how to do it step by step:

1. Trigger:
- Trigger: When an item is created or modified
- Site Address: Select your SharePoint site
- List Name: Your Leave Request list
2. Condition: Check Leave Type

After the trigger, add a Condition control:
- Expression:
```
or(equals(triggerOutputs()?['body/LeaveType'], 'VACATION'), equals(triggerOutputs()?['body/LeaveType'], 'PTO'))
```
3. If Yes (LeaveType is VACATION or PTO):
- Add an action: Send an email (V2)
  
  To: Person field (e.g., Created By or Manager)
  
  Subject: Leave Request: @{triggerOutputs()?['body/LeaveType']}
  
  Body: Include request details (dates, type, requester, etc.)
4. If No:
- Leave it empty (no actions).
Good Luck!
0