Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Losing sorting because of format in Power Automate


after my last post about Power Automate I have been advised to post directly in the Power Automate forum but unfortunately I have not received any reply. So I want to try it here as this forum has always been incredibly helpful 🙂

I think I know what causes my problem, link to my original post is here: Power Automate forum 

I want to send some tables formatted as html tables via email. I figured the process of Run the query against a dataset funcionality but as the numbers should be wrapped in FORMAT function, sorting (at the bottom of the picture) is lost. Better to say it is not lost but the sorting is now done only by the first digit and not by the value of the whole number




Is there any way to preserve the formatting of "# ##0 (currency)" while having the numbers sorted by their actual value?
I was thinking of making some other column, maybe I could somehow manage to make the column background the same color as the font to make the column "invisible", not format it and sort the table by it, but it seems like a very awkward solution.
Thank you very much for any help.

New Member

HI @Petanek333 thank you for your detailed question. Im having the same issue and I can not find anywhere the solution. Have you had any luck?? 


Best regards mate

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors