Answered

send email to people who didn't update

(0) Share

Report

Posted on by Community Power Pla...

We have a share point list with multiple contributors. We are trying to build a flow that sends a reminder email to only the people who have not updated in five or more days.

I am having trouble building the flow to get the email to send to these people instead of everyone.

Hope someone can help me!

Categories:

Business Process Flows

All responses (6)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: send email to people who didn't update

HI @Anonymous,

Do you mean that if a user existing in another list does not exist in contributors list, which means he/she does not update?

If so, I think you just need to try as below:

formatDateTime(item()?['Created'], 'yyyy-MM-dd') formatDateTime(addDays(utcNow(),-5), 'yyyy-MM-dd')
Community Power Pla... on at

Like (0)

Report

Re: send email to people who didn't update

Hi, so I have a list of email address who has the permission to edit the list. What I am trying to achieve is that if person in that email list did not make updates in 5 days, they will receive an email notification.
Ryan_B 446 on at

Like (0)

Report

Re: send email to people who didn't update

Can you provide more details from your SharePoint list? Preferably a screenshot with the columns with some non-sensitive data, as well as what your qualifier is for determining who to send the reminder to.
Community Power Pla... on at

Like (0)

Report

Re: send email to people who didn't update

Hi, thanks for helping out. So I have a list of email addresses of users who have the permission to make edition in the sharepoint list. What I am trying to achieve is that if person in that email list did not make updates in 5 days, they will receive an email notification.
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: send email to people who didn't update

Hi @Anonymous,

Could you please tell me that how you define a user is not updating? Is there a field to define?

If you want to send a reminder email to users who are not updating the a special field, please check the demo as below.
Ryan_B 446 on at

Like (0)

Report
Re: send email to people who didn't update

Is this using the Approvals system, or simply in SharePoint only?

If you're using the Approvals system, you would need to set your approval action to time out after 5 days and have a section of your flow run if the approval action times out. This would need to get the items of that row, filter the ones where the approval column is still pending, and send the email out to those individuals.

If you're only using SharePoint and updating columns as someone responds in some fashion, whether it be through Power Apps, an adaptive card in Teams, etc., then you may want to separate the two flows. You can have a secondary flow that runs once a day, sets a variable to something like
formatDateTime(addDays(utcNow(),-5), 'd')
to get a specific date 5 days ago, and use that as your Get items filter query. This will return the rows where the created date is equal to the variable date. You will then need to separate out the ones where the appropriate column hasn't been updated, possibly through a Condition action.