Answered

Doc Approval reminder email - send 1 per PM

(0) Share

Report

Posted on by almond_boi

Hello -

PM's have multiple docs from a shared Sharepoint library assigned to them for approval. I'd like to write a flow that, at 3 pm, checks for docs still in "New" status and reminds PM's to log on to sharepoint and approve on an aggregate basis - they get 1 email regardless of how many "New" docs are outstanding. Not sure how to proceed after the "Get Files (properties only)" stage... any thoughts? thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

For this, I have created a simple example list with a choice column that denotes whether status is open or closed. The person that is emailed is retrieved by the 'created by' column
Below is the flow (which sends out 1 email to me, though I have created 2 items that are open)top part of flowbottom part of flow

It should work the same way for 'get file properties' as it does for 'get items'.

Was this reply helpful? Yes No
almond_boi 22 on at

Like (0)

Report
Copy link

Link copied!

This is likely ansered elswewhere, but PM status is a Choice content type; does that complicate the above operation? Thank you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

hi, the 'open' status I used is in a choice column too, it works fine. For choice columns, they will have two dynamic contents: 'column-name' and also 'column-name value' - you need to select the value for it to work

Was this reply helpful? Yes No
almond_boi 22 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Anonymous, works great!

Was this reply helpful? Yes No