Skip to main content

Notifications

Power Automate - Building Flows
Answered

Daily email reminder for pending approval with Link to Items

(0) ShareShare
ReportReport
Posted on 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
    PrasadAthalye 4,795 on at
    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

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard