Outlook MessageId is NOT unique

(0) Share

Report

Posted on by Bukester

Hello,

I have setup a flow to log (among other things) each email to a log table in on-premises database. This ran for some time and for the most part worked. I am developing this further with the understanding that the MessageId is a unique value, but I am finding that is is NOT unique.

If I execute :

SELECT * FROM audit.EventLog WHERE SourceId IN (
SELECT
[SourceId]
FROM [audit].[EventLog]
GROUP BY SourceId
HAVING COUNT(*)>1
)
AND sourceid='AAMkAGI4ZGQxODM3LTE1MTktNDlhOS05OTY1LThjNjBhZTExNjIwYwBGAAAAAAAbkuZPGNHBTY-o7TpPuklBBwBhG_qNiCDrR6haRvwuqbf4AAAAAAEMAABhG_qNiCDrR6haRvwuqbf4AAH8bhXXAAA='
ORDER BY SourceId,EventDateTime

I get two records (there are many instances of dups)

Duplicate MessageId.png

In this case, several hours apart and there is no connection between the two messages.

Is there a function available in flow for me to unique-fy the message?

The root problem I am trying to solve is - some emails we receive are the same name every time. Its not datestamped etc. So I need to have a name that is unique and of course the original name to know how to handle the file (pdf rip or parse csv, excel etc)

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Bukester - Have you already considered concatenating the ID and the Date/Time into a new key field? Seems like that would always be unique, no?

-Ed-

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Bukester ,

As the pic shown, you find two emails with the same 'Message Id'.

Can you find the corresponding emails in your Outlook?

Please check whether the two emails is the same one.

I think the 'Message Id' is unique.

You can use the below flow for a try, checking whether you can get two different emails with the same 'Message Id'

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Suggested answer

RonaldS 3 on at

Like (0)

Report
Copy link

Link copied!

I had the same problem and I found that if you concatenate the messgeId with the conversationId, it also seems to produce unique keys.

Good luck, Ronald

Was this reply helpful? Yes No