Unanswered

Patch function in a Gallery issue

(0) Share

Report

Posted on by LaylaMarhoum

Hello everyone.
Could you please help me in this issue, I would like to make updates in my Gallery and these modifications should be shown in my database (SharePoint list) also but is not the case.

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

hey @LaylaMarhoum

can u please copy paste you code here so we do not need to retype?

thanks in advance
LaylaMarhoum 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure:
Patch(
TPM_PLN,
ThisItem,
{
Activity1: DataCardValue1_1.Text,
Activity: activGal.Text,
Resource: ResourceGal.Text,
Interval: intervGal,
CyclesRecorded: CyclesRecoGal,
'Next activity by': NextactGal,
Pourcentage: PercentageGal,
Cavity: CavityGal,
Quantity: OrgQteGal,
'Cycles Number': nbrCyl
}
)
Now the code doesn't show me error but when I go to preview mode and try to save a modification that I did in my row, I receive the following error notification:
I deleted the empty columns in my list to not have any blank cells but it still occurs.
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

i guess you are recieving this error because u are missing the values here like the .Text in the first ones.

depending on your column you need different things here.

can u specify which columns you are using?

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
LaylaMarhoum 11 on at

Like
a
(0)

Report
Copy link

Link copied!

the type of the columns that you mention with the red flesh is number, so .Text is not needed, and it generates an error when I write for example CavityGal.Text, because the type of the CavityGal text input is a Number.
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

u need to use .value if its a number column

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
LaylaMarhoum 11 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you, but it shows me error in the formula if I add .Value or .Selected.value
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

the sharepoint column is a number column you said right? what kind of input control are u using in the app?

are you using classic or modern controls in your app? are the fields in a form or not?
LaylaMarhoum 11 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, the SharePoint column has a number type, the input control is a classic text input with a number type also (a percentage), these text input controls are copied from a form and pasted in the gallery (I hope you understand what I did).

you can see here my Tree view

And I also used this formula to set the value of Pourcentage Column inside of the Gallery