cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
almond_boi
Level: Powered On

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

Re: Doc Approval reminder email - send 1 per PM

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)testflow1.pngtop part of flowtestflow2.pngbottom 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

Re: Doc Approval reminder email - send 1 per PM

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)testflow1.pngtop part of flowtestflow2.pngbottom part of flow

 

 

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

View solution in original post

almond_boi
Level: Powered On

Re: Doc Approval reminder email - send 1 per PM

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

Re: Doc Approval reminder email - send 1 per PM

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
Level: Powered On

Re: Doc Approval reminder email - send 1 per PM

Thank you @Anonymous, works great!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,075)