Microsoft Flow or PowerAutomate: Trigger email based on user input

In this tutorial, we will discuss how to send or trigger an email based on user input in Microsoft flow or Power Automate.

Microsoft Flow: Trigger email based on user input

I have posted this article as requested by one of the users in my other article which I shared the link over here.

Requirement: I have a SharePoint list with the following columns:

  • Department (Choice): IT, HR, Sales, Finance
  • Project Completed (Date)
  • Program Completed (Date)

He want to get an email notification if the following requirements are met.

If Department equals HR
Or if Department equals Finance
And if Project Completed is not equal to null
Or Program Completed is not equal to null

Let us try to do step by step how to get the issue.

Step 1: Log in to your SharePoint Online Site -> Create a List as below. This list contains four custom columns that are mentioned above.

Trigger email based on user input

Step 2: Next go to Power Automate -> Create a New flow for this List.

Microsoft flow Trigger email based on user input

Step 3: Next you have to choose the flow which will fulfill this requirement. So here I have selected Send a Customized Email when a new SharePoint List item is added.

Microsoft Flow or PowerAutomate: Trigger email based on user input

Note: You can create an empty flow and add your condition or you can use this one and remove not required action fields from flow.

Step 4: Once my flow gets created, you have to add a condition and you can provide the field name like below.

Microsoft Flow Trigger email based on user input

Step 5: Next add an email in If yes statement. If any of the above conditions get satisfied, it will trigger an email otherwise no email will trigger.

PowerAutomate Trigger email based on user input

Step 7: Inside If Yes, add an action called Send an Email notification. Next, configure your email subject and body based on your requirement.

Microsoft Flow Trigger email based on user input

Step 8: Next save your flow and run it to test. When I added one item into a list, My condition gets satisfied so I receive an email in my outlook.

PowerAutomate Trigger email based on user input

You may like following flow tutorials:

In this tutorial, we learned how to Trigger email based on user input in Microsoft flow or Power Automate.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>