0

Every day I have to paste in new values for three columns in a Sharepoint list. To confirm, I want to keep the list items, but want to overwrite the existing values with the new values I'm pasting. Only these three columns are shown in my list view.

In quick edit mode, I tried selecting all of the items and backspacing, but it only clears out the first cell. So there's got to be a better way (I hope).

What is the safest and quickest way to clear those values, please?

Improve this question
1
  • So I'm left wondering there's no way to do this easily? I'll give Power Automate another look; perhaps there's something I overlooked.
    – rizingfenix
    Commented Jul 28, 2020 at 21:32

2 Answers 2

Reset to default
1

I might have found a workaround for using Quick Edit.

The Delete action doesn’t work but the Copy and Paste action works. So I open an empty Excel workbook, copy the empty cells and then paste them in the SharePoint list using Quick Edit.

It works for special columns (Person and Group/Lookup) as well.

enter image description here

Improve this answer
3
  • Great idea! It works for me. Thanks so much!
    – rizingfenix
    Commented Jul 29, 2020 at 16:47
  • @rizingfenix Would you please give it a vote or accept it as answer if you find the reply helpful in any way? It will help others in this forum to find answers quickly as well. Thanks.
    – Chelsea_MSFT
    Commented Jul 30, 2020 at 6:33
  • Doh! Absolutely! :)
    – rizingfenix
    Commented Jul 31, 2020 at 13:36
0

Change the data type, ie. text to number. The non conform data will be deleted, then you can change back. Works for simple cases and pretty fast to execute

Improve this answer

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.