Need help with flow based on Dates and send email

(0) Share

Report

Posted on by Eswar1

I need a help in constructing a Holiday flow Email to manager based on the following requirement:

1) Check Start Date and End Date and Compare with Todays Date and send a flow to Manager on Based on Status Condition.

Both My start date and End Date are Single line of text Sharepoint columns & Should be compared to todays date.

Send Email to manager saying that today the following employees are on leave.

Basically want to get all dates between the start and end dates and compare with todays Date and if approval condition is Approved then send an email to manager.

Please assist me with this, by sending me a sample flow.

Regards

Eswar

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Eswar1 Please check this link :

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-compare-dates-in-two-SH-Lists/m-p/799557#M63697

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

Dear Jinivthakkar,
Thanks for sharing the post, my scenario is that i have to compare two string values (i.e Start Date and End date with todays date).
For checking the employees who are on a holiday today.

Thanks,
Eswar

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

Dear jinivthakkar ,
Thanks for sharing the post, my scenario is that i have to compare two string values (i.e Start Date and End date with todays date).
For checking the employees who are on a holiday today.

Thanks,
Eswar

Was this reply helpful? Yes No