Hello Team,
This is very easy to implement. i am sharing the steps in detail over here.
First look at my list -
Here I have two columns, one is email which is my managers email address to which the email needs to be sent and one is choice column with internal name StatusOfApproval .
Step 1 - Create a Scheduled flow that will repeat itself every 7 days and send emails on Sunday, you can choose any day from the bottom.
Step 2- Get items
Here I will only get the items that have StatusofApproval eq 'Pending'. I need to enter this query in filter query so I get all the items as per my requirement.
Step 3 - Loop each item and send an email.
Very easy part, where I loop each item that has status pending and then using dynamic content send the email to the EMAIL value present in that list item.
I am also adding the Link to the item in the body of the email so managers can quickly navigate to the item if they want to check it out.
Just follow these steps and your flow will work smoothly. Please do accept it as solution if this works for you.
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!
