Answered

Trouble with Patch Function Changing Status in Power Apps Form Connected to SharePoint

(0) Share

Report

Posted on by JOYCEJ

Hi everyone,

I'm currently developing an app using Power Apps, where I've set up a status filter to manage requests with statuses "New," "Pending," and "Completed." These requests are displayed in a gallery, and I can update their status using a form that patches changes back to a SharePoint list.

I'm able to change the status from "New" to either "Pending" or "Completed" without any issues. However, I encounter problems when I try to change a status from "Pending" to "Completed." Whenever I attempt this, I often receive an error: "An error occurred on the server." Interestingly, I also face similar issues when trying to change from "Completed" back to "Pending" or "New," and from "Pending" to "New."

Could anyone shed some light on why this error might be occurring only with certain status transitions? Any insights or solutions would be greatly appreciated!

Thank you!

PS. The code I am using is: for the form, onsuccess:

Patch(tracker,

lookup(tracker， ID= Gallery.selected.ID），

{ Vendor:{Value:vendorcombobox.selected.Value},

Rerquest_Status (Value:requeststatus.combo.Selected.Value} })

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

SebS 4,822 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@JOYCEJ

Is lookup(tracker， ID= Gallery.selected.ID） not throwing you an error ? it should be LookUp(tracker, ID = Gallery.Selected.ID) and Vendor:{Value:vendorcombobox.selected.Value} should be Vendor:{Value:vendorcombobox.Selected.Value}

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @JOYCEJ

It depends if the Rerquest_Status (is that a typo?) column in SP is a choice column or a text column.
Also, there's some things wrong with the patch e.g.
E.g. this line is wrong
Rerquest_Status (Value:requeststatus.combo.Selected.Value

It should be:
ColumnName: ControlName.Selected.Value

So something like:
Rerquest_Status: requeststatuscombo.Selected.Value

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @JOYCEJ,

The key to your issue maybe the place you write the Patch() function.

OnSuccess property maybe not the correct property you should set the Patch() function.

Not sure if your edit form has Edit as the Default Mode, however, I want to explain to you that Edit For will be revert to the default mode once it is submitted successfully.

So how you set the default value of the combobox decides if you could capture the selected value after submission.

Was this reply helpful? Yes No
JOYCEJ 32 on at

Like (0)

Report
Copy link

Link copied!

Hi Sebs5, the code was correct in my powerapps. When I type it here it was messy.

Was this reply helpful? Yes No
JOYCEJ 32 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I have solved the problem in a different way...

Was this reply helpful? Yes No
JOYCEJ 32 on at

Like (0)

Report
Copy link

Link copied!

Hi Everyone, thank you for your replies!
I solved the problem by deleting these two combo boxes I added to the form. Instead, I used the form data fields. And made sure the data fields are attached to the data card. So I don't need to use Patch() function and submit function at the same time.
I think when I use Patch() and Submitform function at the same time, it often throws me problems.

Was this reply helpful? Yes No