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

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (68,904)