Answered

send Email with options!

(0) Share

Report

Posted on by zak15303

Hello Everyone,

Is there a way to save the output result of the email with options on a sharepoint list column somehow? I have a email with option action on my flow with two option yes and no. If the user presses yes or no i want that output to show on a column as yes or no? Is there a way?

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Verified answer

MattWeston365 1,701 on at

Like (5)

Report

Hi @zak15303

When you use the Send Email with Options action, effectively the Flow will pause until it receives a response. Once it received a reply it can then do something with the response. The example below shows the response being used to create a new list item in SharePoint.
If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.

@MattWeston365

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi MattWeston365,

Your post was great and I was trying to do something similar but I am stuck. This is almost my first post.

Question is - Is there a way to track user's responses in an Excel (Business) file?
Background is - I have multiple people's email ID mentioned in "To" field and I have only 2 choices in "User Options" field. When I try to add an action to add a row in Excel (Business), it does not have field to record user's email ID so I am unable to record user's email, which means I am unable to track which user responded. Can you help with this please?

Thanks in advance!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

What If I want to use Send Email with Options action while using Gmail as connector. Then how will proceed to get same result.
Please help.

Was this reply helpful? Yes No
Ellis Karim 11,684 Super User 2025 Season 2 on at

Like (0)

Report

I don't think that the same features are available for Gmail, and Google services aren't going to integrate like Microsoft's native services, such as Outlook, Approvals Workflow and OneDrive/SharePoint. And for these approval types of work flows, you and your users are going to need to use accounts in your MS 365 Tenant.

See some possible alternatives:
How to turn a Google Sheet into a simple vacation requesting app
https://techandeco.medium.com/how-to-turn-a-google-sheet-into-a-simple-vacation-requesting-app-843e2c8bf2a4
How to use Google Forms to create an approval workflow
https://formapprovals.com/blog/how-to-create-an-approval-workflow-with-google-forms

Ellis

Was this reply helpful? Yes No
ashishjpd 2 on at

Like (0)

Report

Is there a way to change the contents of the Email Body at multiple places every time an item action is triggered?

Adding columns is not an option because then there will be extra 10-15 columns to accommodate all data.

Was this reply helpful? Yes No
LaurieL 30 on at

Like (0)

Report

Hello,

I know the original message is old but I have the same question. I do not want to add a new item to the SharePoint list, I want to update a column. How can I do that?

Was this reply helpful? Yes No
Aimthedame 220 on at

Like (0)

Report

Use Update Item to update without creating a new item. It allows you to choose the column you want to update.

Was this reply helpful? Yes No
LaurieL 30 on at

Like (0)

Report

Thank you @Aimthedame. I keep getting stuck at different stages of this flow. I need the flow to update the particular row of the list that pertains to the MS Form received. I also need to use Manually Trigger a Flow so I can input the specific email addresses of those who need to respond. I don't know how to structure this flow so it can use the form response ID or other information to identify which row to update.

Was this reply helpful? Yes No
Aimthedame 220 on at

Like (0)

Report

I don't think I understand what you're trying to do. Are you collecting data from more than one form?

Was this reply helpful? Yes No
LaurieL 30 on at

Like (0)

Report

I am collecting data from a form that creates a new list item. Then I am sending the form information for review and approval using send email with options. The options will indicate approval, rejection, or table. I'd like to update the list item with the response chosen by the email recipient. It won't always be the same email recipient, which is why I am manually triggering the flow so I can populate the email address. I hope that makes sense.

Was this reply helpful? Yes No