Announcements
Hi,
i´m trying to create a button which clears/set a whole column in a sharepoint list to blank or 0. I´ve tried using the patch function but i cant get it to work or dont know what to fill in.
I´ve created a patch function for "ThisItem" before but dont know how to change it to a whole column so that all entries get patched.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@Anonymous Please have a look at the formular below.
This will set the column "request" to "" (Empty). The DataSource in the example is called SampleList
Patch(
Yes thanks that worked i couldnt get it to work with "" for blank but instead just 0 worked for me
@Anonymous
You can also utilize the UpdateIf function for this.
UpdateIf(youirList, true, {columnX: Blank()}) will set the columnX in ALL records to Blank().
However, in order to set a field to a blank value, you NEED to have the Formula-level error management feature turned on in your app feature settings. This is why you couldn't get "" to work.
I hope this is helpful for you.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 320
Mohsin Ali 246
