Flow Run Error Excel

(0) Share

Report

Posted on by RadioGuy1

Hey Folks,

I'm trying to build a flow for pulling info out of a shared excel document and it works all good except on the pulling the date for the HTML table.

the fuction I have on the line is FormatDateTime(item()['POEntryDate'], 'dd-MM-yyyy') but I have also tried different formats of the date at the end of function but it give same error.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
You need to use a different expression to format the date. Try:
addDays('1899-12-30',int(item()['POEntryDate']),'dd-MM-yyyy')
I cover this exact error in a YT short: https://www.youtube.com/shorts/HmxKckDdWQo

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No