Displaying a shorter AbsoluteURI path from attachments

(1) Share

Report

Posted on by Albertax

111

Hi Team, I have a gallery where I show users the attachments of a SharePoint list.

My problem is I need to remove everything except for the attachement name.

My formula was going to be a Left/Mid to manipulate it:

LabelShortenedURL.Text =

Concatenate(
Left(ThisItem.URL, Find("/to/", ThisItem.Attachments.AbsoluteUri) + 4),
".../",
Mid(ThisItem.URL, FindLast("/", ThisItem.Attachments.AbsoluteUri) + 1, Len(ThisItem.Attachments.AbsoluteUri) - FindLast("/", ThisItem.Attachments.AbsoluteUri))
)

Desired outcome below: Any tips?

All responses (1)

Answers (1)

Verified answer

WarrenBelz 146,660 Most Valuable Professional on at

Like (0)

Report
Re: Displaying a shorter AbsoluteURI path from attachments

Hi @Albertax ,

If you just want the first attachment name, it would be

First(ThisItem.Attachments).Name

or if you wanted them all in a delimited list

Concat( ThisItem.Attachments, Name, "," )

Is this what you are trying to do ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps