Answered

Delete date value SharePoint List

(1) Share

Report

Posted on by 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

Categories:

General Questions

I have the same question (0)

All responses (11)

Answers (1)

leyburn19 2,157 on at

Like (1)

Report

Re: Delete date value SharePoint List

Heve you tried Blank()

it supposed to set a record to null

Was this reply helpful? Yes No
RichardB on at

Like (0)

Report

Re: Delete date value SharePoint List

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 !

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report

Re: Delete date value SharePoint List

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

Was this reply helpful? Yes No
v-monli-msft on at

Like (0)

Report
Re: Delete date value SharePoint List

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

Was this reply helpful? Yes No
RichardB on at

Like (0)

Report

Re: Delete date value SharePoint List

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

Was this reply helpful? Yes No
DanielK 4 on at

Like (0)

Report

Re: Delete date value SharePoint List

Hi RichardB,

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

Regards,
Daniel

Was this reply helpful? Yes No
RichardB on at

Like (0)

Report

Re: Delete date value SharePoint List

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

Was this reply helpful? Yes No
zac1 51 on at

Like (0)

Report

Re: Delete date value SharePoint List

Found this and it worked for me....

https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-Choice-field-etc-in/m-p/116448/highlight/false#M41488

Was this reply helpful? Yes No
zac1 51 on at

Like (0)

Report

Re: Delete date value SharePoint List

https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-Choice-field-etc-in/m-p/116448/highlight/false#M41488

Was this reply helpful? Yes No
DanielK 4 on at

Like (0)

Report

Re: Delete date value SharePoint List

Thank you, it works.

Was this reply helpful? Yes No