Outlook MessageId is NOT unique

[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)

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)

[edgonzales]

@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-

[v-zhos-msft]

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.