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']"
}
}
}