Power Platform Community Forum Thread Details

How are Business Rules implemented in Dataverse ?

eg if I have a Business Rule which says If <FieldA> = "A Value" Then .......

How Is <FieldA> = "A Value" implemented if <FieldA> is a Lookup Field.

Lookup Fields are implemented as /<EntityName>(<GUID>) so presumes that the code goes off to <EntityName> and finds <GUID> in the Table (Entity). So the code looks for the <GUID> rather than the actual Value "A Value".

As we all know GUIDs are unique. So In Environment A the GUID would be 1234-12345678-1234 but in Environment "B the GUID could be 9876-98765432-9876 so how does that comparison in the Business Rule work as the GUID has different values in different environments ? I want the Business Rule to compare the values rather than the GUIDs.

Regards

Nigel

Categories:

Microsoft Dataverse with Power Apps

Hi @NigelP

The following link explains in detail how the business rules work according to the documentation.

Create a business rule in Microsoft Dataverse - Power Apps | Microsoft Learn

Now, getting into practice, what you are asking is normally not written and that is that if you work with lookup, they must have the same GUID in all environments for it to work. Because the rule will look for the GUID not the name.

But that has a solution, normally when you do that it is because you have master or configuration tables, what you must do is migrate those records from your DEV environment to TEST and PRO using tools for this such as: Data Migration Tool, or in the XRM ToolBox Using Data Transporter

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution