PATCH A SharePoint Date Column In Power Apps



Goal

Change the VacationDate column (Date Type) from 11/7/2020 to 12/25/2020.


Input

Vacation Requests (SharePoint List)

IDEmployeeNameVacationDateHours
1Matthew Devaney11/7/20208


Patch Function Code
Patch(
    'Vacation Requests',
    LookUp('Vacation Requests', ID=1),
    {
        VacationDate: Date(2020,12,25) 
    }
)


Output

Vacation Requests (SharePoint List)

IDEmployeeNameVacationDateHours
1Matthew Devaney12/25/20208




Scenario #1: Date Picker

Patch a value found in a date picker to a Date field.



Patch Function Code
Patch(
    'Vacation Requests',
    LookUp('Vacation Requests', ID=1),
    {
        VacationDate: DatePicker_VacationDate.SelectedDate 
    }
)