Link between excel table and SharePoint List

(0) Share

Report

Posted on by MT-21050704-0

I am having this issue with my flow. It is the first time for me using Power Automate, I have managed to make the flow work with a smaller excel table of 4 entries, but when I try to do the same on the bigger table 150 entries, I get errors and I am having it different to understand how to fix it. Anyone is able to help me out?

Maybe the file is to heavy? because it also contains multiple other tabs, and the table itself I am trying to populate contains vlookups of other tables. So not sure if the problably is more in excel and less on the flow itself. Have you ever experience something like this? Or what could the best practices be?

Thank you so much.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

This is NOT because of file size (150 rows is small).

With 4 rows:
No empty lookups
All matches exist

With 150 rows:
I assume, for some rows: no lookup result, missing key, mismatch with SharePoint

Look at one of the items that failed:

Make sure BOTH sides match exactly (Excel and SharePoint column)

Check for no extra spaces, casing issues or data type mismatch.

Your Id is missing, wrong, or coming as null.

Was this reply helpful? Yes No
Suggested answer

Amardeep Raj 74 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MT-21050704-0 , please find the video link and watch the video. I have created pretty much the same flow; only the table columns are different. We used the country list as an example. I have also enabled pagination on the list rows in Excel, so it will work well for more than 250 records. Additionally, I provided the FX formula for your reference.

FX:
@{outputs('List_rows_present_in_a_table')?['body/value']} = Apply to each
CurrencyCode eq '@{items('Apply_to_each')?['CurrencyCode']}' = Get items

length(outputs('Get_items')?['body/value']) = Condition
@{outputs('Get_items')?['body/value']?[0]?['ID']} = Update item

Here is the video Link
SyncExcelAndSharepointList.mp4

If the issue is resolved, click the "Mark as Answered" button on the helpful reply so others facing the same error can find the answer quickly.

Thank You

Was this reply helpful? Yes No
Suggested answer

Radwan Almsora 24 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

Welcome to the community! Don't worry, your file size isn't the problem here, and you are actually very close to fixing this.

Looking at your screenshot, the exact error is at the very bottom inside the Update item action:

...following parameters are null or empty: 'id'

What is happening:

When you tested with 4 entries, every row had a valid ID. But in your larger 150-row table, some rows likely have a blank or missing value in the column you are using for the SharePoint ID. Because your table has VLOOKUP formulas, if a formula returns an error (like #N/A) or a blank value for even one row, Power Automate doesn't know which SharePoint item to update, causing the whole flow to crash.

How to fix it quickly:

Check your Excel Data: Open your Excel sheet and check the column you are using as the identifier. Make sure there are no blank cells, #N/A, or formula errors in any of those 150 rows.

Add a Safeguard (Best Practice): Before your "Condition" action, add a simple check to skip empty or broken rows.

Inside your loop, add a Condition action.

Set it to: If ID (from Excel) is empty (or is blank).

Leave the True side empty (this skips the bad row), and move your entire current logic into the False side so it only processes rows that actually have an ID.

Give this a try! It’s a very common milestone when scaling up your first flow. Let us know if it clears the error.

Best regards,

Was this reply helpful? Yes No