Unanswered

Why are special characters causing problems in my text input boxes?

(0) Share

Report

Posted on by MrMikeC

I have a text box that users use to enter text. Only three special characters are causing problems when later viewing the text in the app.

When an "&" is entered, it displays "&"
When a ":" is entered, it displays ":"
When either "{" or "}" are entered, the app displays "{"

This is what the user will input on the form.

This is what the reviewer will see (in the app) once the form is submitted.

Does anyone know if there is a fix for this so that that all special characters work as normal?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report

What control type and code are you using to display this for them?

Is it all within app, or sending to a splist first and then showing up here as a datasource pull?

If in SP, how does the data look there in SP.

There will be a couple ways to handle the display based on how it's being done etc

Was this reply helpful? Yes No
Verified answer

CharlesGN 29 on at

Like (0)

Report

I think you used muti lines of text for your column type right ?

If Yes, go to edit column, click on more options and uncheck "Use enchanced.... and hyperlinks" :

Hope it's resolved your problem.

Was this reply helpful? Yes No
MrMikeC 10 on at

Like (0)

Report

Good questions, I will admit I am very novice and took this App over from someone else who is no longer available.

This is all within the app. There is an 'edit' mode for and a 'display' mode.
Can you help me understand what you mean by "type and code". I can share the advanced card parameters for the editable text box, as well as the display portion.

All text is normal when exported to excel.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

IS there a button they press to switch over to display, or to save submit that text input. If so show its onselect. and show the text value of the display portion

Was this reply helpful? Yes No
MrMikeC 10 on at

Like (0)

Report

It is a data card, text entry.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

And the default text value of the display control? what does that read? (also image you showed doesn't show th epart we would need to see, need to see the code you are using to patch this back to excel)

Was this reply helpful? Yes No
MrMikeC 10 on at

Like (0)

Report

TheRobRush
Yes there is a 'submit' function to take it out of edit mode and a separate screen for 'viewing'.
If I understand correctly,..

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

yes we need to see the sebmit code of the button that saves everything. and the text property of the label that displays it later

Was this reply helpful? Yes No
MrMikeC 10 on at

Like (0)

Report

Thank you for your continued support TheRobRush.
There are two buttons, one which saves the forum for later, and one that submits the forum for approval. Both actions, all the record to be viewed, which is where I then see the issue.

This is the code for the "save for later" function.

Was this reply helpful? Yes No