Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lrjeWff8BI7ZejR3Dh10b8
Power Apps - Microsoft Dataverse
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 5 Aug 2021 09:46:35 by

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:

 

  1. 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.
  2. 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:
  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 21 Aug 2021 at 21:08:14
    Re: Business rule fires on server but not on front-end form for certain users

    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!

  • Edbert Profile Picture
    on 09 Aug 2021 at 10:14:08
    Re: Business rule fires on server but not on front-end form for certain users

    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.

     

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 06 Aug 2021 at 01:55:42
    Re: Business rule fires on server but not on front-end form for certain users

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

    1. BR is activated
    2. BR is entity scope
    3. User have access to the form(s) and table(s)
    4. 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...

  • voinea Profile Picture
    24 on 05 Aug 2021 at 10:40:30
    Re: Business rule fires on server but not on front-end form for certain users

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 13

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started