According to your description, I have started a flow from the template “Create planner tasks for flagged emails in Office 365” you mentioned.
However, the issue that the tasks get duplicated multiple times doesn’t occur on my side.
The flow will be triggered only one time when an email is flagged and one task will be created in Planner.
Could you try again with it?
Please feel free post back if you are still having the issue.
i got the same issue,
whenever i answer or receive a followup of the same mail conversation as the flagged e-mail, i got another task created .
seems like answering or receiving a mail with the same subject is similar as flagging a new email .
i suppose that @Anonymous is referring to this issue,
This is also happening to my team. We used the prebuilt template "Create a Planner Task for Flagged E-Mails", and anytime somebody replies to that thread it treats it as if we have re-flagged the same message and duplicates the task in planner.
there are many solutions to this problem. however this is the neatly one for this.
as you know there isn't an extra field in Microsoft planner or Microsoft Outlook, so you need to organize them in some table.
the relation between taskid and conversation id is 1 to 1. (trick 1)
so and that way you don't need to save this nasty id's in your task title or description.
conversation id is the key for no duplicates for many emails that originated from the first email, set by you or to you.
the algorithm is:
get a flagged email then try to get a conversation id from the table
if you found one the get the task and update the existing task
if not create a new roe and the create a new task.
how we check if the task already exists? by searching the conversation id in the table
using "get a row" from excel
if the operation succeeds you go for update the task
but what happens if it fails, the flow will stop and nothing happens.
so we need to configure "run after"
and in this window check also the has faild to continue wit the flow
when the flow will fail, and it will get a NULL value
so this how you differ new on one from the existing one.
this the trick number 2
I hoped that help
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!