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?

Report
All responses (
Answers (