More than a solution, I'm looking for an explanation on why does this happen.
For context. I'm making a SQL query to an excel file using power automate desktop, this file has dates in dd-mm-yyyy format. What I cannot understand is that those dates appear in mm-dd-yyyy format in my datatable.
I have checked my regional settings on my windows machine and is set to dd-mm-yyyy, also checked my excel regional settings which is also set to dd-mm-yyyy. Since everything seems in order why does power automate insists to change the data format? Have I missed some obscure setting?