Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Scheduled power automate excel tabe overdue Email

(0) ShareShare
ReportReport
Posted on by 33

Hi There,

 

I am new to powerautomate. I need help on this below requirement

I have Excel table in SharePoint excel. Which contains one Colum on named EDC. I want Email if the EDC is today and on the email body that row (The list which today edc falls),

2. Then second, if the EDC is overdue by 3 and 3+ days i want send email which email body contains overdue line row list

 

Thanks in advance

 

Regards,

Singaravelu S

+91 9952324175

  • rishabhkhanna1 Profile Picture
    rishabhkhanna1 56 on at
    Re: Scheduled power automate excel tabe overdue Email

    Array(items()?('apply_to_each_2')?['EDC Date']) ....use EDC Date dynamic content inside Array function in your if condition.

     

    Right side (addDays() function) of if condition logic can still remain the same

  • Singaravelu Profile Picture
    Singaravelu 33 on at
    Re: Scheduled power automate excel tabe overdue Email

    @rishabhkhanna1 

    Please reply, I im still waiting for your update

  • Singaravelu Profile Picture
    Singaravelu 33 on at
    Re: Scheduled power automate excel tabe overdue Email

    @rishabhkhanna1 

    Sir, awaiting for your reply.

     

  • Singaravelu Profile Picture
    Singaravelu 33 on at
    Re: Scheduled power automate excel tabe overdue Email

    @rishabhkhanna1 Scheduled power automate excel tabe overdue Email 

    Dear Sir, kindly find the requested details, Kindly help to achieve the requirement 1.PNG3.PNG4.PNG11.PNG

  • rishabhkhanna1 Profile Picture
    rishabhkhanna1 56 on at
    Re: Scheduled power automate excel tabe overdue Email

    Please share the output of one flow instance, also screenshot of logic written inside the 'apply to each' loop

  • Singaravelu Profile Picture
    Singaravelu 33 on at
    Re: Scheduled power automate excel tabe overdue Email

    @rishabhkhanna1   Sir, Not sure about which string format I Can use. Screenhoot attached herewith. Kindly check and help please sir

    Your replay would be highly appreciable 

    Thanks in advance

  • rishabhkhanna1 Profile Picture
    rishabhkhanna1 56 on at
    Re: Scheduled power automate excel tabe overdue Email

    @Singaravelu - How exactly is the output desired for 'EDC Date' column that currently shows '20-May-2022' .

    Can you share on what formatting have you exactly done in Power Automate flow specific to 'EDC Date' column?

  • Singaravelu Profile Picture
    Singaravelu 33 on at
    Re: Scheduled power automate excel tabe overdue Email

    Hi Sir,

     

    Thanks for your reply. Which was very was very clear. But i was unable to match the date format string. need help on this area. I had downloaded and attached the excel for the reference. Refer column  "EDC Date" for date comparison.

     

    2nd,  In the Email body i want that list of item that pending. (Which was overdue with respect to EDC date)

     

    Thanking You

     

    Regards,

    Singaravelu S

     

     

     

  • rishabhkhanna1 Profile Picture
    rishabhkhanna1 56 on at
    Re: Scheduled power automate excel tabe overdue Email

    You can setup a recurrence flow with excel path configured on 'List Rows Present In a Table' action.

    Capture today's date using UtcNow() function as shown below.

    Please, by default PowerAutomate Captures datetime in Utc format

    rishabhkhanna1_0-1668756033954.png

    You can then mention relevant condition, but please sure both the dates in excel and that on 'convert time zone' action are in same format .

    rishabhkhanna1_1-1668756251833.png

    For >3 days, you can use addDays(body('Convert_time_zone'),-3) under expression tab that would check and send relevant emails from 3 days and beyond 3 days.

    rishabhkhanna1_3-1668756400682.png

    Hope this helps.

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard