display list item url using list lookup

  • 19 January 2020
  • 1 reply
  • 69 views

Badge +4

display list item url using list lookup

I want to display the PO from other list, basically the clients requested the approved PO item url once they picked the PO number the calculated value should show the URL to required PO.

I tried but it get the long url

<p>""https://domain-9e1f072d78a755.sharepoint.com/admin/FormsApp/NFLaunch.aspx?SPAppWebUrl=https://domain9e1f072d78a755.sharepoint.com/admin/FormsApp&amp;SPHostUrl=https://domain.sharepoint.com/admin&amp;remoteAppUrl=https://formso365.nintex.com&amp;ctype=0x0100B94239682A07C641840DCED1DC657287&amp;wtg=/NintexFormXml/2867b1269c1f54afeb792636f38c2188_ba8c4c08-8bc4-4055-ba11-03eaeda9389b/&amp;mode=2&List=ba8c4c08-8bc4-4055-ba11-03eaeda9389b&ID=10&Source=https://domain.sharepoint.com/admin/Lists/PurchaseOrder/AllItems.aspx?GroupString=%3B%23IT%2DInformation%20Technology%3B%23&IsGroupRender=TRUE&ContentTypeId=0x0100B94239682A07C641840DCED1DC657287""</p>

 


1 reply

Badge +7

Are you using a SP Lookup Field?


 


Anyway you could do a query list action, get the PO Number and the ID and then use a build string action to create your URL in the following format.... https://Tenant.sharepoint.com/site/sitename/lists/listname/DispForm.aspx?ID={ID}, PO Number


 


Then using a hyperlink SP Column you can then do an UPDATE LIST ITEM Action, and update it with the URL you just created in the Build String Action?

Reply