web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Platform Community / Forums / Power Apps - Building Power Apps / Patch Blank Date to Sh...
Power Apps - Building Power Apps
Answered

Patch Blank Date to SharePoint Date Field

Like (0) ShareShare
ReportReport
Posted on 22 Mar 2021 18:52:36 by kmw1130 976

I am using a Gallery to Patch and Save to a SharePoint List, one of my fields is a date field (Closed Date).  The ForAll Patch doesn't save to SharePoint unless I have the Closed Date populated.  I want it to be blank until the item is updated.  How can I patch a blank date to SharePoint?

I have the same question (1)
  • Verified answer
    kmw1130 Profile Picture
    kmw1130 976 on 23 Mar 2021 at 13:38:43
    Re: Patch Blank Date to SharePoint Date Field

    This is what worked when submitting to SharePoint.

     

    'Date Closed': If(IsBlank(LineDateClosed), Blank(), DateValue(LineDateClosed)),

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 885 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 571

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 352 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans