cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thansson
Helper V
Helper V

Patch to Excel on sharepoint

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

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"})

 

View solution in original post

2 REPLIES 2
timl
Super User
Super User

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"})

 

Hi @timl 

 

Yes, thank you working perfect

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,761)