Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Translation Quality Feedback / Add Row in an Excel fi...
Power Automate - Translation Quality Feedback
Answered

Add Row in an Excel file from SharePoint

(1) ShareShare
ReportReport
Posted on by perrydan57 54
Hello,
When I am trying to add a row into an Excel table, I am receiving error 409 
"message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: 29998091-562d-4c3f-8e73-26fb0ad42d0a\r\nserviceRequestId: 61b2a6ae-5aff-40cc-b694-1e3162afddf2;4e9fbc44-a36e-4cb5-95ab-6e94b12037cc;ba293816-d7a9-455d-a554-19bd37238c5a;c33ef998-b8e6-4902-9ebf-7f8e3ecabac3".
 
That is my current flow:
Has anybody an idea for solving the issue
Categories:
General
  • perrydan57 Profile Picture
    perrydan57 54 on at
    Add Row in an Excel file from SharePoint
    Thanks Tom,
    unfortunately, that is not solving the issue.
    I have created a new Excel in Teams, looking that I have no merged cell and no value.
    I have only header line into it:
    Any other idea?
  • Verified answer
    trice602 Profile Picture
    trice602 13,728 Super User 2025 Season 1 on at
    Add Row in an Excel file from SharePoint
    Hi,
     
    On the surface, the only thing I can think of is there are either merged cells somewhere on the workbook and may be interfering with the add a row into a table OR there is data below this table, even whitespace or a cell with a space in it and when you are trying to add a row to the table, it will not move that whitespace cell data down another row (or overwrite it).  The latter is most likely the root cause but double check both.
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans