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,589 Moderator on at

Like (1)

Report

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

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,589 Moderator on at

Like (0)

Report

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