Answered

Saving a SharePoint List Item after Edit on Gallery Form

(0) Share

Report

Posted on by golfnutt82

1,362

Hello Power Apps Professionals,
This board has been extremely helpful in helping me solve the issues I bumped up against!
My news situation is that I have a Power App Gallery Form that has some filtering, and I can choose a record to edit but that is where it stops. I need to be able to not only edit the record but save it.
It's hard to believe this is that complicated to solve.
Any direction is appreciated.
Putting a button on the item as shown, which puts buttons on all subsequent items below is what I am looking for but I cant figure out the logic that would go in the OnSelect property for the Save Button.

For some reason the "New Role Owner" doesnt act like a person/group field and recognize a person.
Also, for the Items property I have some logic in there for the search and filtering.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Pstork1 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Lets try to handle the problems one at a time. First for saving. The OnSelect of the button would be a Patch() statement something like this. In the record that is the third parameter you'll need to supply the fieldnames: values for each field you want to save. You also must include values for any required fields, like Title

patch(datasourcename, thisitem, {Title: thisitem.Title, otherfield: otherfieldvalue, ...})

For the other problem can you explain what kind of SharePoint column the roleowner is?
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi and thank you for responding.
The only editable field is the New Role Owner field, which is a PersonGroup field where I can enter in the last name of the user, and it shows a list of users.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Person/Group fields need to be patched in a particular record format. Here's a post that shows the format required for patching a person/group field.

PATCH A SharePoint Person Column In Power Apps - Matthew Devaney

Whether the other fields are represented in the Gallery or not. A Patch must always include values for all the required fields. By default this would just be the title field. If any other fields in SharePoint have been marked as required they will need to be included in the Patch.
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

Excellent! Thanks for your assistance