Creating items in List B from List A. If it does not exist, Create it. If it does exist, Update it.

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

How do I NOT create duplicate records when copying from List A to List B? If it does not exist, Create it. If it does exist, Update it.

I am having trouble with this, ive tried doing the filter query part that some people do - but it hasnt worked for me.

Current Workflow im using , it currently creates duplicates each time this is ran.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Trying something new, still not working:

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @wonka1234 ,
Do you want:
1. Trigger flow when listA has a new record or is modified.
2. Determine whether this record exists in listB.
3. If it exists, update this record, if it does not exist, create a new record
Here is test for your reference:
Here is listA:
Here is listB:
Here is flow:
Here is result:
1.create new item
2.Modify item

Best Regards
Cheng Feng

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

To confirm the logic -
I would like to create or update the item in list B. I believe that is what you have made.

I have replicated your flow - it does not work as expected. Nothing is coming to List B.

Couple of things -
Title in list B is renamed something else in the actual List B. in List A this is "Request_ID" , not sure if that throws off the filter part.

secondly I notice my apply to each statement is formed twice, instead of once for you.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft

new screenshots - hope they are useful.

current result - nothing is being written to List B

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @wonka1234 ,
The cause of this problem is:
1. You use the return value of get items to fill 【Create item】.
When the Blist has no Alist item, the Value return value of [Get items] is empty, and you use an empty value to create an item, and of course the result is also empty.
Please use the trigger's return value as padding.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft What does padding mean?

My: Yes condition Create Item are "triggers"
on the right side No Condition, My values are all "items apply to each" except for "Request_ID" which is a "trigger".

Is this correct?

Was this reply helpful? Yes No