
Announcements
I have sales leads come in via email which creates a SharePoint list item. The list uses different statuses (approve, reject, etc) to trigger flows that generate different emails which go out to the lead.
When the lead responds, I don't want to create a new item, but rather I want the flow to cause SharePoint to just update the existing list item.
Using the ConversationID as the parameter to check against in a Condition, I have got it so that the original list item does get updated, BUT it does so within seconds of the original list item being generated in SharePoint. It seems that because the flow is always running it sees that the Conversation ID's match and changes the status to UPDATED within a minute of the lead arriving.
I tried to address this by putting in 2 Conditions - matching Conversation ID with the lead response email AND having "RE:" in the subject line so that the system would only update the item when a response email comes in. When I did this, the flow did nothing to the original SharePoint list item.
I've done Update Item flows a thousand times, but am really stumped on this one this week.