Power Apps

Business rule with lookup

(0) Share

Report

Posted on by Tango

1,168

Hi,

Is it possible in a business rule o do a lookup?

Consider quote line table with a column that is a lookup to a separate product table that has unit price based on different quantities.

when quantity is entered on the line item table, want to go get the unit price based on quantity.

Would also like this to be instant

Thanks in advance

Todd

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

JonDoesFlow 1,304 on at

Like (0)

Report
Copy link

Link copied!

This might help

https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-Lookups-in-Model-Driven-App-Business-Rules/td-p/2285849

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tango

Business rules relate to only a single table. You will not be able to look at fields on a related table within a Business Rule.

Note, you can pull in values (depending on what you are trying to do) in PowerFX formula columns (https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste)

Challenge with PowerFX formulas is that they do not support currency directly and if pulling from a remote tables doesn't support (even with casting as Decimal), see below (I know these are different fields than what you are trying to do but you can see that I am relating a field in current table and a field from related table (through lookup column):

Another thing you could try is a calculated column. Example is you could do a calculated field that would be something like the following which works in my demo case:

Was this reply helpful? Yes No
Suggested answer

11manish 849 on at

Like (0)

Report
Copy link

Link copied!
No, you cannot perform a lookup in a Business Rule in Microsoft Dataverse / Dynamics 365.

Use:

JavaScript → instant result

Plugin → backend consistency

Was this reply helpful? Yes No