cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hugo365mx
New Member

Power Automate and dates

Hi all

I've been working with power automate, I get a date from an Excel file, with this, I'm trying to use a condition where is evaluating the date in the format dd/MM/yyyy but for some reason, the flow is getting the date as a number. I tried to use the "FormatDateTime" function in the expresion but is not working.  However, if I use the date in the format "MM/dd/yyyy" it works.

Any ideas? 

Thanks for your comments

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

@hugo365mx ,

Set in "List rows present in a table" action the Date Format option to ISO 8601. If it is not set, the default option is to bring the date as a number. 

gabibalaban_0-1638430707469.png

Hope it helps !

View solution in original post

2 REPLIES 2
gabibalaban
Super User
Super User

@hugo365mx ,

Set in "List rows present in a table" action the Date Format option to ISO 8601. If it is not set, the default option is to bring the date as a number. 

gabibalaban_0-1638430707469.png

Hope it helps !

View solution in original post

hugo365mx
New Member

It works. Thanks for the quick response.  

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,385)