Unanswered

Having a set character in a text input

(0) Share

Report

Posted on by Community Power Pla...

Hi!

I want the user to add the date in a text input as YY/WW, and I therefor want a slash to be added automatically after the user has entered two values.

As now, my code looks like this in the text input's OnChange:

If( Len(Datuminput.Text) = 2, Datuminput.Text = Datuminput.Text&Char(47) )

But it isn't working as I hoped it would... does anyone have any suggestions?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Do you mean date format like 2023/week 15?

Could you please tell me that how you define two values in the Datuminput? Two characters? How you convert two characters into YY/WW?

Actually, in Power Apps, to convert date into YY, we used to use the "yy".

If you just want to add a year to the TextInput where inputs weeknumber, I think you should set the OnChange property of the Datuminput as below:

If(Len(Datuminput.Text) = 2,Set(DateFormat,Text(Today(),"yy")&Char(47)&Datuminput.Text))

Then you need to apply this variable to the Default property of the Datuminput:

DateFormat

What's more, to trigger the variable in the OnChange property, you need to click anywhere outside of the Datuminput, so that the variable will be triggered.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Well, I first defined DatumInput as a value and not a text, since I wanted the user to enter numbers. But I didn't get numbers to work with adding a character to the text, and therefor I changed the format to text.
I haven't yet decided how to collect the data from the user's input, but the plan is that it'll be a total of four characters in the input, the first two for the year, and the last two for the number of the week, and with a slash in between them so that it's clear for the user what they're entering in the textbox!
Did that make it more clear?
Best regards

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Do the end users input year value and week number value at the same time?

If so, please add a timer and set a variable as below:

Set the OnTimeStart property as:

Set(varDate,If(Len(TextInput2.Text)=2,TextInput2.Text&Char(47),TextInput2.Text))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes they will enter the values at the same time! It looks like this:
I tried adding a timer, but I don't really see what purpose it has in this case?
Best regards

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @Anonymous,

It will always refresh the variable in a duration without you trigger the OnChange property.

Before, you need to click anywhere outside of the Datuminput when Datuminput has input change within, but with the Timer, this variable is generated in a short time without triggering the OnChange property.

Was this reply helpful? Yes No