web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Flow Run Error Excel

(0) ShareShare
ReportReport
Posted on by 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. 

 

error.JPG

 

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard