Hey,
i can't eyplain myself the following error:
What my flow does in short:
Now the interesting part:
The flow is being triggered every day at 7:30
--> But the flow does not finish and send any teams message.
BUT:
When i "test the flow" afterwards, it works just fine.
Can anyone tell me whats wrong here?
Thanks 🙂
Sounds like a time zone issue.
I recommend not doing the comparison on power automate, not excel. If you don't open the file, it won't update
Hi @schwibach,
exactly! In the Excel file, it checks in one column if theres a Birthday (Name =CheckBDY). If this is the case, the formula says "1". If theres no birthday it's "0".
In the query filter in Power Automate it Checks if there is any "1" in the CheckBDY column:
The example of todays flow at 7:30 is pretty interesting. The Output of list rows in excel action found a "1" in CheckBDY, even though there is none. So it posted The Birthday even though there isn't any.
Output
Excel
Technically, the automatic flow at 7:30 gives me the Birthday at the last day. The Birthday above was yesterday!
Is it possible it saves the Info in a cache somewhere? I can't explain this error its super strange
So, just so I get it right:
At 7:30 in the morning, the flow does not send any messages?
But when you trigger it manually, it works fine and sends messages ?
By the way, I don't see where it checks the the birthday.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1