If a date falls between an interval, set status method

[gaborszollosy]

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!