Help Patching List from Gallery

[Bman1991]

Hello,

I am having trouble patching a share point list from a gallery.  This is the formula I am trying to use Patch(OtherSpendCat,{Jan:InputJan})

OtherSpendCat is the SP List I want to patch

Jan is the coulmn Name in the list i want to patch

InputJan is a Text Input in a Gallery where users enter data.

Any help would be great.

[Anonymous]

Patch(OtherSpendCat, { Jan: inputJan.Text } )

[v-monli-msft]

Hi @Bman1991,

Like @Anonymous suggested, you should add ".Text" at the end of the TextInput control's name. But please notice the column type of Jan column. It need to be a text/number column type to make this work. If it's other column types, please tell the column type and we will suggest the syntax to use.

Also notice that you need to include all the required fields from SharePoint list while patching. 

Regards,

Mona

[Bman1991]

Thanks for the help its still not working. The SP list isn't being updated.  It looks like something is working then the data I enter is cleared out. 

My Defaulat for Input.Jan is Text(ThisItem.Jan,"[$-en-US]$#,###0.00")

OnChange is Patch(OtherSpendCat,{Jan: InputJan.Text})

[Bman1991]

Thanks for the help its still not working. The SP list isn't being updated.  It looks like something is working then the data I enter is cleared out. 

My Defaulat for Input.Jan is Text(ThisItem.Jan,"[$-en-US]$#,###0.00")

OnChange is Patch(OtherSpendCat,{Jan: InputJan.Text})