Unanswered

Business rule fires on server but not on front-end form for certain users

(0) Share

Report

Posted on by Edbert

Hi all

Would super appreciate some help:

I have set up a custom entity called 'Ticket' and a business rule that turns on both the visibility and business requirement of a field ('PaymentAmount') if another field ('HasPayment') has a value of 'yes'. It also hides/un-requires the field if PaymentAmount is 'no'.

This works as expected on my system administrator account, but when I log in as someone who just has the Basic User privilege:

There is no sign of the rule working while editing the form, i.e. visibility/red asterisk of PaymentAmount do not change when changing HasPayment.
When I save the record, it does apply the requirement and will demand a value for PaymentAmount if 'HasPayment' is expected

Thus, I believe the rule is firing server side but not on the front end, which seems unusual.

Note the following:

The rule is entity scoped (so should run both server-side and front-end, I think)
The rule only refers to fields that are on the form
The form is shared with all users
I have given 'Basic User' role full access to the 'Ticket' entity, except for 'Assign'

Can anyone help me understand how I can get the BR to function as expected for all users?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

voinea 24 on at

Like (0)

Report
Copy link

Link copied!

Few items to check:
- if you setup the Environment to use a Security-group check to see if the user is member of that security group;
- in the 'Basic User' role check to see if the user has, at a minimum, user scope read privileges on the Process table (see capture.png);
- if 'HasPayment' is a Lookup/Calculate field related to another entity you need to grant user scope read privileges on that Entity

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Edbert, You've tick the boxes for investigation which is good:

BR is activated

BR is entity scope

User have access to the form(s) and table(s)

Fields/columns are on all the form(s)

To isolate the issue, does it work if you give the user having issue temporarily system admin role? If not, then not a security role/privilege issue. Do you have other BRs that run? Try turning them off and then see if it works as expected?

Hope this helps...

Was this reply helpful? Yes No
Edbert on at

Like (0)

Report
Copy link

Link copied!
Thanks to both of you for your help so far:

@EricRegnier
I have tried giving the user System Administrator security role and the form starts to work as expected. I cannot figure out which particular permission(s) in the Sys Admin role is causing it to work.
@voinea
There are no SGs enabled in my M365 portal at all - I'm on a blank dev environment.
Basic User has user scope read privileges on Process (it's identical to the one in your snip)
Neither field look outside of the 'Ticket' table. 'HasPayment' is a Yes/No and 'PaymentAmount' is a currency field.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Edbert, sorry for my delayed response, try to re-create the security role from the "basic role." The basic role has all the base privileges user require to use the system. See tip # 15 from: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring-Power-Platform-and/ba-p/850804

Hope this helps!

Was this reply helpful? Yes No