Can SharePoint Online Lists or Microsoft Lists be updated with a new comment by receving an email?

Question

Hi there

I want to create a support ticket system where users fill out a form and every time a comment is added to the item, users get an email notification.
When users reply to the email, it should update the list item (with the text in the email body).

Is it possible using to update SP Lists or MS Lists by receiving an email response? How?

Thank you so much.

Answer 1

Hi @frob
As the reply exceed the characthers allowed in comment, I convert the Comment as an Answer.

1. Yes, it is by power automate.
2. The TO address is the tenant the flow belongs to.
3. It is OK to set the FROM field blank.
4. We could remove the signature according to the same greeting format, for example, my maile signature ends with "Thanks, luyi"

Then the whole flow is as following:

Here please pay attention, I set the "Compose2" Inputs as "lastIndexOf(outputs('Compose'), 'Thanks')

Explanation: as my maile signature ends with "Thanks, luyi", so this flow is to remove the characters from "Thanks" to the end. For safety, you could set "Thanks" with other characters such as "Best regards" and so on.

The "Compose3" Inputs is substring(outputs('Compose'), 0, outputs('Compose_2'))

Save it. As a result, when I send the mail to the tenant address, the signature is missing, the item will be:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

4: /api/attachments/141688-image.png?platform=QnA 6: /api/attachments/141666-image.png?platform=QnA

Answer 2

Hi @frob
Currently we could only use flow to send mail to users when an item is created or modified, instead of a comment.

As to update SP Lists by receiving an email response, you could use flow as following:

As a result, I put the mail body to the column "text":

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.