Announcements
Hi
I have a list in my sharepoint called Test with a column called Num1
Id' like to patch a text input ( textinput1) to Num1 with the onselect of a button, could someone tell me what syntax should be
Thanks in advance
@jsmith87
Please try this
Patch( Test, // SharePoint list name Defaults(Test), // New record { Num1: TextInput1.Text } // Column to update with the value from TextInput1 )
Let me know if this works,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
no that doesn't seem to work
Do you get any error message? You will have to put that code to OnSelect Property of button. I have done the test on my end and it works.
Hi, doesn't seem to want to work, am i doing something wrong?
@jsmith87 The x mark on button, can you please share the error message ?
it says "invalid argument type (Boolean). expecting a record value instead
The formula in the image isn’t quite correct, the Default(Test needs a closing bracket. So you probably want something like:
Patch(Test, Defaults(Test), {Num:TextInput1.Text}).
That will only work for creating a new record if that’s the only mandatory field that needs a value. If there are others in your SharePoint list, ie Title, that’ll need to be populated in that Patch too
Please correct your formula , you have to close the brackets after defaults.
Patch( Test, Defaults(Test), { Num1: TextInput1.Text } ); Reset(TextInput1)
Also, check if the column name in your sharepoint is Num1 and as @cdwhite informed if there are other fields like title you need to add those as well.
Hi @jsmith87 ,
You mentioned "expects a record value instead"
What is the datatype of your column "Num1" ?
Pretty sure its not Single Line of Text. Is it lookup?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
