Please re-route to correct area if needed.

Currently Dataverse with a Virtual Entity or Virtual table, with a gateway connection to SQL, does not support a choice column or optionset.

As having a dropdown with choices is quite crucial when creating a Powerapp solution for customers, this is quite an urgent improvement needed. A Model Driven app only works on Dataverse or Virtual table, so there is no way right now to do a dropdown.

(Work around with PCF component runs into the 255 single text character limit)

Please enable support for choice columns for virtual tables