Answered

flow issue

(0) Share

Report

Posted on by CU22080239-4

I have created a daily run flow.

Compare records (basing on Italent ID) between a SharePoint list (call A list) and an Excel list (B list), for record exists in B list but doesn't exist in A list, then create the item in A list.

This flow runs for a long time, but recently we found that items were created duplicate in A list, after checking running history but cannot find what's the problem.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@YanLiang how many records do you have in excel?

Was this reply helpful? Yes No
CU22080239-4 on at

Like (0)

Report
Copy link

Link copied!

500+

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@YanLiang i would suggest to design your flow as following to check if excel value exists in SharePoint List. Here i am comparing ID columns from excel and SharePoint you can use whichever column you need to use. The condition checks the length of items returned by filter array is zero then value from excel doesnt exists in SharePoint.
Condition Expression
length(body('Filter_array_2'))

Was this reply helpful? Yes No