Problem description
My flow reads Excel data where the date fields are stored as Excel serial numbers, e.g.:
"Startzeit": "45930.706412037"
I’m converting these values to real dates using an expression inside a Filter array action.
The expression already includes additional logic (trim(), replace(), match(), etc.) to catch:
- decimal commas (
, instead of .)
- leading/trailing spaces
- empty values
- values without
- or T (Excel numeric dates)
The strange behavior
- When the flow runs automatically (triggered), or when it runs under the Primary Owner’s context, the Filter array action fails
(e.g. with errors like: The template language function 'int' was invoked with a parameter that is not valid…)
- But if I open the failed run and click Resubmit, the exact same step works perfectly.
So the flow fails automatically, but works when resubmitted manually.
What I have already checked
- Both variables (
Verfassen and Verfassen_1) produce valid yyyy-MM-dd dates.
- The Filter array expression has already been updated to a fully robust version (regex, trim, replace, split, etc.).
- Changing the UI language of Power Automate (EN/DE) has no effect.
- The resubmitted run uses the same input data, but succeeds anyway.
What I suspect
This might be related to:
✔️ Different user connections (Primary Owner vs. me)
Maybe the flow uses different connectors or permissions depending on who runs it.
✔️ Different expression evaluation between automatic run and resubmit
Resubmit executes the current version of the expression, even for an old run.
✔️ Different handling of utcNow() between original run and resubmit
Dates like yesterday or start of week are recalculated when resubmitting.
✔️ Cached old expression used in original run
While resubmit uses the updated one.
My question to the community
👉 Why does Filter array fail during normal (automatic) execution, but succeed when the same run is resubmitted manually?
👉 Has anyone experienced similar issues with:
- connections running under different user contexts,
- Excel date conversions,
- expression caching,
- or Filter array behaving differently between run types?
Any ideas or insights would be greatly appreciated.
Thanks in advance!
