Forum Discussion

Regular Visitor

5 years ago

Email from BI using FLOW - DATA SORTING

I has been implemented a button in my PBI using the Flow as trigger. I would like to send a email with the informations from my BI, but the informations has not appear in correct order, eg 1,2,3,4,5....

Regular Visitor

5 years ago

Hello,

Sorry I think that I was not so clear =/

I has used the Visual Power Automate into Power BI. I need to send a email according example cited above.

See the flow:

1º On Power BI button clicked:

2º Select1 > from table BI > Map : House color

: QTD Toilet

3º Select2 >from table BI > Map : House color

: QTD Room

4º Create HTML table > output(select 1)

5º Create HTML table > output(select 2)

6ºSent email : outputHTML1 -

outputHTML2

I would like to present the information as below:

House Toilet QTD

Blue 5

Pink 3

Green 2

Yellow 1

House Room QTD

Yellow 7

Pink 6

Green 5

Blue 1

Now:

The results has not presented in ascendent order for booth cases, just in first case, second one has mixed.

House Toilet QTD

Blue 5

Pink 3

Green 2

Yellow 1

House Room QTD

Blue 1

Pink 6

Green 5

Yellow 7