Unanswered

Number of digits check

(8) Share

Report

Posted on by Yoshika Suzuki Microsoft Employee

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-bofeng-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Yoshika Suzuki Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
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:

When a row is added or modified , then trigger the flow

If the value do not meet the specific format then delete the row and sand a email notification.

Best Regards,

Bof

Was this reply helpful? Yes No