Answered

Edit a galley selected item

(0) Share

Report

Posted on by CU06111240-0

Help!!! I am trying to use the patch formula to edit a record. This is the formula I tried using. My record is gallery 2. What am I doing wrong?

Patch('Conditioning Tool',Gallery2,{'PO number':DataCardValue11.Text,'Item number':DataCardValue4.Text,'Case quantity':DataCardValue20.text,'Dry matter %':DataCardValue7.Text,'Average Shore value'.text:DataCardKey6.Text});
Refresh('Conditioning Tool');
Navigate(Gallery2, ScreenTransition.None)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Ramanachiappan 179 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @tchamb2,

Try this one,

Patch('Conditioning Tool', {ID:Gallery2.Selected.ID}, {'PO number':DataCardValue11.Text, 'Item number':DataCardValue4.Text, 'Case quantity':DataCardValue20.text, 'Dry matter %':DataCardValue7.Text, 'Average Shore value':DataCardKey6.Text } ); Refresh('Conditioning Tool');

Best regards,
Ramanachiappan M

If my response was helpful, please select "Accept as solution" to close the item. Your thumbs up would be highly appreciated if you found it useful. Thank you!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @tchamb2 ,

Patch( 'Conditioning Tool', Gallery2.Selected, { 'PO number': DataCardValue11.Text, 'Item number': DataCardValue4.Text, 'Case quantity': DataCardValue20.Text, 'Dry matter %': DataCardValue7.Text, 'Average Shore value': DataCardKey6.Text } ); Refresh('Conditioning Tool');

You need Gallery2.Selected - also you cannot Navigate to a gallery - it needs to be to a screen.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CU06111240-0 83 on at

Like (0)

Report
Copy link

Link copied!

I am still receiving an error message. I do not know why?

Was this reply helpful? Yes No
CU06111240-0 83 on at

Like (0)

Report
Copy link

Link copied!

I am still receiving an error message. I can not figure out, why.

Was this reply helpful? Yes No
timl 36,634 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @tchamb2

Power Apps is case sensitive so this error may be due to you referring to the Text property of DataCardValue20 with a lower case 't'. I'd suggest making sure that you spell Text with a capital T - hopefully that might help.

DataCardValue20.Text

Was this reply helpful? Yes No
Ramanachiappan 179 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @tchamb2 - @timl is correct,

Try This one,
Patch('Conditioning Tool', {ID:Gallery2.Selected.ID}, {'PO number':DataCardValue11.Text, 'Item number':DataCardValue4.Text, 'Case quantity':DataCardValue20.Text, 'Dry matter %':DataCardValue7.Text, 'Average Shore value':DataCardKey6.Text } ); Refresh('Conditioning Tool');

Best regards,
Ramanachiappan M

If my response was helpful, please select "Accept as solution" to close the item. Your thumbs up would be highly appreciated if you found it useful. Thank you!

Was this reply helpful? Yes No
CU06111240-0 83 on at

Like (0)

Report
Copy link

Link copied!

Thanks. Now although the formula works it is not updating the information if I make change.

Patch(
'Conditioning Tool',
Gallery2.Selected,
{
'PO number': DataCardValue11.Text,
'Item number': DataCardValue4.Text,
'Case quantity': DataCardValue20.Text,
'Dry matter %': DataCardValue7.Text,
'Average Shore value': DataCardKey6.Text
}
);
Refresh('Conditioning Tool');Navigate(Gallery2,ScreenTransition.None)

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@tchamb2 ,

You did not state your data source, but if SharePoint, try this

Patch( 'Conditioning Tool', { ID: Gallery2.Selected.ID, 'PO number': DataCardValue11.Text, 'Item number': DataCardValue4.Text, 'Case quantity': DataCardValue20.Text, 'Dry matter %': DataCardValue7.Text, 'Average Shore value': DataCardKey6.Text } ); Refresh('Conditioning Tool'); Navigate(Gallery2,ScreenTransition.None)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No