web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Update Item

(0) ShareShare
ReportReport
Posted on by 372

Hi,

 

I have this flow,

firda59_0-1696560529666.png

firda59_1-1696560581791.png

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

Title = No Drawing

firda59_2-1696560854047.png

 

Formula:

outputs('Get_items')?['body']?['value']?[0]?['ID']
 

I change data row 1, but it turns out the flow create all item again. I want when I just edit 1 row/ add one row in existing file, then it the flow run for update item / create item (if I add one row or add new file in that document list).

 

can anyone checked what is wrong with my flow? thankyou!

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    I have a suspicion that your Get items is not returning any records.

    Can you add a compose action and see what does length(outputs('Get_items')?['body/value']) return?

     

  • firda59 Profile Picture
    372 on at

    @SudeepGhatakNZ 

     

    what does compose action mean? I'm sorry, I just learn this platform by myself, and I'm still learning about function in this platform. 

     

    but, this is the result from get items:

    firda59_0-1696566384236.png

    and the title value not appear, do you know why this happen? thankyou

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Your filter query is incorrect.

    Can you post a screenshot of the Excel sheet and highlight the columns you need in the filter query?

     

     

  • firda59 Profile Picture
    372 on at

    @SudeepGhatakNZ 

     

    this is my excel

    firda59_0-1696572571413.png

     

    This is the SP list

    firda59_2-1696572652314.png

    its for No Drawing field:

    firda59_1-1696572621851.png

     

  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    SudeepGhatakNZ_1-1696578017820.png

    Assuming that you have items in SharePoint matching those values

     

     

  • firda59 Profile Picture
    372 on at

    @SudeepGhatakNZ 

    thankyouuuu!! it can work now!!!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 282 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 159 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 146 Super User 2026 Season 2

Last 30 days Overall leaderboard