cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Re: Filter a filter

@DRCICI_Dev --

Is it a yellow triangle warning message or a blue dot message? If it's the yellow triangle, then the formula won't work. If it's the blue dot, then it just means that delegation won't work -- which makes sense because in is only delegated for SQL Server and for Salesforce. Also, in case you didn't know: when a function isn't delegable, only the first 500 records in the data source will be calculated and such.

Reference: https://docs.microsoft.com/en-us/powerapps/delegation-list

 

As for the ! (Not) operator -- I used these docs.

Reference: https://docs.microsoft.com/en-us/powerapps/functions/operators

Reference: https://docs.microsoft.com/en-us/powerapps/functions/function-logicals

And I also took a beginner programming class in C++ this semester (I'm a student), so this boolean logic isn't that new to me.

 

tl;dr The Not operator only reverses a boolean value. i.e. Turns True to False, and turns False to True.

This bit of code, without the --

Filter( Participant,
    ( ID in Filter( 'Attended Event', 
        PrimaryID = eventGallery.Selected.PrimaryID
    ).ParticipantID )
)

returns the list of participants that attended an event. Note that if a certain participant has attended the event, the condition evaluates to true. If a certain participant has NOT attended the event, the condition evaluates to false

 

What we want is to negate the condition. i.e. If a certain participant has attended the event, condition has to evaluate to false. If a certain participant has NOT attended the event, condition has to evaluate to trueSo, I used the Not operator to get the inverse of the condition given above.

 

And don't worry about not finding the appropriate documentation. PA suffers from a severe lack of good documentation (many people have complained about it). If anything's not clear, then just ask in this community. I've seen more trivial problems.

nickduxfield
Level 8

Re: Filter a filter

Thats real good work!

I like the use of !NOT and the correct wording of 'in' to create joins.

 

Regarding the correct title. should it be something like:

"compare Tables against Tables"

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,248)