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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,343)