Answered

Filter Attachment Column based on Text String

(0) Share

Report

Posted on by Jay50

Hi All,

I have Attachment Column in SP which is storing multiple attachments with tagged name. I have attachments name coming properly into my SharePoint but now I want to display back attachments in 3 different columns. I can do that using First, last,..etc.( for example- First(ThisItem.Attachments).DisplayName

But, user may insert attachments in different order, and this will not work. So, I wanted to display values in each column based on Filter String. Can anyone Suggest me the Syntax? Not able to figure it out.

Something like filter attachments where attachment name startswith docments or Excel Inventory or Import Packaging Slip

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,415 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @Jay50 ,

An example

LookUp( ThisItem.Attachments, StartsWith( DisplayName, "Excel" ) ).DisplayName

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
Jay50 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thanks for your response,

I tried your code but not working. I have managed to get string in my column as per above screenshot.

I sued this code:- Text(Concat(ThisItem.Attachments,DisplayName,";"))

Now I want to find string that starts with ExceInventory to show in this column.

Can you please suggest how to do it ?

Was this reply helpful? Yes No
WarrenBelz 155,415 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Jay50 ,

Please see amended post

Was this reply helpful? Yes No
Jay50 58 on at

Like (0)

Report
Copy link

Link copied!

Perfect.

Thank you so much for your help @WarrenBelz . Marked this as Solution now.

Was this reply helpful? Yes No