Hey everyone,
I'm having a really annoying issue with Power Automate, and it seems like stable flows suddenly breaking has become pretty common and MS hallmark! This latest problem is just plain weird. A flow that’s been working fine for months, maybe even years, is now failing out of the blue because it says a date is 'Null' when trying to format it.
This doesn’t make sense because the date is clearly there in the SharePoint list where it’s coming from. To double-check, I added Compose and Initialize Variable actions, and sure enough, the date shows up correctly.
Here's what’s happening:
The Get Items action grabs the date without any problems.
The flow then fails when it tries to format the date, saying it’s 'Null.'
The formula used is: formatDateTime(triggerOutputs()?['body/DateOfResignation'], 'dd.MM.yyyy').
What’s even more confusing is if I pass the date from Get Items into a Compose step first, then use that output to set a variable, everything works fine and there’s no error.
If this had been a problem from the start, I’d get it. But this flow has been running smoothly for over a year without any issues. If anyone has any idea why this is happening or can offer some help, I’d really appreciate it.
It’s frustrating when things that worked perfectly for months just stop for no obvious reason. Managing flows this way is becoming quite impossible!
Thanks.
353
Share
Report
All responses (
Answers (
