updating a number field from Gallary to Sharepoint list

(0) Share

Report

Posted on by Bream

Hi,

I have a sharepoint list called timesheet with different field types including text, date and number. I have also created a gallery to display the same information. I have built an configured in power apps, when a user makes a changes in a galarry, using the onchange function, to update the sharepoint list. i got it working for the text and date field but not number field. see below code:

Patch(timesheet, {ID: Gallery1.Selected.ID}, {'Purchase Order Number':ponumberfield.Text}) working

Patch(timesheet, {ID: Gallery1.Selected.ID}, {Date:Datefield.SelectedDate}) working

Patch(timesheet, {ID: Gallery1.Selected.ID}, {Hours:hoursfield.number}) not working.

In Sharepoint, the field type is number in power apps the text field type is also number. i think the problem is i don't have the right syntax where i use number. can someone help?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @Bream, I am not sure what is the hoursfield.number?

Try this:

Patch(timesheet, {ID: Gallery1.Selected.ID}, {Hours: Value(hoursfield.Text)})

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos