cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Re: Cannot update a field to an empty value

I have the same issue with person field. Can we please get an update on this that when can we patch other field types with null values? 

Meneghino
Level 10

Re: Cannot update a field to an empty value

SergiP
Level: Powered On

Re: Cannot update a field to an empty value

This proposed solution doesn't work. The reset = true doesn't clear the date field in the selected record.

So far the only solution that I've found to work (unfortunately) is patching a new record with all exact same fields than the original one but the date I want to clear and then removing the original record.

hope it helps!

Meneghino
Level 10

Re: Cannot update a field to an empty value

@SergiPthe Reset property is used to reset the control, not the database field.

Please see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/properties-core

toms_pi
Level: Powered On

Re: Cannot update a field to an empty value

Is there a solution today ? 

Zi
Level: Powered On

Re: Cannot update a field to an empty value

Is this issue fixed? I am new to PowerApps, saving empty value to text box works, but got stuck in saving empty value to datetime control and dropdown choice control.

LozzieD
Level: Powered On

Re: Cannot update a field to an empty value

I couldn't find anywhere that says how in Flow to set a text field to blank.  The empty string "" merely inserts the double quotes into the text field.

 

Initializing a variable as a string and then setting the text field to the output of the variable worked for me.

 

I'm sure someone else has thought of that but now it's here's too.

GeorgiL
Level: Powered On

Re: Cannot update a field to an empty value

Initialize an Empty String Variable with the "Initialize Variable" action. Then set this variable to the field you want to blank out.

 

Greetings,

George

SamPo
Level 8

Re: Cannot update a field to an empty value

I'm having the same issue with the person field. It demands a 'record' format for the data and then states that the "user cannot be found" when using empty strings. Please advise.

Highlighted
RudBen
Level: Powered On

Re: Cannot update a field to an empty value

Any update?

As of today (10.08.2018) this issue is still present on MySql connections: can't update a decimal with a (null), you must at least insert a zero.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 116 members 4,646 guests
Please welcome our newest community members: