Hi colleagues,
I am trying to add an Order By rule to a List rows present in a table action in Power Automate, but it keeps giving an error Bad Gateway. The flow works just fine with a filter query and without the extra conditions. In the Excel file the Date column contains dates in excel format, which are stored as numbers. I did try this exercise with another column in the Excel file "Nationality", which contains only letters, however the result is the same. I am the owner of the SharePoint and the flows, which are using my credentials for the connection, so there should be no permission issues. Any ideas what could be the root cause? Any help would be appreciated!
