Is it possible to build a hyperlink in InfoPath with my SharePoint data source?

  • 30 September 2016
  • 4 replies
  • 2 views

Badge +7

Hi all,

I have a workflow and a request review action in it. I want to have a hyperlink in it, this hyperlink should change with every workflow (ID).

Can I build a hyperlink in InfoPath, type in the link and put the ID (I can get the ID from a data source) at the right spot in the link?

Hope you understand what I mean.

Thanks!


4 replies

Badge +11

Hi ,

What is this hyperlink pointing to as it has to change with every workflow? Do you mean a new workflow on the same item or new workflow on new item? Sorry i did not understand if you want to publish hyperlink as item property or create one inside InfoPath because the later you can do if the ID is part of your data source.

Please provide screen shot or any other helpful detail.

Badge +7

Hi, Kapil Joshi‌,
The hyperlink is pointing to an item (this item is created in the workflow). The items are all created in the same SharePoint library so the only thing that changes in the hyperlink is the ID.
Hmm, maybe I could create a column type hyperlink and hide it in the display/edit/new view and then get it to InfoPath through data source connection.
I need 5 hyperlinks within my workflow though. I there an easier way? I tried to 'build' a hyperlink with typing in the link (in InfoPath) by clicking 'add hyperlink' and typing in the ID from data source before but this didn't work.

Badge +3

Hi Nina,

From what I understand your workflow creates and item in a list and you want to add a hyperlink to this item in a subsequent email. 

1) When you create the item in the list save the ID as a ListID variable

2) Use a build string to build the URL required with the ID created above and save to variable

3) Use the variable in the hyperlink in the mail

The trick here is InfoPath URL is normally a bit different to other urls but they all have one thing in common - ID of the item.  So you can construct your URL in point 2 above by going to the list in questions and opening an item in either Display mode or Edit mode.  Copy the URL, you will get something like:

https://yourserver/sitename/listname/Editform.aspx?ID=XXX... (there can be allsorts after the ...)

Basically copy the entire url and when you contruct the hyperlink replace the XXX above with the variable ID of the created item in step 1

so your URL will end up as https://yourserver/sitename/listname/Editform.aspx?ID={WorkflowVariable:listID}... if you named your variable listID...

Hope that helps

Badge +7

I found the solution here:

http://www.erinbglenn.com/Lists/Posts/Post.aspx?ID=71

concat('http://myserver/rm/Lists/FirstAidCPR/Item/displayifs.aspx?ID=',my:AssocNumMatchID)

This is the xPath expression to concatenate the list's edit form URL and the item ID so the proper item appears.

Reply