Forum Discussion
Set sharepoint datasource textbox value with button?
I have a screen with a form based on a Sharepoint list datasource. I have one column in my sharepoint list that is a text(string). Tho i do not want to have the user manually edit this specific ...
Hi Oskar Kuus,
The simplest way is to use a https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-variables#use-a-context-variable
- I created a basic list, and just kept the TITLE field.
- I added the form for that list's datasource onto the screen.
- In this example, I put my form in NEW mode. I'm assuming you're adding new records.
- I added a YES and a NO button.
- For both buttons, I'm using the same UpdateContext function in their OnSelect properties. See the screen below. UpdateContext sets the value of Context Variables, which are variables usable on the same screen only.
- In my case I created a Context Variable called "userAnswer."
- The Yes button sets it to "Yes" and the No button sets it to "No."
- Next, you will need to modify the field you want to work with. But because it's in the form, properties will be locked.
- Click on the field, then click on the Advanced tab in the right panel and select "Unlock to change properties."
- To make this work, you need to bind your text field's value to the Context Variable you created previously (the one being changed by the Yes and No buttons).
- You do this by setting the field's Default property to the variable. See below.
Now when you click each button, the text box's value will change. One other touch: you might want to change the text box's DisplayMode property to "Disabled" so users cannot enter values directly into it.
Hope this helps! Let me know how it works out!