using power automate visual to send filtered data by email

[lawada]

hello,

im using power bi automate to send data by email . what im trying to automate exactly:

for each selected driver name , i want to get the total tasks done by the driver with the follwing fields :

task date, early tasks,late tasks, on time tasks, total tasks, task type

so user will just filter the driver name and get the the data in the following table sent by email

after i used the auomate visual. it's sending the email 3 times for each row for the selected driver name however i want the user to get the data in one email for the selected driver and i want the data to be in the same table format 

[V-lianl-msft]

Hi @lawada ,

You can refer to this thread:

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-send-multiple-List-Items-in-single... 

How to send multiple list items in ONE email using Microsoft Flow 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.