Unanswered

Reminder Flow on Outstanding items

(0) Share

Report

Posted on by CRamsamy

Hi PA Users,

I have a SharePoint list setup where I collect all leave requests. One of the options in the list is pending. This stays in this position until the requestors leave is approved by their manager at which point I go into the request and hit the approval on the item. What I am after is a way where I can setup an automation to collect all "pending" list items in the list and have them emailed to me weekly so that i know who is still waiting on leave updates and I can chase these up more frequently.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @CRamsamy

You can trigger the flow on a weekly recurrence and use the List Items from SharePoint action for this. You can use OData filtering to filter the items that have the choice column as pending only and create a table of those items using the create HTML table action and send them in an email. Sample on ODATA filter for choice columns: https://powerusers.microsoft.com/t5/General-Power-Automate/Get-items-Filter-query-choice-not-working/td-p/183989#

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
CRamsamy 6 on at

Like (0)

Report

I am going to give this a try now and come back to you shortly with the outcome.

Was this reply helpful? Yes No