Skip to main content

Notifications

Power Automate - Using Flows
Answered

flow issue

(0) ShareShare
ReportReport
Posted on by

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.  

YanLiang_0-1668498945382.png

 

  • Verified answer
    annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: flow issue

    @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.

    annajhaveri_0-1668683007926.png

    Condition Expression

    length(body('Filter_array_2'))
  • CU22080239-4 Profile Picture
    CU22080239-4 on at
    Re: flow issue

    500+

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: flow issue

    @YanLiang  how many records do you have in excel?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics

Restore a deleted flow