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
Dual Super User

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
Dual Super User

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,671)