send Email with options!

[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? 

[MattWeston365 · Accepted solution]

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

[Anonymous]

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!

[Tiksha]

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.

[ekarim2020]

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-843e2...

How to use Google Forms to create an approval workflow

https://formapprovals.com/blog/how-to-create-an-approval-workflow-with-google-forms

Ellis