How to restrict the Maximum number of characters based on the Drop down choice selection

Like (0) Share

Report

Posted on 19 May 2022 12:55:15 by Jaleelford_123

Dear Team,

I have created a Sharepoint, in that we have field called IBAN. Based on the country the IBAN number will get changed For e.g IBAN number for Spain 20 characters, IBAN number for Germany 22 characters, IBAN number for Denmark 18 characters.

We have choice column DataCard as FNC. If we select FOG(Germany) in the IBAN column, the maximum characters should be 22, if we give more than 22 then the IBAN field should not allow or it should an error message. Screenshot for your better understanding. Pls help me with the condition.

Thanks,

Jaleel Ahmed

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... on 19 May 2022 at 14:55:06

Like (0)

Report
Re: How to restrict the Maximum number of characters based on the Drop down choice selection

Hey,
My first thoughts were to set maximum string length in Sharepoint column. That would though only work for the countries with longest IBANs. There is option to add a validation for each column in sharepoint, however I don't have much experience there.
Here's a PowerApp approach you can try. If u select the text input for IBAN, there is option MaxLength. You can change the Parent.Default for any other number. Here you have few options:
for the FNC dropdown data source add extra column with allowed character number and point that column here
If there are only possible max character numbers you can try using e.g
If( ThisItem.FNC ="FOG" || ThisItem.FNC ="FRA"||ThisItem.FNC ="POL",22, If( ThisItem.FNC ="DEN",18))
Best regards,
Matt

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on 20 May 2022 at 14:30:22

Like (0)

Report

Re: How to restrict the Maximum number of characters based on the Drop down choice selection

Hi,

(Edit: forgot to include the link, added it below) I wrote an IBAN validator component a while back that you can use for this - it uses Regex and the IBAN number-conversion system to check the IBAN and the country are valid - you could take the code from this and modify it for your own needs.

IBAN & SWIFT/BIC Validator - Power Platform Community (microsoft.com)

Cheers,

Sancho

Was this reply helpful? Yes No