Filter out my Bucket names to appropriate tasks

[qopwer12]

Hi all, 

I have a flow that sends out emails to everyone on the Planner with an upcoming task in the next 2 weeks in an HTML table. My boss wants me to add in and show the bucket name for which that task belongs to. 

I made an array that incorporates all the bucket names for the Planner but when I add it to my HTML table, the results come up with everyone of the buckets, not just the bucket for the task. 

Is there a way to filter my bucket to fit? 

Heres a picture of the test email: 

[Mira_Ghaly · Accepted solution]

Hi @qopwer12 

Please find below the steps:

Here is my buckets sample:

Please follow the below steps:

1. Initialize A final Array where u will generate the HTML Table from

2. List Buckets

3. List Tasks

4. We need to loop on the Buckets List and Filter the Tasks List by Buckets and do an inner join like way

5. Then Add another Apply to each which runs on the filtered array and add a compose data operation as below

Final Step outside your 2 Apply_to_eachloops

you can use create HTML Table as below

And here is the output at my side