Skip to main content

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>

 

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