web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow Run Error Excel

Power Automate

Unanswered

Flow Run Error Excel

(0) Share

Report

Report

Posted on by RadioGuy1

2

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation