Unanswered

Check if dates in excell file are equal to current day and trigger process

(0) Share

Report

Posted on by STRUSINIO

Hi,
I'm quite new into the flow building topic, and trying to build something that will check multiple dates in csv file, compare that with current date. If the dates are equal -> start the process of generating new file based pbi dataset output.

all is working perfectly as expected when i have only one date in my source file, but the problem appears once passing more than one value. I guess im missing something like split and for each check but have no idea how to implement that.
thats my current output in dates from excel source

compering that to current date in same format:

and it looks like this in condition checker(dates from excel vs current date) outputs:

So my question is how can i compare values from my 'dates from excel' output as separate entries vs current date one by one

Thanks in advance for any advice

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @STRUSINIO

If you need to just check if list of excel dates have current date value, then you could use "contains" operator in place of "equals":

<Outputs of excel dates compose> "contains" <output of current date compose>

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
STRUSINIO 6 on at

Like (0)

Report

oh god, definitely need some more practice with that tool it was so obvious 🙂 Thanks a lot!

Was this reply helpful? Yes No