Power Automate and dates

[hugo365mx]

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

[gabibalaban · Accepted solution]

@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. 

Hope it helps !

[hugo365mx]

It works. Thanks for the quick response.