Displaying a shorter AbsoluteURI path from attachments

Like (1) Share

Report

Posted on 8 Jul 2024 23:14:07 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?

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 150,392 Most Valuable Professional on 09 Jul 2024 at 01:16:40

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

Was this reply helpful? Yes No