Unanswered

Clear SharePoint field data

(0) Share

Report

Posted on by DavidV

I would like to clear field/column value on click of a button for a particular item. I have a SharePoint Person type field (AssignedTo). I have tried using Patch and Blank function but it is not clearing the value. Currently, the AssignedTo value is set to a single user.

Patch(Bookings, First(Filter(TaskList, BrowseGallery1.Selected.ID = ID)),{
AssignedTo:Blank()
}
)

I have tried ClearCollection function and UpdateContext({ReservedBy:""}) but that didn't work as well.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

Adi2ro 42 on at

Like (0)

Report
Copy link

Link copied!

I have the same issue. Can't clear that field using PowerApps.If you find something, please let me know. 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Guys,

From my understanding, it looks like you would like to set a sharepoint field to blank, or null.

Here's what I did:
Set the input box to a variable(varFieldReset), then use OnSelect/OnChange to UpdateContext({varFieldReset:Blank()})

When you patch your field, it'll change it to Blank()

Let me know if that worked for you

Was this reply helpful? Yes No
Adi2ro 42 on at

Like (0)

Report
Copy link

Link copied!

I would try it, however we are dealing with a lookup of type "People" so now sure where to change that without getting an error. I guess one of the main problems is using this Lookup, since you can't customize it too much and still have expectations to work properly.

For example I have a column of type People and in my Edit Form, by default I want it to bring the default value, which is set. Now if I want to bring other values for selection, I don't know how to change that and keep the setting ok (since the lookup column has multiple field when it comes to it's source).

So if I just delete and submit form, it actually never deletes. Even worse... I have other fields taking value from there, for example a couple of Single Line of Texts, that takes FullName and Email from the person you are selecting. If I delete the selection, the fields appear blank, but when submiting the form, they actually don't submit a blank in the single line of text since the Lookup field, never actually get's a blank to submit.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Well, in order for you to get a blank one, what I did was create a blank item in Sharepoint list. Leaving this one blank would allow you to select blank as an option. Please use this only if a blank entry doesn't effect your data.

Now, for the other issue, you will have to set the default as a variable (PersonFullNameVariable and PersonEmailVariable).

Now for the Lookup dropdown box, use the "If" statement in the OnChange box to UpdateContext of the variable.
If(PersonLookup.Selected.Value=Blank(), UpdateContext({PersonFullNameVariable:Blank(),PersonEmailVariable:Blank()}),UpdateContext({PersonFullNameVariable:PersonLookup.DisplayName,PersonEmailVariable:PersonLookup.Email})
This way you what changes will be according to the variable. You'll also need to patch those changes to those columns as well otherwise, your changes will be done for nothing.

Hope this helps!

Was this reply helpful? Yes No
Adi2ro 42 on at

Like (0)

Report
Copy link

Link copied!

One last question:

Does this apply to lookup fields not dropdown? As my field is not a dropdown, is a people finder.

Was this reply helpful? Yes No
DavidV 20 on at

Like (0)

Report
Copy link

Link copied!

Looks like the reply is not respecting threaded conversation :). Thanks for your reply but UpdateContext ({AssignedTo:Blank()}) doesn't clear out the value of a People picker field.

Was this reply helpful? Yes No
DavidV 20 on at

Like (2)

Report
Copy link

Link copied!

I am still not able to figure this out. Is it not supported at all ? Can I please get an official response in that case?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

What is the "Input" box? None of the fields in Advanced menu have that title.

Was this reply helpful? Yes No
Eric_C 4 on at

Like (1)

Report
Copy link

Link copied!

Just ran into this problem and appear to have a working solution. Reading through a different post for Flow they were able to reset the field by using a -1. Try:
Patch(Source, Record, { Column: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:-1, Value:""} })

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi everyone,

After hours of reseraching I could not clear a date value on the SharePoint list using Powerapps. I got this to work by using flow. However, it's not what I wanted to use for something as simple as this, but it was a workaround for now incase anyone is looking for one.

Create new Instant Flow, initiated by PowerApps button.
Get Item, 'ask in powerapps' for the ID. In PowerApps on a button I did... On Select: FlowName.Run(ThisItem.ID)
See screenshot for steps in flow. In the date column, I went to the Expression tab, typed in null and clicked OK. Inserts a Null expression.

Was this reply helpful? Yes No