Answered

Patch Single Item From Gallery

(0) Share

Report

Posted on by wwmn

103

I am building an inventory tracker, and from my admins page I want to be able to update the status of a reservation. I have a gallery that shows all of my reservations, and within that gallery I have a comments input field, a status drop down, and an update button.

I've searched and found a couple solutions, but neither will work for me. I get the error:

"Network error when using the Patch function. The requested operation is invalid."

Since my button is within my gallery, I am using:

Patch('datasource',{ID:ThisItem.ID},{Comments:comments,Status:'status-dropdown'.SelectedText})

I have also tried:

Patch('DPI Mifi Request',{ID:Gallery.Selected.ID},{Comments:comments,Status:'status-dropdown'.SelectedText})

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wwmn ,

Try:

Patch('datasource',ThisItem,{Comments:comments,Status:'status-dropdown'.Selected.Value})
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Try the following:
Patch('datasource', LookUp('datasource', ID = ThisItem.ID), {**same as you have here**});
mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

We are synced up answering questions today it seems xD
Verified answer

wwmn 103 on at

Like
a
(0)

Report
Copy link

Link copied!
I figured it out. I had to use variables instead of the data directly from the fields, along with @BCBuizer ThisItem suggestion.

Patch('DPI Mifi Request', ThisItem, {Comments:varAdminComment,Status:varAdminStatus})
BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wwmn ,

Using variables is a way to go, but from a maintainability point of view direct references are preferred: when you open up the app in a year from now you will not remember how these variables work.

In case comments and 'status-dropdown' are both inside the gallery as well, the formula for the patch will look like:

Patch( 'DPI Mifi Request', ThisItem, { Comments:ThisItem.comments, Status:ThisItem.'status-dropdown'.Selected.Value } )