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

Still no solution for setting date fields to blank ?

Hi all,

I've been looking through all possibles posts on this subject in this forum trying to find a solution that actually works for setting a date to blank in a SharePoint list. But it seems it's not the case yet...

Anyone would have an update on this ?

Emmanuel

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Still no solution for setting date fields to blank ?

HI @egallis 

 

Please use the below expression while submitting the date to Sharepoint:
If(IsBlank(DataCardValue8.SelectedDate),Blank(),DataCardValue8.SelectedDate)
Here, DataCardValue8 is the name of my Date Picker control.
Also, please enable Formula Level Error Management in the Experimental Features inside Advanced Settings. This is a mandatory step to follow.MicrosoftTeams-image (107).png

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

2 REPLIES 2
Super User
Super User

Re: Still no solution for setting date fields to blank ?

HI @egallis 

 

Please use the below expression while submitting the date to Sharepoint:
If(IsBlank(DataCardValue8.SelectedDate),Blank(),DataCardValue8.SelectedDate)
Here, DataCardValue8 is the name of my Date Picker control.
Also, please enable Formula Level Error Management in the Experimental Features inside Advanced Settings. This is a mandatory step to follow.MicrosoftTeams-image (107).png

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
egallis
Level 10

Re: Still no solution for setting date fields to blank ?

Hi @yashag2255,

Just tested it and, indeed, it works... Smiley Happy

I had seen one or two posts suggesting this 'workaround' but didn't pay any attention to it since I didn't seen any link between this error handling parameter and the fact that it does reset a date field to a blank value.

I'm really puzzled though to see that it does work.

I'd love to have someone from the MS PowerApps Team (@TopShelf-MSFT maybe) to give us an explanation on this particuliar behavior... Smiley Happy

Thanks anyway for pushing the tip back into my post,

Emmanuel

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

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