(DetailsList) Automatically detect SharePoint User & Choice datatypes and output display name

[scottdurow]

Currently, when a SharePoint data source is converted to a collection by using Filter, the automatic formatting of SharePoint columns is lost. The Details List should detect these column types and output the display name rather than the raw JSON value.

See:

• https://github.com/microsoft/powercat-creator-kit/issues/85
• https://github.com/microsoft/powercat-creator-kit/issues/111

[schneika]

@scottdurow Ahhh! Very good idea! I have tried ClearCollect-Collection-Variables with AddColumns but this doesnt work.

Your suggestion is fine, i must AddColumns the Columns-Values directly to the SharePoint Datasource (A Collection is not working for me) and have to restart the App because of a "Control not loading". After App Restart all Columns Working as expected!

Example: Items= SortByColumns(Filter(AddColumns(Datasource,"UserDisplayName", ensUser.DisplayName,"ManagerDisplayName", ensManager.DisplayName,"BusinessUnitValue", ensBusinessUnit.Value,"DivisionValue", ensDivision.Value,"StatusValue", ensStatus.Value,"State", ensState,"IDValue", ID,"JobRoleValue", ensJobRole.Value,"CountryValue", ensCountry.Value),StartsWith(Title, SearchBoxTestForm.SearchText)), "Title", If(varSortFilesAsc, Descending, Ascending))

[denise-msft]

Thank you for submitting your feature request and for your interest in improving our product. We’ve carefully reviewed your suggestion, but due to our current priorities and resource limitations, we are unable to implement this enhancement at this time.

Since there hasn’t been recent activity on this request, we’re closing the item for now. However, please know that we appreciate your input, and we’ll keep your idea in mind as we assess future development priorities.

If our capacity changes or if we revisit this area, your suggestion may be reconsidered. We value your feedback and hope you’ll continue to share your thoughts with us.