Issues patching to a collection

(0) Share

Report

Posted on by JimJim

289

Hi Guys,

I have an app with the following code running when the app starts:

ClearCollect(colProducts, Defaults('Capex Requested Products'));

I have a gallery with a repeating table and I am attempting to patch a row to my collection using the following code:

Patch(colProducts, ThisItem, 
 {Title:dd_ProductFamily.Selected.Result,
 ProductLine:dd_ProductLine.Selected.Result, 
 ProductCategory:dd_ProductCat.Selected.Result, 
 ProductGroup:dd_ProductGroup.Selected.Result, 
 ProductType:dd_ItemNo.Selected.Result, 
 NewSupplier_x003f_:radio_NewSupplier.Selected.Value,
 NewSupplierName:txt_NewSupplierName.Text,
 Supplier:If(radio_NewSupplier.Selected.Value="Yes","",dd_SupplierName.Selected.Result),
 BOM:dd_BOM.Selected.Result,
 EnergyStrategy_x0028_LowEmission:radio_LowEmission.Selected.Value,
 UnitCost:Value(txt_UnitCost.Text),
 UnitQty:Value(txt_UnitQty.Text),
 LineCost:Value(txt_LineCost.Text) });

It is complaining about the LineCost column, the error is This type of argument 'LineCost' does not match the expected type Number. Found type Text

txt_LineCost is a text box which has a type of number. It is also of type number on my Sharepoint List

Categories:

General Questions

Connecting to Data

I have the same question (0)

All responses (4)

Answers (1)

C-Papa 1,836 on at

Like (1)

Report

Re: Issues patching to a collection

have you tried not converting it to a value?

LineCost: txt_LineCost.Text

Are you sure it is a number column in SharePoint? and are you sure that the text within txt_LineCost is a number only, e.g. there are no symbols "£" or text characters? if there are it will not be able to convert it to a number.

Was this reply helpful? Yes No
JimJim 289 on at

Like (0)

Report

Re: Issues patching to a collection

Thank you, I did try not converting it to a number, but this didn't work.
I am confident that there are no characters in the textbox that aren't numerical (It's a calculated field)

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like (1)

Report

Re: Issues patching to a collection

can you send a print screen of the column settings from SharePoint and the txt_LineCost.Text calculation. has this column been edited in SharePoint at any time? e.g. column type changed? if so it would be worth removing the data source in PowerApps and adding it again

Was this reply helpful? Yes No
Verified answer

JimJim 289 on at

Like (0)

Report

Re: Issues patching to a collection

Instead of using my existing collection, I tried it with a new collection and it is working. I really don't understand why this resolved my issue

Was this reply helpful? Yes No