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.

Highlighted
Responsive Resident
Responsive Resident

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,790)