How to Send an email with options in Power Automate?

In this Power Automate tutorial, we will see how to send an email with options in Power Automate.

Scenario: We have a below SharePoint list ‘Session Feedback’ which collects the feedback for sessions from attendees for a particular batch.

The SharePoint list contains the below column:

  • Batch Id(Title)- Single line of text
  • Attendees name: Person
  • Date: Date/Time
  • Session on: Choice
  • Feedback: Single line of text
  • Comments: Multiple lines of text
send email with options power automate

For this, we will create an Instant cloud flow, where we will pass the Batch id. Based on the Batch id it will get the items and send an email to the Attendees. Once the attendees give the feedback, it will be updated on the SharePoint list.

Now let’s create the flow that will send an email and collect the feedback using Power Automate.

How to send an email with options using Power Automate

Here we will see an example of how to send emails with options using Power Automate.

Before creating the flow in Power Automate, just set up the SharePoint list with the above columns.

Step 1: Log in to Power Automate and click +Create -> select Instant Cloud flow.

Send email with options in Microsoft power automate

Then provide the flow name and select the Manually trigger a flow. Then click on Create.

Send email with options in power automate

Now you can see Manually trigger a action is added to the flow. Expand the action and click on +Add an Input. Select the Input type as Text. Provide the field name as Batch Id.

How to send email with options power automate

Step 2: Now we will get items from the list, so click on the +New step -> select Get items action.

See also  Power Automate OData filter query with examples

Then provide the below information:

  • Site address: Select or Provide the SharePoint site address.
  • List name: Select the list.

Then click on Show Advanced options

  • Filter query: Select or provide the filter query:
Title eq '@{triggerBody()['text']}'
How to send email with options Microsoft power automate

Step 3: Next, we will send an email to attendees with the option, so, click on the +New step -> select ‘Send email with options’ action. Then provide the below information:

  • To: Select the Attendee’s email from the dynamic content. That will automatically add Apply to each action.
  • Subject: Select or provide the subject
  • User options: Provide the options ‘Good, Average, Poor’
  • Header Text: Provide the Header text.
  • Selection Text: Provide the selection text
  • Body: Provide the body of the email.
send email with options Microsoft power automate

Step 4: Next, we will update the feedback in the SharePoint list. So, click on Add an action -> select Update item action. Then provide the below information.

  • Site address: Select or Provide the SharePoint site address.
  • List name: Provide the SharePoint list name.
  • Id: Provide the Id from dynamic content
  • Title: Provide the title from dynamic content.
  • Date: Provide the current date, so for this, provide the below expression:
formatDateTime(utcNow(),'yyyy-MM-dd')
  • Feedback: Provide the Selected options from dynamic content.
send email with options using Microsoft power automate

Step 5: Now save the flow and run the flow manually. For this, click on the test button -> select manually and click on Test. Then provide the Batch Id like below. Click on Run Flow.

send email with options using power automate

After that, you can see the email send to the corresponding attendees. In this case, I get the below email. Once I select the feedback options, we can see the success screen. You can see your flow run successfully.

Power Automate send email with options

At last, you can see the feedback is updated in the SharePoint list.

Microsoft Power Automate send email with options

Conclusion

In this Power Automate tutorial, we saw an example of sending an email with options using Power Automate.

See also  Power Automate Trigger Conditions

You may also like:

>