Answered

Update single field in SharePoint List from PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I have a problem updating/patching a single field in my SharePoint List from the app I build in PowerApps.

I have a List that contain the Employee leave request quota and each time user request a leave, their quota should be reduced according to the number of days taken off. Each quota of each employee is listed in the List, so I do the calculation inside the PowerApps then Patch it to the List.

But nothing happened, the quota still remain the same, not reduced at all.

Patch('Data Pegawai',First(Filter('Data Pegawai',NamaPegawai = GalleryManagerApprover_2.Selected.Nama)),{KuotaCuti : totalCuti_5})

"KuotaCuti" is the field from the List that contain the quota, and "totalCuti_5" is the label in PowerApps that contain the calculation result of quota - days off

Is there something wrong from my formula ? Please help.

Thank you in advance.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Revise the formula to:
Patch('Data Pegawai',First(Filter('Data Pegawai',NamaPegawai = GalleryManagerApprover_2.Selected.Nama)),{KuotaCuti : totalCuti_5.Text})
If totalCuti_5.Text is a textbox or label
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Hei, thanks for the reply

I already do what you said there, but KuotaCuti field type is number, when I put .text on totalCuti_5 it will show an error.
Even I test with directly put random number then patch the field, KuotaCuti : 100 , nothing changed.
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If number, reivise it to:
Patch('Data Pegawai',First(Filter('Data Pegawai',NamaPegawai = GalleryManagerApprover_2.Selected.Nama)),{KuotaCuti : Value(totalCuti_5.Text)})
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 wow, it worked. Thank you so much 😄