cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino
Level 10

Re: Ability to patch null values, any update?

Hi @tianaranjo

 

Have you followed the instructions here?

https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-dat...

 

Specifically you need to Patch a Blank() and also turn on error handling.  It works with Azure SQL Database but I have not tested with SharePoint lists.

tianaranjo
Level 8

Re: Ability to patch null values, any update?

@Meneghino  Thanks for your reply. I have tried following the instructions from this link with no luck.  Would you mind sending me an example of your Patch formula?

Meneghino
Level 10

Re: Ability to patch null values, any update?

With Azure SQL Database this works:

 

Patch('[dbo.mytable]', {ID: 123}, {MyColumn:Blank()})

Where 123 is just a record where MyColumn is currently not null.  The patch makes MyColumn's value null for record with ID 123.

ID is just an int column of mytable which is also the primary key

tianaranjo
Level 8

Re: Ability to patch null values, any update?

@Meneghino  As always; thanks!  One more question, what if the column is not blank because the Status is Closed.  How do I Patch the date for the same column?

tianaranjo
Level 8

Re: Ability to patch null values, any update?

@Meneghino  No luck with this one.  Any other suggestions?

 

Thank you!

Highlighted
tianaranjo
Level 8

Re: Ability to patch null values, any update?

Hoping to raise this again - has anybody patched a Blank() date back to a SP list after a date had previously been submitted?  I have an 'In Progress' and 'Closed Status column.  If Closed, a Date Closed is submitted.  However, the issue could be re-opened if customer not satisfied with action.  When I switch back to 'In Progress' status, I can make the DateClosed column 'appear' blank, however, OnSubmit, it is storing the initial DateClosed date.  

@Meneghino

@lesaltzm

quentinfr
Level: Powered On

Re: Ability to patch null values, any update?

 

hello @tianaranjo Tried with SQL... doesn't worked at all but I use datevar=0.... it works

Kind regards

Yemata
Level: Powered On

Re: Ability to patch null values, any update?

Have you found a solution for this ? I am trying to Patch people picker field but it is throwing error when field doesnt have value .  

 

Thanks in advance .

SHO_Developer
Level: Powered On

Re: Ability to patch null values, any update?

Hi, @Yemata

I try to do this Blank() function like this


Patch(SQL, LookUp(SQL, ID = Value), { Approved_Date: Blank() } );

So .. this is not work. I have no idea for this thing

Yemata
Level: Powered On

Re: Ability to patch null values, any update?

 

I used Submit form instead of patch . It worked fine. 

One my button OnSelect 

SubmitForm(FormRequest);
Navigate( FormSubmited, ScreenTransition.Fade)

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

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: 215 members 4,721 guests
Please welcome our newest community members: