Hi

I am trying to query a list in a separate SharePoint 2013 site collection where the site collection URL is stored in a single line of text column in the current item (also SP 2013), this is because we are referencing multiple site collections using this list and the workflow needs to follow this principal.

I have also saved the link as a text string variable within the workflow just in case.

For context: I want to query a specific target list item (ID again is stored in the current item) and known column from the separate site collection and save content as a multi line variable, append additional data using a build string task then write the new string back to the target column using an update multiple Items task.

Simple, or so I thought. However I am getting a "Site URL contains multiple reference tags, Please manually replace any remaining tags:" popup, followed by a "Cannot access site at http://xxx" dialogue whether I use either the current list item or variable, so failing at the first hurdle as it were. I suspect that this is because I am using the "Enter URL" option and using a list item or workflow variable to populate the address.

Have I got this completely wrong or just a bit? any advice would be appreciated.