Answered

update selected gallery data in PowerApps using patch

(0) Share

Report

Posted on by Gizachew

I have Gallery data and I want to update Gallery data in forms. I use Lookup to select a specific record and update corresponding columns. However, it's not working with this code. I check questions in this forum but it's not working.

Patch('My sharepoint List', Lookup('Employee name'=BrowseGallery1.Selected.'Employee Name'),
{Wage: Value(Value(Datacardvaluework.Value) * Piecerate.Selected.'Piece Rate')},
{'E. ID': Dropdown2_1.Selected.'Employee ID'},
{'Employee Name': ComboboxCanvas1.Selected.Value},
{'Cost Category':DataCardValue3.Text},
);

I tried updateIf its not working too.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Geeks_D 1,169 on at

Like (0)

Report
Copy link

Link copied!

Hello
The error occurs cos PowerApps is confused with the Lookup Values, might sound funny but its been around for awhile
made a post recently fixing it
https://medium.com/@olumideojoniyi/updating-multiple-records-in-a-gallery-or-collection-with-unique-values-90da5a086878
Revert if issue is not solved

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Gizachew

The issue with your Patch function is that the Lookup function is not being used correctly. The Lookup function should be used to find the record in the SharePoint list that matches the selected employee name, and then the Patch function should be used to update the corresponding columns.

Patch( 'My sharepoint List',
Lookup(
'My sharepoint List',
'Employee name' = BrowseGallery1.Selected.'Employee Name'
),
{
Wage: Value(Value(Datacardvaluework.Value) * Piecerate.Selected.'Piece Rate'),

'E. ID': Dropdown2_1.Selected.'Employee ID',

'Employee Name': ComboboxCanvas1.Selected.Value,

'Cost Category': DataCardValue3.Text
}
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Gizachew 62 on at

Like (0)

Report
Copy link

Link copied!
I rewrite the lookup code correctly like below but it's not working.
Patch( 'My sharepoint List',
Lookup(
'My sharepoint List',
'Employee name' = BrowseGallery1.Selected.'Employee Name'
),
{
Wage: Value(Value(Datacardvaluework.Value) * Piecerate.Selected.'Piece Rate'),

'E. ID': Dropdown2_1.Selected.'Employee ID',

'Employee Name': ComboboxCanvas1.Selected.Value,

'Cost Category': DataCardValue3.Text
}
)

Was this reply helpful? Yes No
Verified answer

Gizachew 62 on at

Like (0)

Report
Copy link

Link copied!
Patch( 'My sharepoint List',
Lookup(
'My sharepoint List',
ID = BrowseGallery1.Selected.ID
),
{
Wage: Value(Value(Datacardvaluework.Value) * Piecerate.Selected.'Piece Rate'),

'E. ID': Dropdown2_1.Selected.'Employee ID',
}
)
I changed to column ID in lookup so that I can be able to update selected field.

Was this reply helpful? Yes No