Hello
I'm working on automating the tracking of emails in a SharePoint list using Power Automate.
Here's what I'm trying to do:
If someone replies to an email that was already processed and stored, I don’t want to create a duplicate record. Instead, I want my flow to detect that it's part of an existing thread.
There are three types of IDs available in the email metadata:
Message IDInternet Message IDConversation ID
Which of these is best to use for identifying an existing email thread, so that I can avoid duplicate records and maintain proper tracking?
Logic I want to build:
When a new email arrives:
If the email/thread already exists in SharePoint:
- Store the email in the document library
- (Do not create a new list record)
Else:
- Create a new record in the SharePoint list
- Save the email in the document library
I'm essentially trying to track the email thread, not just individual messages.
Any advice or best practices would be appreciated — I’ve found that most documentation and YouTube videos don’t cover this kind of thread-tracking logic
Thanks in advance!
