Delete date value SharePoint List

[RichardB]

Hello,

Have been been testing and playing with the embedded PowerApp (customised SharePoint forms) and cannot delete a date from the list after it has been saved. This problem has existed for some time with 'regular' PowerApps and even trying to Patch a null value doesn't seem to work.

I appreciate that many times you will not need a date to be deleted, however there are occasions when an incorrect record has been updated with a date and this needs to removed.

Does anyone have any solutions or recommendations to workaround this apparent limitation.

cheers Richard

[leyburn19]

Heve you tried Blank()

it supposed to set a record to null

[RichardB]

Hi there.. thanks for the quick response

I have tried this, but it doesn't work for me. This is the code I'm using

Patch('Test PowerApps List',First(Filter('Test PowerApps List',ID = ThisItem.ID)), {CompletionDate:Blank()})

It doesn't error, it just doesn't work !

[leyburn19]

How many records in the table.  If over 500 there will be an issue with delegation

[v-monli-msft]

Hi @RichardB,

My understanding is that when you do not select any date in the datepicker control(which binded to SharePoint date column), and submit the EditForm, you want to display blank value in SharePoint, not the default date. 

If try to create a new item directly in SharePoint site, you will notice that even though you do not select any date, this column will still show some date by default. So this is not just issue with PowerApps. To achieve this, you could actually try to set it on SharePoint list when you create one. 

I'm no expert on SharePoint, so I have found a blog talking about this:

The writer used the following formula:

=IF(ISBLANK([New Completion Date]),””,TEXT([New Completion Date],”MMMM YYYY”))

SharePoint calculated column formatting a date that is null - Wendy Neal

http://wendy-neal.com/2015/08/sharepoint-calculated-column-formatting-a-date-that-is-null/

Or you could post this question in SharePoint community and ask about this:

https://social.technet.microsoft.com/Forums/sharepoint/en-US/home

Regards,

Mona

[RichardB]

Hi Mona,

Thanks for your response, however it doesn't quite address the issue I've described.

My scenario is I have a date already saved in the SharePoint list (either saved via PowerApps or some other process)

I would like to use PowerApps as the mechanism to then delete this date from the SP list and would like to know the PA syntax/formula that should be used to achieve this.

thanks

Richard

[DanielK]

 Hi RichardB,

Did you find a solution? I have the same problem.

Regards, 

Daniel

[RichardB]

Hi Daniel,

Have to confess that I didn't pursue this one any further and just implemented a work around by setting the date to 1/1/1900 and then handling that in the UI.. not ideal, but it worked (up to a point) as long as you handle this when doing any date calculations such as DateDiff etc.

I believe that PA is going to provide the functionality to write Null values into SharePoint lists, but don't have any details .. is there anyone from the PM group who could provide further information on this?

cheers

Richard

[zac1]

Found this and it worked for me....

https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-C...

[zac1]

https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-C...