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 .

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (1)

Sort by

BCBuizer 22,707 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @batvan276 ,

Can you please share the odata filter you have set on the Get Items action? That's where I usually go wrong 😉

Was this reply helpful? Yes No
batvan276 206 on at

Like (0)

Report
Copy link

Link copied!

Sorry about that .

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

If that Number column is actually a number or integer & not a string type data, then you’ll want to remove the single quotes around it.

Was this reply helpful? Yes No
batvan276 206 on at

Like (0)

Report
Copy link

Link copied!

This is the format ;

CXTX00#####

I did it correctly no ? Reza had something similar.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yeah, that looks right then.

Was this reply helpful? Yes No
batvan276 206 on at

Like (0)

Report
Copy link

Link copied!

I tried swapping but same issue ;

Can someone explain what the output value means?

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
batvan276 206 on at

Like (0)

Report
Copy link

Link copied!

I am going to take a look at the data format but is this an issue ;

Was this reply helpful? Yes No
batvan276 206 on at

Like (0)

Report
Copy link

Link copied!

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 .

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No