You’re offline. This is a read only version of the page.
1,151
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
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.
Thanks @ivan_apps Could you expand a little more on the last option. What would a PowerFX instant plug in look like
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.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
