Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Still no solution for setting date fields to blank ?

(1) ShareShare
ReportReport
Posted on by 1,594

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

Categories:
  • R3dKap Profile Picture
    R3dKap 1,594 on at
    Re: Still no solution for setting date fields to blank ?

    Hi @nmz027,

    No you're not putting it in the right place. You should put it in the datacard's Update property.

    In fact I'm not even sure that this code is still needed once you have enabled the Formula-level error management... 🙂

  • nmz027 Profile Picture
    nmz027 2 on at
    Re: Still no solution for setting date fields to blank ?

    Hello @R3dKap 

    Thank you for the solution. This seems to have worked for me. I wanted to confirm that I am putting this code in the right place. I put this If(IsBlank(DataCardValue67.SelectedDate),Blank(),DataCardValue67.SelectedDate); in the OnSave field. Is this the right place? Do I need to add it anywhere else?

    OnSave Photo.PNG

  • kris974 Profile Picture
    kris974 6 on at
    Re: Still no solution for setting date fields to blank ?

    thank you it worked!!

  • WarrenBelz Profile Picture
    WarrenBelz 145,666 on at
    Re: Still no solution for setting date fields to blank ?

    @kris974 ,

    In the Update of the DataCard the Date Picker is contained in.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • kris974 Profile Picture
    kris974 6 on at
    Re: Still no solution for setting date fields to blank ?

    Hello both,

     

    Where do you actually put the formula in power app? I believe I need to

    1. select the Card

    2. Advanced

    3. but then I dont know where add this formula?

     

    Thank you

    BR

    C

  • R3dKap Profile Picture
    R3dKap 1,594 on at
    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 (@Anonymous maybe) to give us an explanation on this particuliar behavior... Smiley Happy

    Thanks anyway for pushing the tip back into my post,

    Emmanuel

  • Verified answer
    yashag2255 Profile Picture
    yashag2255 24,442 on at
    Re: Still no solution for setting date fields to blank ?

    HI @R3dKap 

     

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard