I am in the process of integrating Microsoft Planner into our company’s workflow to manage tasks received via email. I have set up a Power Automate flow that automatically creates a task in Planner whenever someone receives an email with "TODO" in the subject line.
However, I’m encountering an issue where, if the email is sent to multiple recipients, it creates duplicate tasks in the Planner bucket – one for each recipient. I would like to know if there is a way, using Power Automate, to consolidate these tasks into a single task with all recipients included as assignees.
Specifically, I’m looking for a solution that would:
1. **Identify Duplicates:** Recognise when an email is sent to multiple people and avoid creating separate tasks for each recipient.
2. **Merge Tasks:** Instead, merge these instances into one task with all original recipients as assignees.
3. **Update Existing Tasks:** If a similar task already exists (e.g., if a "TODO" email has already been received), update the existing task to include any new recipients rather than creating a new one.
If anyone has experience with a similar setup or suggestions on how to configure Power Automate to handle this, I would greatly appreciate your advice. Additionally, if there are any best practices or alternative approaches to managing email-to-task automation in Microsoft Planner, I’m open to those as well.
Thank you!