Announcements
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!
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'.
This is likely ansered elswewhere, but PM status is a Choice content type; does that complicate the above operation? Thank you.
Thank you @Anonymous, works great!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 286
David_MA 256 Super User 2026 Season 1
Expiscornovus 225 Most Valuable Professional