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 : w/fONBh61oWp93OLaiUmO8
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!

I have the same question (0)
  • 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 725 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 363 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 341

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow