The field for a URL has to come from the primary data source. This might be a good one to add to the Ideas section1
2 of 2 people found this helpful
I managed to do this by creating a calculated field in the primary data source for the URL. You then must add said calculated field to the sheet that you're adding an action to.