cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blaic88
New Member

"Not in" operator

Hi guys,

 

I have a problem and don't know the right solution.

 

I have a gallery and a table.

There are 2 sharepoint lists. First one have many questions in there. And the second have Answers.

In the Answer list i save every answer for the question. 

 

I filter the gallery list for 4 parameters to get all records which was saved from user,level,company name, listNumber.

And get the records. But i need in the gallery list the opposite of records. I need to know which questions are responsed from the user, ...

 

I need such operator like "not in"?

 

Can somebody help me. Or have anybode an alternative theory to solve this?

1 ACCEPTED SOLUTION

Accepted Solutions

Maybe you can invert like this?

A filter filters based on true, false so how we create that answer isn't important.

 

Filter(QuestionTable;Not(Title in Filter(AnswerTable; var_company.Text exactin rlzf).Title)) ?

View solution in original post

5 REPLIES 5
Venxir
Resolver I
Resolver I

Hi,

 

I think your problem can be solved easily but i'm not understand the concept yet. COuld you clarify it with some screenshots and more explanation?

Capture.PNG

 On top is a filtered gallery.

Filter: if the company name is in the table then display all records in the gallery. But i will all records which have not the company name saved.

 

Gallery = Question list

Table = Answer list

 

I want list all Questions in Gallery which not saved in answerList(Table) or have for parameter company name no record

 

 

Maybe you can invert like this?

A filter filters based on true, false so how we create that answer isn't important.

 

Filter(QuestionTable;Not(Title in Filter(AnswerTable; var_company.Text exactin rlzf).Title)) ?

Hi,

 

The code working fine.

 

Thx for the Answer

Trilochana20
Regular Visitor

I have a similar query where I have 2 Sharepoint lists (SP1 and SP2) which has "Track name" as columns

I need to compare and get "Track name" from SP1 which are not in SP2 Track name column.

 

Please help.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,193)