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
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?YesNo
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.
3
Share
Report
All responses (
Answers (
