web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : hZaLyRiOIdHWOESTs048E/
Power Automate - General Discussion
Unanswered

Oracle Db to Sharepoint integration

Like (0) ShareShare
ReportReport
Posted on 9 Nov 2023 17:51:44 by

Hi guys,

I did an integration about Oracle and Sharepoint. Here is my flow.
urhanmustafa_0-1699525001678.png
When I check the oracle db some values 1 record but in the sharepoint list dublicate. I don't know why. Total records 5162.
I learned get rows limit is 2048. After I increased this limit. But I don't know why this records dublicate ?

  • Rhiassuring Profile Picture
    8,688 Moderator on 10 Nov 2023 at 19:35:08
    Re: Oracle Db to Sharepoint integration

    Is there any pattern to the specific records that are duplicated?

  • Community Power Platform Member Profile Picture
    on 10 Nov 2023 at 09:53:18
    Re: Oracle Db to Sharepoint integration

    My problem is second. But every record not dublicate. Some spesific records dublicate. I am delete to the list. After creating a new list. And after 1 click again same results.  Same records dublicate same records 1 record.

  • Rhiassuring Profile Picture
    8,688 Moderator on 10 Nov 2023 at 09:49:29
    Re: Oracle Db to Sharepoint integration

    Are you saying that your "Output" from "Get Rows" show 2 items?  Or are you saying that more than 1 are appearing in your SharePoint list? If the latter, then, your problem is what I mentioned.

  • Community Power Platform Member Profile Picture
    on 10 Nov 2023 at 05:53:04
    Re: Oracle Db to Sharepoint integration

    Once 1 time run, some values creating dublicate. When I export the oracle db list to excel, this dublicate values shows 1 record. 

    I don't know how is it possible ? I am connecting to same table.
    Therefore my second aim is like your said.

  • Rhiassuring Profile Picture
    8,688 Moderator on 09 Nov 2023 at 21:38:33
    Re: Oracle Db to Sharepoint integration

    If you've run it more than once, and you don't have any condition to tell SharePoint "do not create this if it already exists", then yes, it will duplicate.

     

    Are you wanting to populate the SharePoint list only with content from the Oracle DB that doesn't already exist in the target list?

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete