Patch to Excel on sharepoint

[Thansson]

Hi

I have to patch a text to a excelsheet on sharepoint, from an editform, but nothing happens, not even a failure:

The editform is connected to a sharepointlist, and the submit is working fine.

On the same time i have to patch this:

Patch(DyData;LookUp(DyData;ID=Label3.Text);{Status4:"WAIT"})

I have made a label with the gallery choosen ID   "Label3.text" on the editform

I try to lookup this ID, and then patch the column with the text "WAIT"

But the field is empty.

Regards

Tony

[timl · Accepted solution]

Hi @Thansson 

If label3 is on the editform, it may have reset itself after the OnSubmit which then causes the LookUp to fail. You could try storing the value in a variable.

UpdateContext({locID:Label3.Text});;
SubmitForm(YourEditForm)

In the OnSuccess property of your form:

Patch(DyData;LookUp(DyData;ID=locID);{Status4:"WAIT"})

[Thansson]

Hi @timl 

Yes, thank you working perfect