Losing sorting because of format in Power Automate

[Petanek333]

Hi, 

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.

[nerrazuriz]

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