Power Platform Community Forum Thread Details

For each email received in a specific Outlook box, I create an item in a SharePoint list. With various information, ID, time, etc.

There are some automations, which send automatic emails, according to the status I change in this list. I now need to create a way for the original email responses to be the same id's with a suffix.

Here's a more logical example:

When a new email is received:

A new item is created in the SharePoint list.
An ID is assigned to the new item (eg ID 1001).
The e-mail received is related to this ID.

When someone replies to the original email:

The response is received and processed and created in the list.
Instead of incrementing the ID (eg to 1002), the same original ID (1001) is kept.
The response is related to the original ID but with a suffix (eg 1001.1).
This pattern continues for subsequent responses (1001.2, 1001.3, and so on).

That is, before creating the item on the list, I need to check if it is a reply from an email that is already on the list. The problem is finding an identifier for it. I've already tested the MessageID and ConversationID, but they change when replying to the email. Can anyone help me?

Categories:

General topics