Aug 22 2019 10:02 AM
I have created a Flow, which creates a SharePoint list entry from a flagged e-mail. It works as expected, except for one result. The SPO list item is duplicated several times. I have not been able to determine if the duplication occurs when I view the flagged e-mail regardless of device (possible), when I open Outlook in a new device (possible, but unlikely), or randomly (possible). One thing is certain: the source item in Exchange Online is not marked as having already been converted into a list item and so should not be converted again.
Any idea of the problem, or how to fix it?
Aug 22 2019 07:29 PM
Aug 23 2019 12:13 PM
@ChrisWebbTechThose are both good ideas, thank you. I'm particularly interested interested in your second suggestion.
you could have the flow do a condition to check that the list doesn’t have an item with that ID the flow is running for already there and if so end the flow
How? Is there a resource you could point me to?
Aug 23 2019 12:38 PM
There are a few out there, google up 'microsoft flow existing item Sharepoint list' and you'll get some results, but here is one I found, basically gives you the idea how to do it. Get list items, filter that with something like MessageID eq 'messageid' from the e-mail then you basically do a empty command I think could work, to see if any results returned to it, may have to use other method from articles but I just whipped this up off top of head. If it's true then create, else, do nothing. Should work theoretically.