Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

If a date falls between an interval, set status method

Hi there!


I'm trying to create a flow, that determines if a user is on vacation/holiday based on an Excel table, that has a vacation starting and ending date in this format: yyyy-MM-dd


I list every row from said Excel table, than applied to each row, I created a condition where if formatDateTime(utcNow(),'yyyy-MM-dd') is less than, or equal to the ending date, and if formatDateTime(utcNow(),'yyyy-MM-dd') is greater than or equal to starting date, the excel row update would set a status in another table, in the employee's row as "On vacation", otherwise it would state "Available".


Unfortunately, the flow does not produce the desired result, as all are available.

Can you please show me how this can be done?


I appreciate any and all help very much!


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,050)