Hi
We have a PowerApp form that is built on a SharePoint list
We would like all the text the user enters into the form to be in CAPITALS
Anyone know if its possible to format the entries, either while typing, or when the form is saved into Capitals?
Thanks
Solved! Go to Solution.
This is an old closed post but OnChange
UpdateContext({varUpper: Upper(Self.Text)});
Reset(Self)
Default
varUpper
Not much to do about doing this while the user types it.
However, you can use the Upper function on the field to save it at submit time.
If you are using a form, then change the Update property of the datacard and put it in an Upper() function.
Ex. if you have a DataCard that has an update property of, say, DataCardValue1.Text then unlock the datacard and change the Update Property to Upper(DataCardValue1.Text)
I hope this is helpful for you.
Hi @pn1995 ,
Could you please share a bit more about your scenario?
Do you want to format the entries into Capitals within your Edit form or save entries as Capitals into your SP list?
If you want to format the entries into Capitals while typing within the Edit form, I afraid that there is no way to achieve your needs in PowerApps currently.
As an alternative solution, you could consider save entries as Capitals values into your SP list. I agree with @pn1995 's thought almost.
I have made a test on my side, please take a try with the following workaround:
Set the Update property of the Data card controls within your Edit form to following:
Upper(DataCardValue6.Text) /* <-- convert original value into Capitals using Upper() function */
Note: The DataCardValue6 represents the Text Input box controls within your Edit form.
More details about Upper function in PowerApps, please check the following article:
Best regards,
Let me know if the Upper function is what you're looking for, or if you have more questions.
I did this by having a hidden TextInput then used Upper in the hidden TextInput and using that value instead of what been typed in the visible TextInput.
So TextInput1 is visible for the user to type into, TextInput2 is hidden and has value of Upper(TextInput1.Text)
I don't know if this helps.
I was looking to do something similar and thought I'd simply add that it is possible, and actually quite simple.
You firstly need to look at the onChange event of the text box. The idea is to update a variable (I use UpdateContext to scope the data locally) such that it is updated:
UpdateContext({ textToUpperr: Upper(txtBox.Text) })
If you then set the Default setting on the textbox to hold this variable, the text box will then update its value to uppercase. Note that the onChange fires when focus is lost from the box (e.g. clicking or 'tabbing' away from the control).
@C-J I take it the Default and On-Change have this variable?
UpdateContext({ textToUpperr: Upper(txtBox.Text) })
Cheers
John.
Putting this in the "Format" property of the TextBox input should capitalize while the user is typing.
Upper(txtTextBox.Text)
not working
This is an old closed post but OnChange
UpdateContext({varUpper: Upper(Self.Text)});
Reset(Self)
Default
varUpper
User | Count |
---|---|
255 | |
112 | |
92 | |
48 | |
38 |