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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

Users online (31,559)