Answered

Send overdue email from a document library in sharepoint

(0) Share

Report

Posted on by Jenine1_1

Can someone please run through the steps to set up a workflow to send an 7 day overdue email from a sharepoint document library

I have a document library that has a column for 'response date' (Date) and a column 'review confirmed by' (people picker).

i want a flow that

1. recurrence - I have done

2. get files (properties only) This is the only one i can find for document library) - i have this and added filter query i used filter query ResponseDate eq '@{addDays(utcNow(), -7, 'dd/MM/yyyy')}'

3. if column response date is 7 days overdue and review confirmed by column is blank (what do i do here)

4. send an email- i cant get this to work even with a apply to each

Please help

thanks

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Jenine1_1
Try 2 things.

1)
In filter query write
ResponseDate lt 'addDays(utcNow(), -7, 'dd/MM/yyyy')'

2) Use send email v2 of outlook. The email notification V3 bugs out.

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jenine1_1 ,
Do you mean to filter out files where [response date] is 7 days ago and [review Confirmed by] is empty?
Filter Query in [Get files (properties only)] is not good for filtering (people picker)
Maybe you could try:
Add [Get file properties] to get the detailed information of the [review confirmed by] column.
Add [Condition] to judge whether the [review confirmed by] column’s DisplayName is empty.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Jenine1_1 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

thank you for your insite.

i have done as you have suggested but still not working

the reviewed by column is not a people picker it is a text column. i have a flow that when the person responsible clicks on a link via an email it sets of another workflow to confirm that they have done something. that then updates the reviewed by column with their name and date. so the condition for reviewed by doesnt have /display name - it is - outputs('Get_file_properties')?[body/reviewed by'].

the flow runs but does not send email
not sure why

thanks

Was this reply helpful? Yes No
Jenine1_1 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for this, I did change the eq to lt and changed the email to emailv2 but it still didnt send an email

thank you for your help

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jenine1_1 ,
could you please show the output of Get_file(property only )?
I guess output is null, so the subsequent content is not implemented.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Jenine1_1 91 on at

Like
a
(0)

Report
Copy link

Link copied!
is this what you need
4929-b0ca-e0d1d240a810","MS-CV":"QsK23eT2KUmwyuDR0kCoEA.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com securebroker.sharepointonline.com;","MicrosoftSharePointTeamServices":"16.0.0.22928","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"true","Cache-Control":"max-age=0, private","Date":"Wed, 12 Oct 2022 02:31:03 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Tue, 27 Sep 2022 02:31:03 GMT","Last-Modified":"Wed, 12 Oct 2022 02:31:03 GMT","Content-Length":"12"},"body":{"value":[]}}
here is my entire flow

Can i put in the filter query in get files (properties only) - this filter query would that be better somehow?
and then change something in the apply to each would that work?

thanks

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jenine1_1 ,
"body":{"value":[]}}
This value is null, after filtering, the trigger does not filter out anything.
I guess your Filter Query may be wrong
Here are some link for your reference:
Power Automate SharePoint Get Items Filter Query + 12 Examples - EnjoySharePoint
Solved: power automate get files (properties) only filter ... - Power Platform Community (microsoft.com)
Best Regards
Cheng Feng

Was this reply helpful? Yes No