Hey
I want to save a textbox value without having to setup a sharepoint list and form.
I am trying to create a Settings screen.
On my startpage of my app i have some text with the ONSELECT: Launch("HTTPS://WWW.GOOGLE.SE")
But now i want the user to be able to change this URL by typing in a new adress to a textbox on the setting screen. That url should be saved for all other users.
But how to save the value
Cant see how i should use a sharepoint list for this, just one value?!
Solved! Go to Solution.
Found a solution.
I simply put this on the form item field
LookUp(sharepointlistname; ID=1)
and on my startapge change the launch code to
Launch(urlStart)
(name of form textbox field = urlStart
So, the bottom line is, you need to save it somewhere!
Now, the question is this - are the users of this mobile/app users, or will they be using the browser to access your app?
If they are all going to be using the PowerApp App, then you can take advantage of the SaveData and LoadData functions to store your information locally and then load it when starting. This, however, does not work in the web browser, so, if you are dealing with that, then you will need to look to another list to store it.
I hope that is helpful for you.
My users are using both mobile and browser (computer).
So i have created a sharepoint list to store 1 row that i call Settings.
This row then have a column called URL1.
Now in my form on the setting screen i want to load the value of that specific row.
If i can tell powerapps to always load the row with ID xxxx then i can also let the user update and submit changes to that form i guess?
but how to load the form to a specific ID / row?
Found a solution.
I simply put this on the form item field
LookUp(sharepointlistname; ID=1)
and on my startapge change the launch code to
Launch(urlStart)
(name of form textbox field = urlStart
So first, yes, another list is what you ended up with.
Next, if you use that formula, then you are always going to get the value of record 1. I thought you wanted each user to have a unique setting.
If that is the case, then you might want to consider adding a column to the list that is a person column, or at least is a text column for the email address. Then do your lookup for the record that matches that user email address.
If you need more explanation on that, let me know.
Ah i see, no i dont want each user to have their own URL. So this solution that i have now seems to be exaclty what i needed.
Hi @Oskarkuus ,
Have you solved your problem?
If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.
Best regards,