You’re offline. This is a read only version of the page.
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.
It is possible with virtual tables, but only if you write your own Custom Virtual Table Provider.
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.
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?
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
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)
#1
stampcoin
15
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
