Step by Step Process to Send Email Notification Using Power Automate

How to Send Email Notification From A SharePoint List Using Power Automate

The step by step process of this flow is used to send an email notification to the user, that a particular choice in the SharePoint list with a certain type of fault has been added to the SharePoint list.

Technology Used

SharePoint provides a rich collaboration environment where people inside and outside your organization can work together, co-authoring documents.

Power Automate is a service that helps you create automated workflows between your favourite apps and services to synchronize files, get notifications, collect data, and more.

The SharePoint List

The Flow Used in Power Automate

When an item is created (Trigger)

Condition (Action)

Send email V2 (Action)

Step 1:

Trigger used

When an item is added

Step 2:

Add the action Condition to the flow

In the action, Conditions on the:

Left-hand side; From Dynamic Content, Status Value is Selected

Right-hand side: Out — Service is written

Step 3:

Add the action Send an email (V2) to the If yes of the Condition

This means that if from the SharePoint list, Out — Service is Selected from the Status, an email will be sent to the User.

Step 4:

Save the flow and Test

Challenges Encountered

I had an issue with the flow. After running the flow, I checked my Email and I did not get any message, decided to check the flow to know what the issue was

Error message:

ActionBranchingConditionNotSatisfied. The execution of template action ‘Send_an_email_(V2)’ skipped: the branching condition for this action is not satisfied.

The issue was that I was using Status instead of Status Value from Dynamic Content, the reason is that the Status column in the SharePoint List is a Choice data type.

Thanks for reading!!

You can find me on Linkedln, Twitter and Github

If you have any questions please reach out 😁