Answered

Issue using Business Rule component with Show Message in Scope - Entity

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Problem: Trying to avoid duplicate entry, so when the user enters the data in the Portal Form, I need to validate the email id to ensure uniqueness

Solution: Set up a business rule with a condition + show message

Email = [Email]

THEN

Show the error message "Email is already present" against field Email

Was expecting an icon next to the Email field, while the business rule stops the data in the entity, the Form shows system error message "An unknown failure has occurred. Error ID # [ dc3e...]

Looking forward to some help !!!

Thanks

I am

Categories:

Power Apps portals

All responses (4)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

If you only want to avoid duplicate entry, defining a key should be more appropriate, it allows you to make sure your field is unique, and CDS won't allow duplicates of data to be entered within it.
Hope this helps.
Sik
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sik,

Thanks !!!

I am trying to display the error back to User in the Portal, and unable to do it with this approach, how to propagate the error you have shown, back to the user Apps Portal? Currently, when the user keys in the duplicate it is just accepting with success.

I also want to extend the server-side validation to other business validation.
Verified answer

Nicholas Hayduk 174 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately Power Apps Portals does not support Business Rules. You'll need to implement this type of validation using Portal-specific client-side JavaScript.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for confirmation