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.


Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors