Trim text before submit form

(0) Share

Report

Posted on by sbgoh

284

Hi,

Is it possible to trim the text that user input before submit form?

I tried with "Field.Text = trim(Field.Text)" and update context but it seems not working.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Trim(Field.Text) is ok but how did you use it with the update context.
Can you give more details
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

I used tried this 2 method:
1. Field.Text = trim(Field.Text); SubmitForm(FrmName)
2. UpdateContext(Field.Text: Trim(Field.Text); SubmitForm(FrmName)

Both ways does not help. Any advise? Thanks!

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Can you be more specific on what you want to do. What are you trimming and in what textbox?
Trim(Field.Text) is ok. Field should be a textbox name on your form not a column in the table
If you are not ok, give a screen shot.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

I have a textbox in a edit form named "txtField". I want to trim spaces in the text entered my user upon clicked "Submit" button.
E.g. if user entered " MAX ", I want to submit "MAX" instead of " MAX ".

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Then it should be Trim(txtField.Text)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

Hi @sbgoh

The way I would do this is to apply the Trim function on the update property of the card for your field.

In your case, you would set it to Trim(Field.Text).

Once you do this, your SubmitForm function should submit the record and trim the field.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

I see. It is the update property. Got it. I will try. Thanks a lot! 🙂

Was this reply helpful? Yes No
JAWL 393 on at

Like (0)

Report

Hi @timl I have tried using trim in the Update Property of DataCard but it does not work.

I tried Trim(Value(DataCardValueTO.Text) but Submit Form is failed with error:

Thus, what is the correct workaround to trim out the spaces in the DataCard?

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
@JAWL

If you want to remove all spaces from the input string, (eg - convert "12 12" to "1212"), you can do this with the Substitute function.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-replace-substitute

Substitute(DataCardValueTO.Text, " ", "")

Was this reply helpful? Yes No
JAWL 393 on at

Like (0)

Report

Hi @timl

Thanks, your tip works (removing spaces upon Submit Form). Nevertheless, is there a way to prevent user inputting space into the DataCardValue (Column type: Text)? I know I can set error notification to detect if user inputs space but I want to DISABLE user's ability to input Space.

Was this reply helpful? Yes No