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 Platform Community / Forums / Power Automate / Delete row but getting...
Power Automate
Answered

Delete row but getting conflict error "This won't work because it would move cells in a table on your worksheet"

(0) ShareShare
ReportReport
Posted on by 184

Hi there,

 

I hope someone can help me out.

 

I set up autoarchiving on a spreadsheet (it copies a line across to an archive tab when marked as complete and then delete it from the working tab), however, after it has been running fine for a month or so it suddenly started having a conflict error and stopped deleting the files.

 

I've cleared all below and beside the table, I've check the range is correct and everything looks good but I'm still having the error.

 

I have another Flow which adds form responses to the spreadsheet which is working fine.

 

Any suggestions how to further trouble shoot this issue?

 

Cheers

 

Pip

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @PipManifold :

    I suggest you clear the filter in the table and save it. And then check if the problem still exist.

    Maybe this link will help you a lot:

    Getting this message: "This won't work because it would move cells in a table on your worksheet." 

    vbofengmsft_0-1644372383422.png

    Best Regards,

    Bof

  • PipManifold Profile Picture
    184 on at

    Filtering! Yes, that seems to be what is causing the issue.

     

    I used this to set up a script to run before the archiving to remove any filters: https://powerusers.microsoft.com/t5/Building-Flows/How-to-remove-filter-in-excel-online-sheet/td-p/855462

     

    Thanks so much @v-bofeng-msft 

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 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard