Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.