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 / How to change to conve...
Power Automate
Answered

How to change to convert any date to desired format while reading from online excel for business.

(0) ShareShare
ReportReport
Posted on by 9

when i am trying to read any date column field from excel online business. It is reading it as '28657'. Please refer the below image

 

Majid410_0-1719214795671.png

 

Please help me to resolve this issue.

 

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    on at

    Hi @Majid410 ,

     

    Glad to hear that the problem has been solved. If my answer helps you solve the problem, please accept it as a solution.

     

    Best regards,

    Rimmon

  • Majid410 Profile Picture
    9 on at

    Thank you so much 'v-mengmli-msft'.

    I was trying to fix it from one day and searching on web. It is fixed now.

    Thanks a lot.

  • Verified answer
    v-mengmli-msft Profile Picture
    on at

    Hi @Majid410 ,

     

    Please check if you have turned on ISO8601 of List rows in a table.

    If not, please turn on it and test again.

    vmengmlimsft_0-1719215142568.png

     

     

    Best regards,

    Rimmon

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
David_MA Profile Picture

David_MA 265 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

#3
trice602 Profile Picture

trice602 202 Super User 2025 Season 2

Last 30 days Overall leaderboard