Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
DDoord
Contributor
Contributor

Separator for multi-value fields of Sharepoint lists extracted with Qlik Office 365 Sharepoint Connector

Is it possible to change the separator for extracts of multi-value fields (data type 'choice') from Sharepoint lists, using the Qlik Web Connector?

With the Qlik Office 365 Sharepoint Connector, I'm reading a Sharepoint list using the 'ListItemsFromID' function. For multi-value fields, it separates the values with a comma. As the valueset contains text strings which also contain commas, it is complicated to separate the individual values. Hence it would be helpful if there is an option to change the separator, eg. from a comma to a pipe.

Labels (2)
0 Replies