Good day
I have an editable grid in Powerapps that is linked to a SP list. Users need to enter dispatch date and receive date in the grid and then it should save to the SP list. I used this formula in the OnSelect function of the SAVE button
Patch('HR File track list',Update(MySPCollection),{field_7:DatePicker3_1.SelectedDate,field_8:DatePicker3.SelectedDate})
PLease assist.
Try this
Patch('HR File track list',{ID:ThisItem.ID},{field_7:DatePicker3_1.SelectedDate,field_8:DatePicker3.SelectedDate})
That works perfect thank you, but after the save the dates disappears from the grid in PA.
Is there a way that the dates can stay in grid in PA?
you need to change the default date of the date picker to which ever column contains the date in the sharepoint list, i.e. Thisitem.field_7
If your column is not a Date Time column but just a text column you will need to convert it to a date i.e. DateValue(Thisitem.field_7)
If I do that then the grid looks like this. Once the dates are typed in, then the dates I typed disappear and the grid change back to this.
Only first line of my SP list updates the dates.
you have a save button on each line, therefore, you are only updating one record at a time, not all records. The dates are appearing correctly, there date value in SharePoint is blank, so it will display the data as shown in your image, but notice the two that you have saved have the correct dates in.
The dates I enter in line 1 of grid, saves next to last line in grid.
on your gallery items are you sorting it by date modified? if you are, when you save the list order will change
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |