How to identify a mail chain in logic app ?

Tushar Lakhotia 0

Hello Team,

I am using Logic apps for one of my client in which we forward the email using logic apps to thier respective department based onto the body of the mail and I also need to store the emails into a database.

I am able to do the above things easily . But Now when someone reply to those mails , its becomes a chain of mail . Now In the storeage field instead of storing the mail as new mail. I need to update the previously stored mail with the new body or have a coomnon key atleast, so that I can maintain the chain in the database.

But In the logic app , I am not able to identify is this a new mail or a reply to one of the previous mail.

I am also not able to find any such common field with the parent mail and the reply mails. The CONVERSTION_ID and MESSAGE_ID field are also different for the parent and reply mail respectively.

Thanks in Advance !

Shireesha Eeraboina (Quadrant Resource LLC) 660 Reputation points Microsoft Vendor

2025-01-13T08:08:46.1533333+00:00

Hi @Tushar Lakhotia ,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here. I apologize for any inconvenience caused on this.

As, I am providing an alternative workaround which might help you in resolving your issue.

In Logic Apps, the Thread ID is the ID of the thread the message belongs to, while the Message ID is unique to each email. When using the Gmail connector, both the Thread ID and Message ID are available, but the Thread ID remains the same for all emails in the same conversation thread12. This can be useful for identifying replies, Since the Conversation ID and Message ID are different for parent and reply to emails, you can use the Thread ID as a common key to link emails in the same conversation. This way, you can maintain the chain in your database by updating the record with the same Thread ID.

Ensure that your Logic App is configured to capture the Thread ID from incoming emails. You can then use this Thread ID to check if an email is a reply to an existing conversation and update the corresponding record in your database.

Below is the step-by-step process to Use Thread ID in Logic Apps

Go to the Azure portal and navigate to "Logic Apps" and click on "Add" to create a new Logic App and fill in the required details and click "Create", Once your Logic App is created, open it and click on "Blank Logic App" and add a trigger by searching for "When a new email arrives" to configure the trigger to capture incoming emails.

After that add a new step to your Logic App by clicking on "New step" here search for "Compose" and add it, in the "Inputs" field, add the dynamic content for Thread ID from the email trigger because this will capture the Thread ID of the incoming email again add a new step to your Logic App by clicking on "New step" and search for your database connector (e.g., SQL Server, Azure Table Storage) and add an action to "Get rows" or "Query" and configure the action to check if the Thread ID exists in your database.

Again, add a condition to your Logic App by clicking on "New step" and then "Condition" here set the condition to check if the Thread ID exists in the database. If Yes: Update the existing record with the new email body. If No: Insert a new record with the email details and Thread ID.

For the Yes branch of the condition, add an action to update the existing record in the database with the new email body and for the No branch of the condition add an action to insert a new record in the database with the email details and Thread ID.

I hope this addresses your query. If you have any further questions or concerns, please feel free to reach out to us.

2 answers

Nitish Sharma 436 Reputation points

2025-01-11T21:18:43.8633333+00:00

Hi @Tushar Lakhotia ,

I can think of 2 ways of doing this:

I hope the mail subject lines remain common in replies and no one is updating the subject of mail while replying to it. You can use subject of mail as a key to group emails in the database. Strip prefixes like RE or FW to normalize the subject for matching and updating the body of mail.

If subject is not the only thing that can be used to link, then it will be good to combine multiple fields like sender mail address, recipient mail address, and subject.

You can try the above 2 options to link and save your mail in the database.
Please sign in to rate this answer.
Tushar Lakhotia 0 Reputation points

2025-01-12T01:52:01.36+00:00

No , Multiple emails can have the same subject and what if I sent the same email to different people and they reply to me individually!

Both the solutions will not work in these cases.

Thanks

Tushar Lakhotia 0 Reputation points

2025-01-12T01:52:30.57+00:00

No , Multiple emails can have the same subject and what if I sent the same email to different people and they reply to me individually!

Both the solutions will not work in these cases.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Nitish Sharma 436 Reputation points

2025-01-12T19:59:36.4133333+00:00

@Tushar Lakhotia I have tested the approach, and you should use Conversation Id as it remains the same whenever anyone replies or forwards the same mail.

So you can use that to link the mail chain and overwrite the mail in your database.
Please sign in to rate this answer.
Shireesha Eeraboina (Quadrant Resource LLC) 660 Reputation points Microsoft Vendor

2025-01-13T05:35:41.8966667+00:00

Hi @Tushar Lakhotia ,

Just checking in to see if the above answer provided by @ Nitish Sharma helped.

I hope the above provided information might help you, if you have any further queries, please feel free to reach out to us.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to identify a mail chain in logic app ?

2 answers

Your answer