Add & Update Excel Data to SharePoint List using Power Automate

(0) Share

Report

Posted on by batvan276

206

Hello All,

I followed Reza Dorrani 's video guide

to build a similar from but I am running into problems with the updating and creating a new entry portion using this expression;

length(outputs('Get_items')?['body/value'])

as a condition to create a new entry or update the existing entry. I am unsure as to what I am doing wrong. Can someone take a look and help ?

My flow will keep creating new entries .

All responses (16)

Answers (1)

BCBuizer 22,262 Super User 2025 Season 1 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

Hi @FelipeScheihing ,

Try removing the space in the column name: Crew#
FelipeScheihing 4 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

Hello everyone,
I am trying to the same guide. However, I'm getting this error:

Any idea?
Side note: apparently, the Table header is not being read correctly

Thank you, guys! This is my first interaction/post here. Please let me know if I am doing it in the wrong place /way.
Verified answer

BCBuizer 22,262 Super User 2025 Season 1 on at

Like (0)

Report
Re: Add & Update Excel Data to SharePoint List using Power Automate

Hi @batvan276 ,

You need to tie your loop to the "List rows present in table" action:

You can do so by replacing the circled input field with:

@{outputs('List_rows_present_in_a_table')?['body/value']}

After this is done, you can select Excel dynamic data as part of the Filter Query in the Sharepoint Get Items action.
batvan276 206 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

I am trying to pull the Column "Number" from the excel ;

It doesn't look like I can pull any dynamic content .
takolota1 4,896 Super User 2025 Season 1 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

@batvan276

Your previous step shows you using a Number column from a SharePoint action.

Have you tried replacing that with the correct Excel dynamic content?
batvan276 206 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

Here it is . I appreciate the help. I am pulling the data from an excel file in a document library.

Here is the result from the List Rows table Action ;
takolota1 4,896 Super User 2025 Season 1 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

@batvan276

Can you show the rest of the flow and the pieces before this loop. Like the SharePoint action you're getting this number from?
batvan276 206 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

I checked my data - Excel is Text and SharePoint is Single Text Line

I am stuck - unsure what to further t-shooting I can do . Appreciate any help .
batvan276 206 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

I am going to take a look at the data format but is this an issue ;
takolota1 4,896 Super User 2025 Season 1 on at

Like (0)

Report

Re: Add & Update Excel Data to SharePoint List using Power Automate

Ah okay

The output here should list all the rows that match your filter criteria. There’s nothing logically wrong with your condition it is correctly registering that the length of the SP output is not greater than 0 (it’s empty).

You probably have an issue with your data where there is no row with data in the ContractNumber column that EXACTLY matches the number from your other SP source.

But also, if this is all inside a loop, make sure you are checking the other loop instances too.