Power Platform Community Forum Thread Details

Hi everyone.

I am comparing two sharepoint lists. The first list has all my items on it, and the second list has certain items on it from list one. I am trying to show what is left on list one that is not on list two with a small caveat. The items repeat themselves on list one but they belong to different departments. Using the code below works, except it does not filter by department on the second list.

SortByColumns(
Filter(
TTDMasterGameList,
'D LOCATION' = Value(varUser.Department),
Not(JoinedTogether in TTDDefectsAll.GameName)
),
"SeqOrder",
Ascending,
"Modified",
Ascending
)

I am trying to figure out where to include 'D LOCATION' = Value(varUser.Department) on the NOT() portion of the code but nothing I try is working correctly.

Thanks for the guidance!

Chris

Categories:

Building Power Apps