Unanswered

SP list not updating from editable grid in PowerApps

(0) Share

Report

Posted on by Adwene

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.

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this

Patch('HR File track list',{ID:ThisItem.ID},{field_7:DatePicker3_1.SelectedDate,field_8:DatePicker3.SelectedDate})
Adwene 24 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

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)
Adwene 24 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Adwene 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Only first line of my SP list updates the dates.
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Adwene 24 on at

Like
a
(0)

Report
Copy link

Link copied!

The dates I enter in line 1 of grid, saves next to last line in grid.
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

on your gallery items are you sorting it by date modified? if you are, when you save the list order will change