web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Daily Planner task dig...
Power Automate
Unanswered

Daily Planner task digest - with plan/bucket names

(0) ShareShare
ReportReport
Posted on by

I'm looking to set up a daily digest for team members using Planner (as part of a 'what does this do for me over managing my workload in Excel' onboarding drive) and I would like to set up a 'my tasks' daily digest e-mail.

 

The template only allows basic information (task name/due date) which I've added to with Plan and Bucket ID. This isn't much use as it's the UID of the plan/bucket, not the name, so I need to put this information in the digest e-mail, however I can't figure out how to use the filter array with a 'for each' to get the names of the plans/buckets in the body of the text.

 

Any advice appreciated - I'm just getting started on Flow.

 

{
"inputs": {
"from": "@body('Filter_array')",
"select": {
"Title": "@item()['title']",
"Percent Complete": "@item()['percentComplete']",
"Due Date": "@item()['dueDateTime']",
"Plan": "@item()?['planId']",
"Bucket": "@item()?['bucketId']"
}
}
}
Categories:
I have the same question (0)
  • v-bacao-msft Profile Picture
    on at
    Re: Daily Planner task digest - with plan/bucket names

    Hi @jraward ,

     

    Could you provide the template you are currently using?

    Maybe we could improve on the basis of the template to meet your needs.

     

    Best Regards,

  • Verified answer
    v-bacao-msft Profile Picture
    on at
    Re: Daily Planner task digest - with plan/bucket names

    Hi @jraward ,

     

    If the template you are using is "Send a digest email of all outstanding Planner tasks" and you want to add bucket name and plan name to HTML table, you could refer to the following method.

    1. Use three Apply to each to traverse my plans, buckets and my plans.
    2. Configure array variable to integrate the fields that need to be displayed in HTML table.

     

    • First initialize an array variable and use List my plans action to get all the plans.64.PNG

     

    • Traverse my plans, select Enter custom value to enter Plan Id, fill in plan value Id.

    61.PNG

    • Integrate information and append to array variables.62.PNG

     

    • Finally, use length() function to determine whether there is a matching task, to avoid the sending of blank mail.63.PNG

     

    Please take a try.

     

    Best Regards,

  • ApexHeel Profile Picture
    4 on at
    Re: Daily Planner task digest - with plan/bucket names

    It looks like "list my plans" has been deprecated. Any other solutions to this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard