cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
felljay
Regular Visitor

Flow to Update SharePoint List When Action Expired

Hi All,

 

Looking for some help, I have a flow that I have created than on the submission of data in a Sharepoint List it automatically triggers the action "send email with options". I have been able to configure the flow that after X period of time that original email expires and sends a new email with options.

 

What I cannot figure out is how to, on the the email expiring to update the SharePoint list in a column named status with an expression such as "Reminder Email 1 sent".

 

Does anyone have any tips?

 

Thanks!

3 REPLIES 3
v-xida-msft
Community Support
Community Support

Hi @felljay,

 

Could you please share a screenshot of your flow's configuration?

Could you please show more details about your SharePoint list?

 

I have made a test on my side and please take a try with the following workaround:

    • Add a "When an item is created" trigger, specify Site Address and List Name.
    • Add a "Send email with options" action, click "Menu" button-> Settings option to configure the timeout for this action. I assume that you want to configure the timeout of this action as two days, the screenshot as below:1.JPG
    • Add a "Update item" action,  specify Site Address and List Name. Id field set to ID dynamic content of the trigger, Title field set to Title dynamic content of the trigger. Status field set to "Reminder Email 1 sent". Click "Menu" button-> Configure run after option, within the "Update item" should run after panel, select "has timed out" option as below:2.JPGNote: The Status column is a Single line of text type column in my SharePoint list. 

Image reference:3.JPG

The flow works successfully as below:4.JPG

 

5.JPG

 

 

Best regards,

Kris

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-xida-msft,

 

I have tried that as per the set up below, but when testing it then says bad request and fails to update the list.

 

For some reason i cannot seem to upload sceen shots of the flow and the error?

 

 

@v-xida-msft i know can:

 

Flow set up:

Flow setupFlow setupBad Request ErrorBad Request Error

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,025)