web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Using Sharepoint list ...

Power Automate

Unanswered

Using Sharepoint list and don't want to create a new issue from a reply in shared mailbox

(0) Share

Report

Report

Posted on by ss82

6

Very new to Power Automate. I have built a flow that creates a new issues in sharepoint list from email, adds email body and attachments. Next step is to figure out how to not create a new task when someone replies to the email. Also, is there a way to update the task with the reply?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,870 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ss82,

I would suggest to use the Conversation Id property for this. You can store that in a separate column (single line of text) in your SharePoint List.

This way you can check with a Get Items action if you can find any matching items. If it returns none you can create a new item. If returns one, you can update that item.

Below is an example

In this example the additional field in the SharePoint list is created and has the name ConversationID.

1. The Get Items uses a Filter Query to check for matching items

ConversationID eq '@{triggerOutputs()?['body/conversationId']}'

2. The condition checks the length of the results, if it is 0 no matching items are found.

length(outputs('Get_items')?['body/value'])

3. In the If No the field values of the matching item are used by using expressions like:

ID

first(outputs('Get_items')?['body/value'])['ID']

Title

first(outputs('Get_items')?['body/value'])['Title']

ConversationID

first(outputs('Get_items')?['body/value'])['ConversationID']

Was this reply helpful? Yes No

Join the conversation