Calendar based condition

(0) Share

Report

Posted on by IW-29050937-0

I have built a flow which runs with no errors flagged, but doesn't actually do the action it is designed to do, and I feel that it is the condition that is causing it to fail, but I cannot find a fix for it.

To summarise current flow

Trigger: When a new email is received

Condition: date contains Monday or Wednesday or Saturday or Sunday,

If true: reply to email (with body text about it being a non-working day)

If false: no action.

The run report comes back all green, no errors found. But also no-one is getting an out of office reply either.

This would be much easier if outlook just had this built in when you set your working hours, but as they don't can anyone help me fix the condition?

Categories:

Business Process Flows

Screenshot 2025-0...

All responses (2)

Answers (0)

Michael E. Gernaey 42,661 Super User 2025 Season 1 on at

Like (0)

Report

Calendar based condition

Hi @IW-29050937-0

What @eetuRobo says is completely legit, but I do have a follow up question.

You made it sound like everything runs as if the True side gets run but no one gets the emails.

So essentially your condition is working, that is how I read it, but if that is true, then the issue is with the reply email action and not with your condition.

So as @eetuRobo mentioned, what we really need to see is the RUN itself, with the actions Opened, so we can see what you put in.

I hope

a) this helps explain the confusion so next time it will :-) be clearer easier

b) how easy it is to have the smallest thing barf your work, but you have to remember to share it all to get better help.
Suggested answer

eetuRobo 3,454 Super User 2025 Season 1 on at

Like (0)

Report

Calendar based condition

Can you show screenshot of the condition and the expression you have on it? If you are just checking the receivedDateTime to contain "Monday" for example then it will most likely never met the condition since the receive time doesn't have the names of the days. You need to convert that datetime value to day of the week.

Use dayOfWeek() -expression to check what day of the week. And have it be OR so it checks if today is either 1, 3 or 6 which are Monday, Wednesday or Saturday

Expression is the same in all the rows:

dayOfWeek(triggerOutputs()?['body/receivedDateTime'])

Equal to

1 = Monday, 3 = Wednesday, 6 = Saturday

https://learn.microsoft.com/en-us/dotnet/api/microsoft.exchange.webservices.data.dayoftheweek?view=exchange-ews-api

Since the flow is starting right away when the email comes you could also use dayOfWeek(UtcNow()) since it should be the same as the email received date