cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Add new list item to Sharepoint from Outlook response

Hello,

 

I am looking for a proper flow that will allow my list in Sharepoint to display 'Approved" in one of the columns after an email is sent out and a user clicks the "Approved" button.

 

So when an email comes in to approve and the approver clicks the button "Approve" the list in Sharepoint column will be updated to input the text "Approved" or "work in progress".

 

How would I go about doing so? I already have the flow that sends the email I just need to have it that the SharePoint list item will be updated to say "Approved" in the last column.

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Add new list item to Sharepoint from Outlook response

@trini1980 

You should be using the Send Email with options action to send the email.  You can define buttons for the user to click in the email such as Approve and Reject.

If you use this action, your Flow will pause until a response from he email is received - you will know which button was clicked (use Selected Option from Dynamic properties).

With that info, you can update your SharePoint list.

Here is an example:

EmailOption1.jpgEmailOption2.jpgEmailOption3.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

7 REPLIES 7
Highlighted
Super User III
Super User III

Re: Add new list item to Sharepoint from Outlook response

@trini1980 

You should be using the Send Email with options action to send the email.  You can define buttons for the user to click in the email such as Approve and Reject.

If you use this action, your Flow will pause until a response from he email is received - you will know which button was clicked (use Selected Option from Dynamic properties).

With that info, you can update your SharePoint list.

Here is an example:

EmailOption1.jpgEmailOption2.jpgEmailOption3.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Highlighted
Helper I
Helper I

Re: Add new list item to Sharepoint from Outlook response

Yes, but how can I update the SharePoint list with automation just on the click? I do not want to update it manually.

 

Thanks

Highlighted
Super User III
Super User III

Re: Add new list item to Sharepoint from Outlook response

@trini1980 

See my example and screen shots above and post here if you have additional questions.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper I
Helper I

Re: Add new list item to Sharepoint from Outlook response

Ok but int he ID field nothing shows up for an option to choose from?

 

2019-09-23 2-11-41 PM.jpg

Highlighted
Super User III
Super User III

Re: Add new list item to Sharepoint from Outlook response

@trini1980 

When you click in the Id column, and go to Dynamic properties, what do you see?  You should see the ID available to you there.

Can you post a screen shot of what you see in Dynamic properties when click click on the Id area?'

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper I
Helper I

Re: Add new list item to Sharepoint from Outlook response

2019-09-23 2-11-41 PM.jpg

Highlighted
Super User III
Super User III

Re: Add new list item to Sharepoint from Outlook response

@trini1980 

What trigger are you using?  Is it For a Selected Item?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,738)