cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YoshikaSuzuki
Microsoft
Microsoft

Number of digits check

There is a function to limit the number of characters in the field, but there is no function to check the number of digits.
We need to prompt the user to enter a specific number of digits depending on the situation, so we would like to add a function to check the number of digits.

In particular, we would like to check the number of digits on the other side according to the value of a specific field, such by a business rule, and display an error if the number of digits not matches.

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @YoshikaSuzuki ,

 

What do your users use to enter numbers? A canvas app or a Model Driven app? Can you provide more details?

What does ‘number of digits’ mean and why can't it be achieved by counting the number of characters? Can you provide some examples?

 

Best Regards,
Bof

YoshikaSuzuki
Microsoft
Microsoft

Hi, @v-bofeng-msft  

Thank you for response!

Our User use Model Driven app. We would like a function to automatically count the number of characters.

For example, the user must enter exactly 10 characters in the field. It is NG if it's 9 or 11 characters. 
Items that require a specific number of characters, such as membership numbers

 

It may be possible to implement it in Javascript, but it is inconvenient for the customer because it cannot be checked when importing from Excel.

Hi @YoshikaSuzuki ,

 

If users only use from to submit data, then this requirement can be implemented by JS.

 

if users also need to import data in bulk, maybe you can consider using flow:

 

  1. When a row is added or modified , then trigger the flow
  2. If the value do not meet the specific format then delete the row and sand a email notification.

 

Best Regards,

Bof

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,672)