Unanswered

Append to existing SharePoint list row if date already exists.

(0) Share

Report

Posted on by StuartSmith

220

I have a form that consists of a "Date Picker" and then several "Text Inputs". Upon submitting the form, the sharepoint list is updated. Is there a why that if a user selects a date from the date picker that already has a row in the sharepoint list, instead of created a new row when they submit the form it, simply appends the new text in the form to the end of the already submitted data in the sharepoint list.

Thanks in advance.

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report
Re: Append to existing SharePoint list row if date already exists.

Hi @StuartSmith

You can set a condition on a button for submitting data.

If( IsBlank(Lookup(SPlist,somedate=DatePicker.SelectedDate), Patch( SPlist,Defaults(SPlist),{field1:Textinput1.Text,field2:Dropdown1.Selected.Value,etc} ), Patch( SPlist, Lookup( SPlist, somedate=DatePicker.SelectedDate ),{field1: Textinput1.Text, field2: Dropdown1.Selected.Value, etc} ) )

This formula tests to see if there is a field that matches the datapicker control's date and if not, creates a new item, If there is already an item that matches the date selected in the datepicker, then it will modify that item.

Was this reply helpful? Yes No
StuartSmith 220 on at

Like (0)

Report

Re: Append to existing SharePoint list row if date already exists.

Thanks for responding so quickly. I'm just trying to work out your code...
Upon entering my code, I get an error

What am I doing wrong? on your code you put "somedate=datepicker.selected", what do you mean by "somedate"? I put the name of the sharepoint date column. Is that correct?
Thanks in advance

Was this reply helpful? Yes No
StuartSmith 220 on at

Like (0)

Report

Re: Append to existing SharePoint list row if date already exists.

@Drrickryp are you able to help with the below?
Thanks in advance,

Was this reply helpful? Yes No