web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Limit Max Length on Si...

Power Apps

Unanswered

Limit Max Length on Single Text Field upon Condition

(0) Share

Report

Report

Posted on by shine_d

Hi,

I have formula below but it's not working as per stated condition if blank = Parent. Error, RQ- 11 max length and OP-13 max length.

Coalesce( Parent .Error,If(!IsBlank(DataCardValue14.Text)&&Len(StartsWith(DataCardValue14.Text, "OP"))<13 Or Len(StartsWith(DataCardValue14.Text, "OP"))>13,"The number of characters should be 13",Len(StartsWith(DataCardValue14.Text, "RQ"))<11 Or Len(StartsWith(DataCardValue14.Text, "RQ"))>11,"The number of characters should be 11"))

Thanks for the help!!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

sgtsnacks64 322 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @shine_d

Not entirely sure what your code is actually meant to be checking. But your issue might be around using Len() to check StartsWith(), which returns a boolean (true or false) value.

EndsWith and StartsWith functions - Power Platform | Microsoft Learn

Potentially changing Len(StartsWith()) to Find() might do what you're expecting, as Find() will return the position the string is found.

If you're trying to set the maximum length, you can do this on a text field, providing your code outputs the integer value to limit the field by.

Find function - Power Platform | Microsoft Learn

Coalesce( Parent.Error, If( !IsBlank(DataCardValue14.Text) && Find(DataCardValue14.Text, "OP")<13 Or Find(DataCardValue14.Text, "OP")>13, "The number of characters should be 13", Find(DataCardValue14.Text, "RQ")<11 Or Find(DataCardValue14.Text, "RQ")>11,"The number of characters should be 11"))

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@shine_d ,

I can't figure it out what is your objective, but seems that you don't use correctly the StartsWith() operator. This operator return a bool value (true, false) and not the DataCardValue.Text (used inside operator).

Here is my proposal:

Coalesce( Parent.Error, Switch( Left(DataCardValue14.Text,2), "OP", If( Len(DataCardValue14.Text<>13, "The number of characters should be 13"), "RQ" If( Len(DataCardValue14.Text<>11, "The number of characters should be 11"), "Your value need to start with OP / RQ" )

Was this reply helpful? Yes No

Join the conversation