Views:

Applies to Product - Microsoft Dataverse


What’s happening?
Unable to switch the Business Rule Condition to Advanced Mode in Dataverse.


Reason:
There is no advanced mode available in the business rule settings within Dataverse.


Resolution:

  1. Create a business rule in the account entity to validate user input for a field named "smsnumber" with the following steps:
  2. Create a 'single line of text' data type field named "smsnumber" in the account entity, mark it as business required, and add it to the account form.
  3. After saving and publishing the field, create a business rule in the account entity to validate the user input.
  4. Set properties for the condition by selecting the Condition component in the designer window. Add a condition that checks if "smsnumber" does not begin with a specified value.
  5. To add an additional clause (AND or OR), select New in the Properties tab to create a new rule.
  6. In the Logic column, specify whether to add the new rule as an AND or an OR.
  7. Add an action to the rule by dragging one of the action components from the Components tab.
  8. After saving and activating the business rule, test it by creating a new account record. If a number starting with 07 is entered in the SMS field, it should allow saving. If a number that doesn't start with 07 is entered, an error should occur, preventing saving.
  9. For further customization, refer to the documentation on creating business rules in Microsoft Dataverse.