cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amenegatti
New Member

Email Response ( RE:) and update Sharepoint List Item

Hello, 

 

I'm trying to create a flow in which the below should follow: 

 

Email arrives in Inbox eg: ISD-1234 Review of Work 

An Item is created on a Sharepoint List 

A reply email is received in inbox same subject but now has RE: ISD-1234 Review of Work

I require to update that same Item in Sharepoint with the details from the reply RE: email eg: body of email for responses. 

 

Essentially I require to use Email as a task tracker in sharepoint but I get replies all the times and the flow i have now just duplicates the responses and adds a new item every time a reply is sent. 

5 REPLIES 5
ccc333ab
Solution Sage
Solution Sage

You can use the "Conversation ID" to determine if this is the same thread or not.

 

I might suggest also storing the Conversation ID in your list, and when a new email is received, check if the converstaion ID exists or not. If it exists, update that time, otherwise add a new item. 

Hello - thank you for the reply! I'm a little bit new to Power Automate - just wondering if you would be able to point me in the right way of the Conversation ID and how this might look in a flow? 

ccc333ab
Solution Sage
Solution Sage

Just lost internet...so just quickly typing this on my phone. I'll try in the morning again and give you a better response if this doesn't make sense. But if you an supply some screenshots as well of your flow, that would also be helpful as I may be interpreting this incorrectly.

 

I am assuming you are using "when a new email arrives" to trigger your flow. If so, then one of the dynamic contents fields (much like you can get TO, FROM, SUBJECT) is Conversation ID. So you can use this field in Create Item, Conditions, etc.  So I'm suggesting something like: 

1. Trigger --- when email arrives

2. Do a get items with a filter to see if any itesms have the trigger's conversation ID

3. If exist, update the list with your data

4. If doesn't exist, create new item in list with your data

Hello, 

 

Please find screenshots of what i have built so far - 

 

amenegatti_1-1624509919107.pngamenegatti_2-1624509950822.png

 

ccc333ab
Solution Sage
Solution Sage

This would be my approach. Now my example here doesn't really do much with the list as I don't know what you are trying to do, so you'll need to update as required: 

 

1. I have a column created in my SharePoint list called ConvoID (type String). I wouldn't have this in a view for end users (if your list is exposed to end users). 

 

2. Starting off exactly as you did, I would trigger when a new email arrives, and then do a "Get Items" action, but I would add in a filter query to see if this "conversation" already exists (in other words, if the conversation doesn't exist, it is a brand new email, not a reply). 

ccc333ab_0-1624546413216.png

3. Then I need to check if anything is returned from this query. If the conversation exists, you would get a value from this get items call, if not, you'll get a blank result. To check this, I am just checking to see if the result has a length greater than zero. 

ccc333ab_1-1624546531477.png

4. Now if the length is greater than 0 (conversation exists) just update the item with whatever needs to be updated. If not, then you will create a new item with the data you require...but the key is that you need to make sure to put the conversation ID in the field you created to capture this. 

 

ccc333ab_2-1624546781919.png

 

Hopefully that works for you. 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,056)