web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Text input with number...

Power Apps

Answered

Text input with numbers only

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I would like to make my text input box only accept 6 digit numbers only. Additionally, I would also like to make it so that whichever 6 digit number that is entered is looked up in reference to the SharePoint list that is connected to my app. I am not sure how to go about that. After this number is looked up, a pop-up should occur letting the user know that the number they entered was found in the records.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

vaubeee 533 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi! I assume you are speaking about a canvas app. You could set the txt input properties as follows:
Format: Number
MaxLength: 6
Hint Text: "Input 6-digit number"
OnChange - due to lack of infos, just a basic logic 🙂 :
If(
Value(Self.Text) = *yourDataSourceColumn*.Value,
Notify("Number already used",NotificationType.Information),
Patch()
)

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I've made a test for your reference:

Set the text input control's Default property to:

"000000"

Set it's OnChange property to:

If( !IsMatch(Self.Text,"\d{6}"), Reset(Self);Notify("input box only accept 6 digit numbers only"), If( !IsBlank(DataSource,ColumnName=Self.Text)), Notify("number was found"), Notify("number not found") ) )

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation