lookup from a formula column

(0) Share

Report

Posted on by Tango

1,164

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ivan_apps 2,187 Moderator on at

Like (1)

Report

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#functions

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.

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No