Flow Designer Valid to on Tomorrow does not filter the right entries

ozgurD · ‎08-28-2024

Hello,

I currently have a problem with the Valid to on Tomorrow (specifically on the “on Tomorrow Operator):

I want to filter out all KB articles that have the valid to date of tomorrow, this flow is triggered every day in the morning but for some reason it always filters me not the valid to tomorrow but the KB articles where the valid to is on the same day, e.g. execution of the flow: 27.08.2024 then it should find all KB articles that have a valid to from 28.08 but it finds the kb articles that have a valid to from 27.08.

Tests:
I have already checked that the flow is triggered at the right time. I have also entered a fixed date instead of Valid to on tomorrow for test purposes, i.e. valid to on 29.08.2024, here he then found the correct kb article, so it is not the trigger but actually the “Tomorrow”.

The other conditions also always match

Thank you for your help

Mark Manders · ‎08-29-2024

Wouldn't it be better, looking at the requirement, to give the author more time? Like provide a list of articles that have a valid to on next week or even next month? If I receive this email on my day off (or even in the weekend), the article will no longer be visible for end users.

You can send the authors a list of all of their articles that need to be reviewed within an x period and it will help them in organizing their work instead of being confronted with work they don't have time for?

The only way you can use 'tomorrow' is by having it run later on the day, so you are in the system time zone.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

Mark Manders · ‎08-29-2024

What time does your flow trigger and in what timezone are you? 'On tomorrow' should return everything from midnight of the next day within the system's timezone.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

ozgurD · ‎08-29-2024

The flow triggers the time zone we are in Europe/Berlin and I found our system timezone is:

Does that mean it's because of that? Is there another way to check for “On Tomorrow” without changing the time zone of the system?

Thank you for your help!

Mark Manders · ‎08-29-2024

This could very well be the cause (it's checking on system time to determine what is 'tomorrow').

But since you are checking on knowledge articles to see if they are valid until tomorrow, what does the rest of the flow do? I think it's kind of a short timespan to do something with the articles if they are just valid until tomorrow, but it depends on what you are doing with it, of course.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

ozgurD · ‎08-29-2024

If a KB article is valid until tomorrow we send a notification to the author to inform them. Do you have any suggestions to check on for tomorrow, because I can´t change the timezone fo the system.