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

Community site session details

Session Id : opX7fsL1zc5gSpvMljLuix
Power Automate - Using Flows
Answered

Update a row problem

Like (0) ShareShare
ReportReport
Posted on 28 Aug 2022 19:16:48 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!

  • jmwisa1234 Profile Picture
    5 on 04 Dec 2023 at 00:48:21
    Re: Update a row problem

    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!

  • SaschaBerner Profile Picture
    62 on 28 Aug 2022 at 19:52:47
    Re: Update a row problem

    That's it!

  • Verified answer
    Kaif_Siddique Profile Picture
    2,104 Super User 2024 Season 1 on 28 Aug 2022 at 19:46:01
    Re: Update a row problem

    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

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow