Skip to main content

Notifications

Power Automate - General Discussion
Answered

comparing sharepoint and sql data and get latest data from sql

Posted on by 56

Hi All,

 

i have a SQL table with 2million rows and a same sharepoint list with same 2million records.

i need to create one flow which will compare sql records with sharepoint 

and get records which are updated in sql but not in sharepoint

and then last part is updating those records in sahrepoint.

 

i have basic idea of power automate but still i am new to this.

Any idea and advice will be helpful

thanks

  • Verified answer
    takolota1 Profile Picture
    takolota1 4,740 on at
    Re: comparing sharepoint and sql data and get latest data from sql

    @JitenderSinghEH @v-bofeng-msft 

     

    It is definitely possible with this batch action set-up:

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-External-Data/td-p/1365410

    But that will make for a rather advanced flow. Any beginner may want to get some help with it.

  • Re: comparing sharepoint and sql data and get latest data from sql

    Hi @JitenderSinghEH ,

     

    I'm afraid that flow can not deal with such a huge data table .Cause if we want to compare two tables, we need to use an 'apply to each' to traverse the entire table. But apply to each has a limited number of loops.

     

    I think this link will help you a lot:


    https://docs.microsoft.com/en-us/power-automate/limits-and-config#concurrency-looping-and-debatching-limits

     

    Best Regards,

    Bof

     

     

     

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard

Featured topics