First of all, I need to say how disappointed I feel with Model-Driven Apps (MDA). I hadn’t used them before, and I told my boss that our current project would be built using MDA, because it has a lot of tools out of the box and should take less time compared to Canva app.
But now I’m completely stuck on a basic requirement. Users want to see a table/list of invoices and filter them using a dropdown with distinct values from the Countries column. For example, they want to filter invoices from France or Spain only.
The problem is, this doesn’t seem possible in the view—or maybe I’m missing something. Let’s say I have two tables: Invoices and Countries. Invoices has a lookup column pointing to Countries. I added that lookup column to a view, but it doesn’t show a dropdown of available values—it requires me to type the value manually.
At the moment, the only workaround I see is creating a Choice column, but as I see it will be problematic for users to use properly. Is there a more elegant or dynamic way to achieve this? How would you handle such a requirement to show a dropdown of distinct values which filters the data? Would you use a dashboard, form, a PCF control, or something else? I'm open to more advanced solutions as well.
Keep in mind I simplified the scenario, this project will be much more complex than just having list of invoices with some filters - but this is the starting point, users want to see list of invoices and be able to filter them with some dropdowns :D
