Unanswered

Regex Field Validation not working in Entity Form

(0) Share

Report

Posted on by jandersen

Hello all,

I have set up an entity list with an entity form for editing CDS records. In the entity form metadata I have set up a regular expression for preventing numbers in street names. However, when I submit the form, the validation does not seem to work since it accepts "123" as street name. Have I missed a setting? My regex is ^[a-zA-Z]+$ , Field is require.

Thank you!

Categories:

Power Apps portals

I have the same question (0)

All responses (4)

Answers (0)

Sort by

justinburch Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @jandersen,
Have you made certain this is pointing to the right field? Your RegEx worked without issue for me.
Additionally, please make sure you have reset the cache. You can find some tips on working with the cache here: https://justinburch.com/cache-tips/

Was this reply helpful? Yes No
jandersen 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @justinburch , thanks for the hint. Unfortunately clearing the cache did not solve the issue. Regarding your question if the metadata is pointing to the right field: I think it is, at least edits to the description & labels are reflected in the Portal. Are there any other settings that may be necessary?

Was this reply helpful? Yes No
justinburch Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks for the clarification, @jandersen. That's definitely odd, if the label change and all is reflecting then you're definitely using the right one. I didn't have to do anything further for mine - I just made sure it was a text field and added the same RegEx, then as soon as I click "Submit" it shows my custom message once violated.
Are you able to try the same RegEx against a different field - maybe one with no other entity form metadata - to see if it works there? Maybe on a different entity form?

Was this reply helpful? Yes No
jandersen 22 on at

Like (0)

Report
Copy link

Link copied!

@justinburch, I set up a new form for the Contacts entity and used the same Regex validation for the job title field, and it works. Maybe there's something wrong with my custom entity but I can't find the cause. Since it's just a test environment I won't bother investigating further. Thanks for confirming that I didn't overlook anything :).

Was this reply helpful? Yes No