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?

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started
Loading started