Answered

Insert and Update API to SharePoint list

(0) Share

Report

Posted on by DCDataAnalytics

How do I loop through items in an API and compare the data to a SharePoint list when both have an OrderID as a primary key in common.

Here is the flow so far:

I'm not sure how to do the comparison within the Apply to each loop. How do I compare the API item to a SharePoint row, insert a row that does not exist in SharePoint, and update existing rows?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

lbendlin 8,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

How large is your SharePoint list? Might make sense to prefetch the entire list rather than having to query it in each loop iteration.

Was this reply helpful? Yes No
Verified answer

DCDataAnalytics 26 on at

Like (0)

Report
Copy link

Link copied!
I found the solution:
Loop through each item returned by the API using an Apply to each control
Use a SharePoint Get Item to check the SharePoint list
Use a condition to see if the item was found in SharePoint
If yes, update it via a SharePoint Update item
If not, insert it via a SharePoint Create item

Was this reply helpful? Yes No
DCDataAnalytics 26 on at

Like (0)

Report
Copy link

Link copied!

Less than 10,000 items

Was this reply helpful? Yes No