Hi All,
I'm trying to create a new choice column in my Virtual Dataverse table. When creating other column types all I've needed to do is ensure there is an equivalent column in SQL and provide the 'external name' of that column.
However, the choice column type requires an additional property: 'External type name'. This is defined when setting up the global choices in the solution.
The documentation surrounding this is fairly brief, all it says is:
'If the column type you create is OptionSet: This property maps to the external name of the set of values in the external service for the choice . Typically, this can be an enum or name of a string value class. The External Type Name can be used when a fully qualified name is required. For example, as the Type Name with OData where parameters in a query need the fully qualified name, such as [Type Name].[Value].'
https://docs.microsoft.com/en-gb/power-apps/maker/data-platform/create-edit-virtual-entities#create-a-virtual-table
I'm just struggling to understand what this means in the context of SQL. SQL Server doesn't not have an enum data type for a column, and most other info I can find about setting up choices in SQL recommend creating an additional table with a key to the primary table - but I don't *think* that's what I should be doing in this instance. I don't even think I need to list the full set of values in SQL. I only need to store the reference to the value from Dataverse - but I don't know for certain.
Has anyone had any experience with this? I haven't been able to find any examples or blog posts from anyone.
Cheers in advance.
