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 a row problem

(0) ShareShare
ReportReport
Posted on by 62

Hello everybody.

I try to use the "update a row" method on this table:

SaschaBerner_0-1661714013998.png

with this flow:

SaschaBerner_1-1661714088676.png

and get this error:

SaschaBerner_2-1661714178321.png

Does anybody have ideas?

Thanks!

Categories:
I have the same question (0)
  • Verified answer
    Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Seems like data is not in Table Range. Goto Table Design>Select Table Name>Click on Resize Table> check Key Value in Table Range or not. If Key Value is not in Table Range then error will occur.  In this case i am giving Key Value as 6 hence getting error in my flow.

    Kaif_Siddique_1-1661715649345.png

     

    Hope this will help you and let me know if any further queries.

     

    If you like my response, please give it a Thumbs Up.
    If this helps, please Accept as solution.

     

    Regards
    Kaif

  • SaschaBerner Profile Picture
    62 on at

    That's it!

  • jmwisa1234 Profile Picture
    5 on at

    Thank Kaif, you're a legend! This solved my problem with update a row too.

    My table range was A:J and I couldnt select a smaller range on the web version of outlook without this error "This would change to many cells. Select a smaller range and try again."

    Resized the range from A1:J150 in the desktop version of Excel and it works a charm!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 523

#2
Valantis Profile Picture

Valantis 318

#3
David_MA Profile Picture

David_MA 235 Super User 2026 Season 1

Last 30 days Overall leaderboard