Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Excel serial date-time format to text string

Posted on 22 Nov 2024 14:34:10 by 87
I cant seem to find a way around this issue.  I am using Power Automate to get information from a table in excel and one column happens to be a column "Onset Date" .
 
 
This happens to be a custom format in Excel.  When I run my flow the value becomes the excel serial date format  "Onset Date": "45555.1666666667".  How do i write the correct expression in my compose action within an apply to each to get it to display like this "9/20/2024 4:00 AM"?
 
 
  • Chriddle Profile Picture
    Chriddle 6,987 on 22 Nov 2024 at 15:25:45
    Excel serial date-time format to text string
    In the Excel connector's "Advanced options" set the "Datetime Format" to ISO 9601

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard