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

Doc Approval reminder email - send 1 per PM

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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

Below is the flow (which sends out 1 email to me, though I have created 2 items that are open)top part of flowtop part of flowbottom part of flowbottom part of flow

 

 

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

Below is the flow (which sends out 1 email to me, though I have created 2 items that are open)top part of flowtop part of flowbottom part of flowbottom part of flow

 

 

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

View solution in original post

Capture.PNG

 

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

 

 

Anonymous
Not applicable

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

Thank you @Anonymous, works great!

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (48,020)