Number of digits check

[YoshikaSuzuki]

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.

[v-bofeng-msft]

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]

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.

[v-bofeng-msft]

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