Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors