lookup from a formula column

[Tango]

Hi,

Is it possible to do a "lookup" to a different table inside a formula column?

Consider a table with products in ti that have different unit price based on quantity size.

In quote table want to be able to get relevant unit price after checking the products table

Flows are too slow for this use case, need it to be like excel or access where changes made reflect and recalculate instantly 

Thanks in advance

Todd

[ivan_apps · Accepted solution]

Unfortunately, no - LookUp() isn't supported in formula columns. Here is the list of supported functions - https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#...

If you select a product (lookup) you can always display a Quick View form that will show details of that product, which could include different price points for different quantities. It would be more of a reference rather than an auto-selection doing it this way.

If you are comfortable using javascript, you can retrieve that data based on your selection using the Xrm.Api calls. It can be triggered on form load or field change and it's pretty instant.

Last suggestion is creating a PowerFx command button or PowerFx instant plugin. Each requires a trigger - such as button press or save form, but are instant and low-code.

[Tango]

Thanks @ivan_apps Could you expand a little more on the last option. What would a PowerFX instant plug in look like

[ivan_apps]

There is some setup involved to get it going, and it's still in preview so you'd want to be careful with it. Here is a doc explaining the install process - https://learn.microsoft.com/en-us/power-apps/maker/data-platform/low-code-plug-ins?tabs=automated

You can make an automated (event driven) or instant plugin (called by action). You define the triggers, then you basically write the PowerFx code you'd like. Say your event is 'onsave' and you registered an automated plugin - as soon as you save your form with the lookup populated, your plugin will fire and then it can look up the record, retrieve the needed info, and write it back to a field on your form. Once the save completes, you will have that value in your form instantly. C# plugins work the same way, but this low-code approach has benefits over the dev-heavy C# coding.