Creating HTML table from 'list records' grouped by leads created by the owner?

[jimxmy]

Hi. 

I have a requirement where I have to create the html table to further use it as an output for the email action. 

The html table is currently getting all the leads created in the last 7 days after I used the filter query : createdon ge adddays(utcnow(),-7). 


 What I want is : 
I want to create the html data in such a way that for every owner, the number of leads details should be there in the html data. How can I achieve this? 

[PrasadAthalye]

You can create an array variable and add all unique Owners by looping through output of list records..

Then again run a loop on array variable, take each item and filter list records for that owner. Then generate HTML table from that output and use it in the email.

[jimxmy]

Hi @PrasadAthalye 

What do you mean by the: "take each item and filter list records for that owner"? 

How do I do that? Do you intend to mean that I take another list records action from the Dynamics 365 and then in the 'filter query', put the array variable?

I am a bit confused. 

Thanks.

[PrasadAthalye]

No. I mean you already have List Records with filter.

Create Array variable. Then run a loop on List Records and check if Array variable has Owner or not? If not, add it. This way you get all unique Owners.

Then Run a loop on this array and filter same List of Records from Dataverse action by matching Owner. Convert that output to HTML table and send email... 

Refer below thread to just get an idea..

https://powerusers.microsoft.com/t5/General-Power-Automate/Need-to-send-specific-rows-to-specific-pe...