Filtering a Lookup Value from a Collection.

I have a gallery with a collection of data from the Students Dataverse table and adding a column from the Activities Dataverse table.

ClearCollect(lStudent_col,

With( { Items:

SortByColumns(

AddColumns( Students As S , AcummulatedPoints,

Sum(Filter(Class_Activities, FK_Attending_Student.Surname = S.Surname), Points)

),"AcummulatedPoints", SortOrder.Descending)} ,

ForAll(Sequence(CountRows(Items)),

Patch(Last(FirstN(Items,Value)),

{RowNumber:Value})));

See Image Attached.

I have added a Lookup Column to provide me with the State.

"State: " & LookUp(Students As S, ThisItem.Email_Link = C.Email_Link, C.State)

I need to filter off of all records in that State: Lookup Column with a value of "Inactive".

How do I append this filtering to the Gallery?

2 comments

skool.com/learn-power-apps

A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!

Leaderboard (30-day)

+21