Answered

Update blank/Null value to fields in database

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Scenario : I have saved an item in a table and later decided to remove data from some fields (Date field, User field etc). Edit the item aand Save it back to datasource (SQL database)

Issue : PowerApps does not update the field to empty / null value. The field value remains but if I try to update field with a random string the update works. Blank() works for a new insert.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you share the update code you are using just to suggest based on your code.
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous

I just tried and turned out You need to turn on formula level error management under experimental features.
See the section 'Writing Nulls' in the following blog:
https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-dat...
View solution in original post

and the patch command for blank works

Patch( [@'[dbo].[StudentTest]'], LookUp( [@'[dbo].[StudentTest]'], StudentID = BrowseGallery1.Selected.StudentID ), { UserName: Blank() } )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The code that I'm using is, in update properties: If(Trim(DataCardEdit.Text)=""; Blank();DataCardEdit.Text)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I turned on "Formula Level Error Management" under experimental features on setting and my code work. I didn't use patch but If(Trim(DataCardEdit.Text)=""; Blank();DataCardEdit.Text).

Thanks.
PowerExplorer 65 on at

Like
a
(1)

Report
Copy link

Link copied!

MS Recommendation / Some People suggesting this feature .
Unfortunately ' Formula-level error management' being turned on caused an issue to the 'OnStart ' deep linking. All deep links stuck with 'Getting your data' upon opening the links. Any other way/solution to update SP choice field value to null/blank? I'd like users to cancel existing choice and save back to SP. Right now it does cancel in combo box but doesn't save and retains the old value.