Unanswered

Comparing two SP lists with additional filter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone. I am trying to compare two sharepoint lists and am having mostly a successful time in doing so. I am struggling when trying to get the produced gallery in sequential order. Sequential order is a column on one of my lists.

Below is the formula.

Filter(TTDMasterGameList,field_0 = Value(varUser.Department),Not(JoinedTogether in TTDDefectsAll.GameName))

This is working great, just trying to sort by SeqOrder

The varUser is a variable that brings in the users Office info and I am filtering by their department number, which works great. I am trying to bring in the formula below with no luck:

SortByColumns(TTDMasterGameList,"SeqOrder",Ascending,"Modified",Ascending)

That formula works in other app but im sure my syntax is off.

Any help would be fantastic and much appreciated!

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Try:

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@AmDev
Thank you very much for the reply! Sorry its taken so long to get back to you! This is working except where TTDDefectsAll.GameName is not unique. It can exist in multiple departments. Is there a way to filter that with varUser.department as well?

Thanks again!!!
Chris

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

I'm just trying to understand your data structure and what you are trying to achieve, so please bear with me - can you confirm that list 1 is 'TTDMasterGameList' and list 2 is 'TTDDefectsAll'?

Am I right in saying you are trying to filter all items in List 1 which have the department ('field_0') matching your 'varUser.Department' and where the items are not listed in the GameName column of List 2?

Can you confirm the data type/origin of 'JoinedTogether'?

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AmDev .

Thank you again for your response!

So TTDMasterGameList(list1) has all of our items on it, and TTDDefectsAll (list2)has items on it from TTDMasterGameList that has been patched with user entered data. I am trying to show the remaining items from list1 that has not been entered on list 2. The code you gave me above worked perfectly until I saw I have multiple items with the same name in different departments. So department 1 has Game1, Game2, Game3 etc and it is showing it completed when the ser from department 5 has logged on because he also has Game1 etc in his department. If I could figure out the syntax to filter both lists 1 and 2 by the users department I THINK I would be in good shape.
JoinedTogether is a calculated column from my sharepoint list that combines gamename and gameid into one column. I was using that to try and make each instance in each department unique as gameid is a unique entity.

Thanks again!

Chris

Was this reply helpful? Yes No