Scheduled power automate excel tabe overdue Email

(0) Share

Report

Posted on by Singaravelu

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

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

rishabhkhanna1 56 on at

Like (0)

Report
Copy link

Link copied!

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
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 .
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.
Hope this helps.

Was this reply helpful? Yes No
Singaravelu 33 on at

Like (0)

Report
Copy link

Link copied!

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

Job Follow Up rep...

Was this reply helpful? Yes No
rishabhkhanna1 56 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Singaravelu 33 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
rishabhkhanna1 56 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Singaravelu 33 on at

Like (0)

Report
Copy link

Link copied!

@rishabhkhanna1 Scheduled power automate excel tabe overdue Email
Dear Sir, kindly find the requested details, Kindly help to achieve the requirement

Was this reply helpful? Yes No
Singaravelu 33 on at

Like (0)

Report
Copy link

Link copied!

@rishabhkhanna1
Sir, awaiting for your reply.

Was this reply helpful? Yes No
Singaravelu 33 on at

Like (0)

Report
Copy link

Link copied!

@rishabhkhanna1
Please reply, I im still waiting for your update

TAskfollowup_2023...

Was this reply helpful? Yes No
rishabhkhanna1 56 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No