cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trini1980
Level: Powered On

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
Super User
Super User

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
Super User
Super User

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

trini1980
Level: Powered On

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

Super User
Super User

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
trini1980
Level: Powered On

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

Super User
Super User

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
trini1980
Level: Powered On

Re: Add new list item to Sharepoint from Outlook response

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

Super User
Super User

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

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (4,859)