web

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

Power Platform CommunityForums Power Automate - Using Flows Date format

Power Automate - Using Flows

Answered

Date format

(1) Share

Report

Report

Posted on by Luis_Pena

3

Hello,

I'm doing an automate process to present a table from excel in a power app after the user clicks on a button.

So far, I'm already presenting the table, but I'm stuck in the date format.

The Date in excel is being presented in format mm/dd/yyyy hh:mm:ss tt but to the power apps table is going the number 4xxxxx.xxx and I need it in mm/dd/yyyy

Thank you.

Categories:

Business Process Flows

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Pstork1 68,315 Most Valuable Professional on at

Like (0)

Report

Date format

Check the advanced settings on the action retrieving the date. The last field in advanced properties specifies the format of the date you want. It sounds like you are getting the default serial date format rather than the ISO 8601 format.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 614 Super User 2025 Season 2

#2

Tomac 401 Moderator

#3

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans