cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Continued Contributor
Continued Contributor

[?] Model based app - Mapping from SharePoint fails for Person or Group and Choice fields

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 ?

 

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: [?] Model based app - Mapping from SharePoint fails for Person or Group and Choice fields

SharePoint People field is record based, which is known as lookup type.

And the lookup type defined under Common Data Service and the SharePoint list is different.

This should be considered as a current limitation when it comes to Entity mapping.

 

Please consider submit it as an idea (or user voice), to suggest the Model based App to fully support the SharePoint field mapping.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Power Apps
Power Apps

Re: [?] Model based app - Mapping from SharePoint fails for Person or Group and Choice fields

Adding @AngeloMollame from the Data integration team.

Thanks,
Clay.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,581)