Send data in Number column of SharePoint list using Patch Function from Canvas app

(0) Share

Report

Posted on by SR-02111122-0

Hello Everyone,

Using Patch function I am sending data into SharePoint list from my gallery below is the image of table that I created using gallery

Problem:

the issue that I am facing is that I am unable to send data into Number column of SharePoint list, this is the formula for quantity column

(

Patch('Line Items',ThisItem,{Quantity:TextInputCanvas4_2.value})

)

Price column formula

Patch('Line Items',ThisItem,{Price:TextInputCanvas4_3.Value})
 
but I am able to send the data for Vendor, Item & Description column using these formula's
Patch('Line Items',ThisItem,{Description:TextInputCanvas4_4.Value})
 
Please let me know if anyone know how to resolve.
Thanks for support

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SebS 4,746 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You need to wrap the text control in Valu() to make sure it will cast it as number

Patch('Line Items',ThisItem,{Quantity:Value(TextInputCanvas4_2.value)})

Hope that helps

Was this reply helpful? Yes No
SR-02111122-0 78 on at

Like (0)

Report
Copy link

Link copied!

Thanks that works. Can please let me know one more thing, In Price column I also want to include $ sign in my text input field.

Was this reply helpful? Yes No
Suggested answer

SebS 4,746 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If user for example enter $10 or you adding the $ you can do it that way

Patch(
'Line Items',
ThisItem,
{
Quantity: Value(Substitute(TextInputCanvas4_2.Text, "$", ""))
}
)

So before Patching and converting to number it will remove $

Was this reply helpful? Yes No