cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 293 members 6,710 guests
Please welcome our newest community members: