Using Form to Update SP List

[JaredB]

Hello All, 

I have a built a query app that queries information from a SP list, I have a button on page one that pulls the information from my Gallery and places those values into a form on the next page. What I need is when the changes are made on the Form the user can click update and it take those values and use them to update the record in the share point list. I have tried a few variations from different places in these forums but haven't found a solution that works for me.

Patch('IT Requirements Form List',LookUp('IT Requirements Form List', ID = "First_x002f_LastName" ),{Value:DataCardValue2})

Currently I was just trying to get the Name to change in the SP list so that I could then add everything else in but its telling me the = sign is incorrect. If i'm putting this in correctly I want it to patch the SP List, then Lookup the SP list, if the ID which is FirstNameLastName, then change that value to match the value of the name field in my form which is DataCardValue2.

Can anyone help me understand how to pass this Form information to update the record in the Sharepoitn list?

[Drrickryp · Accepted solution]

@JaredB 

Item property of form: LookUp(splist, ID=Gallery1.Selected.ID)

SubmitForm(yourformname) in a button outside the form. 

[JaredB]

@Drrickryp 

I knew it was going to be something simple like that, however the button is telling me that I need a title?

[Drrickryp]

@JaredB 

Go back to your SharePoint list and uncheck the required property for the Title column.  If you can't do that, then put a placeholder text in its Default property of the control inside the Title card and hide the card.

[JaredB]

@Drrickryp Perfect got that and now its working, I noticed though that its creating a new record in the share point list, is there a way to update an item already there, the reason why i'm asking is because share point only allow for so many entries so I don't want it to fill up with multiple entries for the same user each time, is it possible to update a line item instead of creating a new one? Thank you for all of your help!!

[Drrickryp]

@JaredB 

Of course, in the gallery where you can choose an item to edit, make sure EditForm(yourformname) is included in the OnSelect property of the ">" icon.  That will automatically put your form in Edit mode so that it does not create a new record.  Also all the controls will be filled in with the fields from the item selected in the gallery.

[JaredB]

@Drrickryp 

Not sure im following how to put this in, here is what iv got for the Gallery onselect property.

[JaredB]

@Drrickryp I think I got it, I put in in like this and it seems to be working as intended now.

Navigate(Screen2,ScreenTransition.Cover, {Variable1: Gallery1.AllItems, Variable2:EditForm(Form1)})

[Drrickryp]

In the button

EditForm(yourformnamehere); Navigate(Screen2, Cover,{Variable1:Gallery1.AllItems})