Power Platform Community Forum Thread Details

I am trying to get rows from a google worksheet to push to a sharepoint list on a scheduled timer. I can get the flow working, but cannot figure out a way to have it check for existing line items. Any advice on how to have it check for existing values in the list compared to the Get Rows from the google sheet? I've tried numerous google search results, but nothing that has come up has given me a working flow.

Categories:

Building flows

The easiest and most reliable approach is to use a unique key (for example, Employee ID, Order Number, Email Address, or another column that uniquely identifies a row) and compare against that value before creating the SharePoint item.

Small lists (<500 rows)

Use:

Get items

Condition
Create/Update

Large lists (>500 rows)

Use:

Get all SharePoint items once

Filter array in memory
Create/Update

Recurrence + Get Rows (Google) + Get Items (SharePoint) + For each Google Row + Filter existing SharePoint items + Exists? Yes → Update/Skip
No → Create Item

The key is having a unique identifier that exists in both systems. Without a unique key, Power Automate has no reliable way to determine whether a Google Sheet row already exists in the SharePoint list.