when new email arrives subject values duplicates for related list item

(1) Share

Report

Posted on by Veblitz

2,249

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],': '))

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (1)

Report
Copy link

Link copied!

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

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

Output

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

@Veblitz

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

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No