Hi guys,
I did an integration about Oracle and Sharepoint. Here is my flow.
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 ?
Is there any pattern to the specific records that are duplicated?
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.
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.
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.
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?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2