web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter attachments by ...

Power Apps

Answered

Filter attachments by name within another filtered list.

(0) Share

Report

Report

Posted on by meinjoeskii

19

I have a Gallery which by default is filtered by TypeofOrder.

Gallery Default Filter:

SortByColumns(Filter(OrderID,TypeofOrder.Value = "GP"),"Created",SortOrder.Descending)

Now I created a button which OnSelect, I want it to further be filtered by Attachments's name. If attachment name contain "GP_" only show in Gallery else do not show. Please Help!

NOTE: The Attachment column might contain multiple jpeg per OrderID item.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @meinjoeskii ,

Please try this

ClearCollect(Test,0);ClearCollect(Test2,Filter(Ungroup(ForAll(Sequence(CountRows(OrderID)),Collect(Test,Last(Test).Value+1);{AAA:Last(FirstN(OrderID,Last(Test).Value)).Attachments,BBB:Last(FirstN(OrderID,Value)).ID}),"AAA"),!IsBlank(Id)));Set(var,1)

//LIST46 is my list name

Gallery items

If(var=1,SortByColumns(ForAll(Filter(Test2,"GP_" in DisplayName),LookUp(OrderID,ID=BBB,TypeofOrder.Value = "GP")),"Created",SortOrder.Descending) , SortByColumns(Filter(OrderID,TypeofOrder.Value = "GP"),"Created",SortOrder.Descending) )

Best Regards,

Wearsky

Join the conversation