Filter collection on collect

(1) Share

Report

Posted on by amyharkus86

726

Is there a way to filter a Collection before its displayed in the Gallery?

I have a collection based on a SharePoint list

Collect(CCRDCollection, CustomerCareRecord)

I then have a filter on this collection

Filter('CCRDCollection', MasterID = TI_MasterID.Text)

I would like to filter the collection before it get to eh Gallery to allow me to sent the collection in an email.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @amyharkus86,

If you set the gallery Items property to your filtered collection (below), does it display as required?
Filter('CCRDCollection', MasterID = TI_MasterID.Text)
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
amyharkus86 726 on at

Like
a
(1)

Report
Copy link

Link copied!

@KeithAtherton Yes the filter displays the items i wish to send in the email, I don't want to send the whole collection just the filtered based on the above filter.
galos 256 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried placing all your collect and filter code in the "App" -> "OnStart" property? Placing it here I believe runs the code when the app first loads.
amyharkus86 726 on at

Like
a
(1)

Report
Copy link

Link copied!

@KeithAtherton same result.

When emailing the collection using ConCat i get the whole collection not just the filtered collection i wish to send.
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. The email could be sent using the same filtered collection instead of the whole collection, so using the code you already have.

Or, if you need the collection filtered ahead of time (which will have the same effect as above), a new collection can be created from the filtered collection ahead of time, either by App.OnStart (as mentioned by @galos), or the screen OnVisible event, or by another action such as a button click.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

I would expect a Concat() of the filtered collection to concatenate only the filtered collection items.

Can you share the code which performs the Concat() and sends the email?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Verified answer

amyharkus86 726 on at

Like
a
(1)

Report
Copy link

Link copied!
@KeithAtherton All sorted emailing with this code in the email body.

Concat(CCRDCollection.AllItems," " & " Date: " & Date & " Start Time: " & StartTime & " Finish Time: " & FinishTime & " Lunch Break: " & LunchBreak & " Hours Worked: " & HoursWorked & " " )