cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qopwer12
Helper I
Helper I

Filter out my Bucket names to appropriate tasks

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: 

 

Result.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

Hi @qopwer12 

 

Please find below the steps:

Here is my buckets sample:

Mira_Ghaly_0-1615512172599.png

 

Please follow the below steps:

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

2. List Buckets

3. List Tasks

Mira_Ghaly_1-1615512262292.png

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

Mira_Ghaly_2-1615512916032.png

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

Mira_Ghaly_4-1615513229217.png

Final Step outside your 2 Apply_to_eachloops

you can use create HTML Table as below

Mira_Ghaly_5-1615513289289.png

 

And here is the output at my side

Mira_Ghaly_6-1615513378209.png

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

1 REPLY 1
Mira_Ghaly
Dual Super User II
Dual Super User II

Hi @qopwer12 

 

Please find below the steps:

Here is my buckets sample:

Mira_Ghaly_0-1615512172599.png

 

Please follow the below steps:

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

2. List Buckets

3. List Tasks

Mira_Ghaly_1-1615512262292.png

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

Mira_Ghaly_2-1615512916032.png

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

Mira_Ghaly_4-1615513229217.png

Final Step outside your 2 Apply_to_eachloops

you can use create HTML Table as below

Mira_Ghaly_5-1615513289289.png

 

And here is the output at my side

Mira_Ghaly_6-1615513378209.png

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,911)