Power Platform Community Forum Thread Details

Hi everyone,

I have looked for a solution for this but didnt' find it, so I hope you can help me.

I get all rows from SQL on powerautomate and create a HTML Table and I need group and sum by the column 'descripcion' (My Powerautomate dont let use SQL query function because SQL Server is onpremise, only can use 'get all rows' function)

After getting all rows my HTML Table is like this:

As you can see, I could group by column 'descripcion' to get a table like this:

and the final result I need with HTML format is the next table (it doesn't care if the grand total is not calculated):

I just could get the Total of all data (25.502.500 for column 'base' and 270.175 for column 'retenido')

How can I build a flow for getting those subtotals for (Retencion, Impuesto and Tarifa ) having on count that the number of items 'descripcion' may be different, I mean, if my query to SQL is different the result may be 'Retencion', 'Impuesto', 'Tarifa' and Other item...or maybe only 'Retencion' and 'Impuesto'.

Categories:

Building flows