ADF Expression Issue URGENT PROD ISSUE..please help!

Mike Kiser 1,536 Reputation points

I have the following ADF Expression (variables('UpdateURL'),item().employeeId,'?expand=EmploymentStatuses,','Contacts') and when I run the pipeline it shows the URL I have attached. When I click on it, it does not include the Contacts. Please assist! Thanks!! Mike Kiser


and it is 65975-screenshot-2021-02-09-115746.jpg

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
0 comments No comments
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 26,046 Reputation points

    Hello @Mike Kiser and thank you for bringing this issue to our attention. I have reproduced the partial hyperlink effect in the output of a Set Variable activity. I understand this has you worried, but unless I am mistaken, it is not nearly as bad as you think.

    This effect is most likely only confined to your ability to click the link. I do not expect it to actually affect the running of the web activity. Could you please confirm the activity results / data are as expected?

1 additional answer

Sort by: Most helpful
  1. Nasreen Akter 10,766 Reputation points

    Hi @Mike Kiser ,

    Would you please try to use %2C, instead of comma , at the end of EmploymentStatuses e.g.,


    Hope this helps! Thanks!

    If the above response is helpful, please * accept as answer* and up-vote it. Thanks!

    1 person found this answer helpful.