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 Platform Community / Forums / Power Automate / Incorrect Date pulled ...
Power Automate
Unanswered

Incorrect Date pulled from excel.

(0) ShareShare
ReportReport
Posted on by
HI,
 
I've been having a nightmare with this recently this is my problem:
 
When Power automate pulls dates from my excel sheet it pulls them through in the wrong way for example, if i wanted the date to be 08/04/2024 it would pull through as 04/08/2024.
 
What I've done to fix it:
1) Change the sheet local to GB for the dd/MM/yyyy format.
2) Use the ISO 8601 format on the puill rows command. this worked for a bit but it went back to the wrong style
3) Pull the dates through as serial numbers. I found out that PA was pulling the dates through as the american style serial number even after i changed the local to GB.
 
Could anyone please help?
I have the same question (0)

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard