Doc Approval reminder email - send 1 per PM

[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!

[Anonymous · Accepted solution]

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'.

[almond_boi]

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

[Anonymous]

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

[almond_boi]

Thank you @Anonymous, works great!