when new email arrives subject values duplicates for related list item

(1) Share

Report

Posted on by Veblitz

2,245

When new email arrives im extracting subject values and storing it in the list item

Incoming email sample

Subject:USA,Client9

So if they are using same subject values but different attachments then it should update document library for the new attachment but at list item level it should not create new item as per below, so how to prevent duplicity in this context.

Flow details

How to prevent duplicates in the list item and in my case if the subject has same values then how to restrict those items

set country variable expression:

last(split(outputs('Compose')[0],': '))

set customer variable expression:

last(split(outputs('Compose')[1],': '))

All responses (4)

Answers (0)

Veblitz 2,245 on at

Like (1)

Report

Re: when new email arrives subject values duplicates for related list item

Apologies and please help me with more details of what should i check in the context of flow getting triggered more than once and what loop i need to put to check the same
SudeepGhatakNZ 14,376 Most Valuable Professional on at

Like (2)

Report

Re: when new email arrives subject values duplicates for related list item

@Veblitz

I don't see any loops in your flow, maybe your flow is getting triggered more than once. Can you check?
Veblitz 2,245 on at

Like (1)

Report

Re: when new email arrives subject values duplicates for related list item

I tried the same but no luck,its not creating new record for new items as well

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

Output
SudeepGhatakNZ 14,376 Most Valuable Professional on at

Like (2)

Report
Re: when new email arrives subject values duplicates for related list item

@Veblitz

You could query the list first using Get items with a filter

customer eq 'variables('Customer')' and country eq 'variables('Country')'

If the length of the action above > 0, employ the update , otherwise use the Add action.