Virtual Table Column LookUp conversion for Model Driven App

(0) Share

Report

Posted on by PaddyWann

101

Hi,

I have a virtual table pulling from a SQL table with a "status" column with integers as a lookup value to another lookup table.

1= started

2= in process

3=pending, etc.

In the Canvas, app I would simply create a lookup function, and if the table was standard, I would make a lookup column. However, I am required to keep the SQL table due to other integrations. I would like to use a model driven app for the filtering and sorting ability. The problem is that the user just sees integers and not the lookup value in the table. I would like to see if it was possible to

a) show the lookup value

b) if the table is editable, could I filter the lookup table to the status item values in a dropdown for the user to select.

Categories:

Microsoft Dataverse with Power Apps

Capture.PNG

I have the same question (0)

All responses (5)

Answers (1)

cchannon 4,702 Moderator on at

Like (2)

Report

You can simulate a lookup by using a PCF, both on the form as a normal PCF and in views using the Editable Grid Control (Customize the editable grid control - Power Apps | Microsoft Learn)

Was this reply helpful? Yes No
Diana Birkelbach 3,072 Most Valuable Professional on at

Like (1)

Report

Hi @PaddyWann ,

I totally agree with @cchannon . Just in case it helps, I have here an example or Power Apps Grid customizer control for a dropdown. In my case I use it for showing colors.. in your case, you would need to change the options: https://github.com/brasov2de/GridCustomizerControl/tree/main/CellRenderer

Was this reply helpful? Yes No
PaddyWann 101 on at

Like (0)

Report

Thanks @DianaBirkelbach ,
I was able to turn a column text to green just to test. I had to modify eslint file a good bit, but I think I'm getting the hang of it.

The grid wouldn't sort or filter based on the text right?

Was this reply helpful? Yes No
Diana Birkelbach 3,072 Most Valuable Professional on at

Like (1)

Report

Hi @PaddyWann ,
That's indeed an issue: the sorting and filtering will be based on your data (so integer value), not on your rendered text.
To have also the filter/search based on the text, you would need something on the server-side. That could be a PlugIn on RetrieveMultiple message, or a (PowerFx) Formula Column. But I don't know if that is possible on Virtual Tables.

Was this reply helpful? Yes No
Verified answer

cchannon 4,702 Moderator on at

Like (1)

Report

It is possible with virtual tables, but only if you write your own Custom Virtual Table Provider.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/custom-ve-data-providers

Was this reply helpful? Yes No