Excel Table to Sharepoint List - Update List troubles (lengthoutputs error)

Like (0) Share

Report

Posted on 23 Mar 2023 19:45:03 by Dez_nz

Hi,

I am trying to update a Sharepoint list from an Excel sheet follow the Workflow shown in the YouTube video

https://youtu.be/eDOwoPG9ua8

I have copied the steps line by line and replicated the Excel sheet & List exactly as shown (i was having the same trouble with my actual sheet, so thought it copy it line for line to see if it was an issue with my sheet, or the process the Youtube video was showing.)

I am having issues with the lengthoutputs('Get_Items')?[body/value'] (is not equal to) 0 part of the Condition (shown in pic attached) and is returning the error attached (also shown in pic attached).

Help on this would be appreciated.

Thanks.

Condition.JPG

Error.JPG

All responses (1)

Answers (1)

Verified answer

v-chengfen-msft on 24 Mar 2023 at 03:03:56

Like (0)

Report

Re: Excel Table to Sharepoint List - Update List troubles (lengthoutputs error)

Hi @Dez_nz ,
Please try:
length(outputs('Get_Items')?[body/value'])

Best Regards
Cheng Feng