0

I have a list in SharePoint which has 26 columns and I have a task to delete the contents of all rows except the first 4 columns. How can I do this automatically?

I created a flow in Power Automate but it turned out only a stream that deletes all lines. Maybe there are another methods? Thank you.

Improve this question
2
  • How many items are there in this SharePoint list?
    – Ganesh Sanap - MVP
    Commented Feb 13, 2023 at 12:20
  • From 50 to 400. I have different lists for which this needs to be done
    – ruslan88990
    Commented Feb 13, 2023 at 13:13

2 Answers 2

Reset to default
0

You can do it in a Flow - err, Power Automate. You'll need to fetch all the list items, iterate them, and then edit each one as needed.

Improve this answer
0

You can use Quick Edit as a workaround. You can open an empty Excel workbook, copy the empty cells and then paste them in the SharePoint list using Quick Edit. This can also quickly clear the values of multiple columns. Hope this can help you.

Improve this answer
1
  • This is an interesting way, thanks, but in my list there are select columns and calculated columns with which this method does not work
    – ruslan88990
    Commented Feb 15, 2023 at 7:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.