Model based app - Mapping from SharePoint
SharePoint list
column A is type: Person or Group
column b is type: Choice
CDS Entity Editor
In the new CDS Entity Editor there is no field type option for Person Name so I chose to use a Text field type thinking the name value would be returned and not the ID.
Power Query Editor - Mapping
column B, Choice type is not surfaced
Column A - Only the ID is surfaced, which is an int. The ID value fails to map to the CDS Text field.
Expected Outcome:
SharePoint Choice fields should map to CDS Option Set
SharePoint Person or Group fields should either map to CDS Text field or a CDS Person Name field which is not available in this version. Person Name is available in Canvas Based Apps ?
