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.
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?