Unanswered

Auto On change text input format

(0) Share

Report

Posted on by PowerApps11

521

Hello,
I would like my text input to change format like16x16x16 after input using form and backend SharePoint field is Single line of text
I have tried this on the text input default property but not working

Text((Parent.Default),"[$-en-US]####x##x##")

Thank you.
@v-jefferni

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni on at

Like (1)

Report
Hi @PowerApps11 ,

Could you please share more details about your scenario? What's the source data format? What format would you like to convert the text to?

Please refer to below doc to know more about the Text function:

Text function in Power Apps - Power Apps | Microsoft Docs

For your scenario, if you would like to use "x" in the result text, maybe you could try and convert the source data to a ordinary format then replace the symbols:

Substitute(Text((Parent.Default),"[$-en-US]####-##-##"),"-","x")

But it seems the source data is a date? Please clarify it.

Best regards,

Was this reply helpful? Yes No
PowerApps11 521 on at

Like (0)

Report

Hi @v-jefferni
No its not date field its Single line of text and all I need is when user input for example in the text box say like 161616 I want the text box to auto change like 16x16x16 basically I wanted to add and X like the example and it will not be more than six characters when user typed
thanks

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @PowerApps11 ,

The question is: will the input texts always be 6 digitals/numbers? I made a demo with inputting 6 numbers and for your reference:

Formula for Default of the Text Input:

Replace( Replace( TextInput1.Text, Len(TextInput1.Text) - 1, 1, "x" & Left( Right( TextInput1.Text, 2 ), 1 ) ), Len(TextInput1.Text) - 3, 1, "x" & Left( Right( TextInput1.Text, 4 ), 1 ) )

You can and replace the TextInput.Text with Parent.Default on your end.

Hope this helps.

Best regards,

Was this reply helpful? Yes No