You’re offline. This is a read only version of the page.
4
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)
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.
@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-
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
