Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Daily email reminder for pending approval with Link to Items

Like (0) ShareShare
ReportReport
Posted on 2 Jul 2021 08:23:21 by 517

Hi,

 

I have created a separate workflow for daily approval reminders for those in Pending status with Link to Item.

 

I have a two concerns:

 

1. I want to send emails only for those items that is not yet in due date. By the way, I have a date field for Due Date

 

Here's my created flow and it is working based on my other filters but when I add the filter on Due date field, it does not meet the requirement.

 

jaina_11-1625214179577.png

jaina_12-1625214203135.png

 

 

jaina_1-1625213492074.png

 

Expectation:

jaina_2-1625213635884.png

 

2. I want to include the link to that specific item (source: SP List) in email body but when I include the link to item, all items are in one email body due to for each loop captured. How do I correct it?

jaina_4-1625213921761.png

 

output: 

 

jaina_10-1625214106293.png

 

 

 

 

 

 

 

 

 

 

  • Verified answer
    PrasadAthalye Profile Picture
    4,795 on 02 Jul 2021 at 13:40:15
    Re: Daily email reminder for pending approval with Link to Items

    Can you format your date like 'yyyy-MM-dd' and test?

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 196 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 177 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 165

Overall leaderboard