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:
Solved! Go to Solution.
Hi @qopwer12
Please find below the steps:
Here is my buckets sample:
Please follow the below steps:
1. Initialize A final Array where u will generate the HTML Table from
2. List Buckets
3. List Tasks
4. We need to loop on the Buckets List and Filter the Tasks List by Buckets and do an inner join like way
5. Then Add another Apply to each which runs on the filtered array and add a compose data operation as below
Final Step outside your 2 Apply_to_eachloops
you can use create HTML Table as below
And here is the output at my side
Hi @qopwer12
Please find below the steps:
Here is my buckets sample:
Please follow the below steps:
1. Initialize A final Array where u will generate the HTML Table from
2. List Buckets
3. List Tasks
4. We need to loop on the Buckets List and Filter the Tasks List by Buckets and do an inner join like way
5. Then Add another Apply to each which runs on the filtered array and add a compose data operation as below
Final Step outside your 2 Apply_to_eachloops
you can use create HTML Table as below
And here is the output at my side
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
63 | |
27 | |
21 | |
15 | |
14 |
User | Count |
---|---|
123 | |
46 | |
44 | |
35 | |
31 |