Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(0) ShareShare
ReportReport
Posted on by

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.

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

    Hi @Dez_nz ,

    Please try:

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

     

    vchengfenmsft_0-1679627024727.png

     

     

    Best Regards

    Cheng Feng

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics