I have a site with a list where one column is defined as lookup with multiple values.
Now I’m trying to query an item/column from this list from another site.
As the list and the workflow is not in the same site I’m using CAML query.
I would like to be able to select return type (Lookup Value as Text, Comma Delimited).
How can this be done in a CAML query?
Alternative: How can I format the result to plain text (without the list id and ;#) after the query-list?