News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Trim text before submi...

Power Apps - Building Power Apps

Answered

Trim text before submit form

Like (0) Share

Report

Report

Posted on 30 Jun 2020 09:08:54 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:

General Questions

All responses Img

All responses (10)

Answers Img

Answers (1)

JAWL 391 on 08 Mar 2022 at 00:58:38

Like (0)

Report

Re: Trim text before submit form

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.
timl 34,941 Super User 2025 Season 1 on 07 Mar 2022 at 10:58:53

Like (1)

Report
Re: Trim text before submit form

@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, " ", "")
JAWL 391 on 07 Mar 2022 at 09:40:09

Like (0)

Report

Re: Trim text before submit form

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?
sbgoh 284 on 30 Jun 2020 at 10:02:59

Like (0)

Report

Re: Trim text before submit form

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

timl 34,941 Super User 2025 Season 1 on 30 Jun 2020 at 10:01:42

Like (1)

Report

Re: Trim text before submit form

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.
eka24 20,921 on 30 Jun 2020 at 09:56:13

Like (0)

Report

Re: Trim text before submit form

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.
sbgoh 284 on 30 Jun 2020 at 09:52:25

Like (0)

Report

Re: Trim text before submit form

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 ".
eka24 20,921 on 30 Jun 2020 at 09:47:31

Like (0)

Report

Re: Trim text before submit form

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.
sbgoh 284 on 30 Jun 2020 at 09:39:56

Like (0)

Report

Re: Trim text before submit form

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!
eka24 20,921 on 30 Jun 2020 at 09:20:45

Like (0)

Report

Re: Trim text before submit form

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.