Forum Discussion
Solved
Handling URL in SharePoint List
I have a SharePoint List and one of the columns is a multi-line text item usually containing a hyperlink to a Word or PDF document in a SharePoint Document Library on the same site. I've used the multi-line text item format for this column because the SharePoint URLs are often longer than 255 characters. However, there are a couple of problems with this method:
- When using the List in a browser, the link opens in the same tab and there is no option to select 'Open in New Tab' which I would prefer.
- When using the List in the TEAMS desktop app, the link opens the document but then there is no way of going Back, i.e. the hyperlink becomes a dead-end.
Does anybody have any ideas on how to improve this situation? For example, is it possible to force the hyperlink to always open in a new tab in a browser?
OliverScheurich I've seen this method used before, and the only potential problem is that if the FILTER function doesn't find a match, COUNTA will incorrectly return a value of 1, because neither FILTER nor UNIQUE can return an empty array.
kskyllingmark While COUNTIF and COUNTIFS will only accept a range object in the "range" parameter, it is possible to use an array in the "criteria" parameter to generate multiple iterations of COUNTIF for each criterion, then use SUM to return the total (Note: with COUNTIFS, this technique can only be used on one of the criteria parameters). Regarding your sample spreadsheet, you could use the following formula in cell B2 and copy it down:
=SUM(N(COUNTIFS($A$8:$A$23, A2, $B$8:$B$23, UNIQUE($B$8:$B$23))>0))This method returns TRUE if the result of each COUNTIFS is greater than 0 and FALSE if not. The N function converts the TRUE and FALSE values to 1's and 0's, then SUM returns the total unique count. This can also be made to "spill" the results for each Permit # in range A2:A5 by combining it with BYROW:
=LET(range2, B8:B23, BYROW(A2:A5, LAMBDA(r, SUM(N(COUNTIFS(A8:A23, r, range2, UNIQUE(range2))>0)))))
2 Replies
jcunnane Try using:
- Open list item form & Right (second) click on hyperlink in multiple lines of rich text column > select Open link in new tab:
- Use Ctrl + click option to open link in new tab. Press Ctrl button and then click on hyperlink
In Microsoft Teams, check if you can go back to list using history menu button. Reference: Introducing history menu in Microsoft Teams desktop
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
Many thanks for this. Both very useful tips but the history feature in TEAMS using hover is something that I hadn't worked out and it does the trick nicely.
