cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Nested Filter in Powerapps

Hi There,

 

I created a canvas application , where i want to filter something like below

 

Set(ActiveRelatedCase,Filter(EntityA, "test" in field1));

Set(ActiveRelatedReg,Filter(EntityB, "test" in field2));

Set(Final,Filter(ActiveRelatedReg,ActiveRelatedCase.fieldn in fieldp)); Note: Here fieldp is from EntityB, fieldn from EntityA

In the above line system throwing error , Invalid argument type, cannot use table value in this context.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Nested Filter in Powerapps

Hi @rtb360test1 ,

 

 

Can you share more details with your apps?

Is there any error shown in the formulas?

Have you ever tried to put these formulas on Button's OnSelect property to check if it works?

 

In my test,  the formula works well, it can collect all records that meet "Value in Column"condition to the collection.

Annotation 2019-09-26 093807.png

 

It would be better to figure out the issue if you can post more details.

Best regards,

Sik

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Nested Filter in Powerapps

Hi @rtb360test1 ,

 

PowerApps doesn't support to logic of "ColumnA in ColumnB" yet, it should be as "ValueA in ColumnA".

However we can use ForAll function to traverse ColumnA to judge if each items is in ColumnB.

Please modify your third formula as below, and check if your issue is fixed.

ForAll(ActiveRelatedCase,If(fieldn in ActiveRelatedReg.fieldp,Collect(myCollection,LookUp(ActiveRelatedReg,fieldp=fieldn))));Set(Final,myCollection)

Best regards,

Sik

Highlighted
Frequent Visitor

Re: Nested Filter in Powerapps

Thanks for the suggestion. These assignment am doing it on form onvisible . but am not getting the collection result on "items" of gallery. Any idea?

Highlighted
Community Support
Community Support

Re: Nested Filter in Powerapps

Hi @rtb360test1 ,

 

 

Can you share more details with your apps?

Is there any error shown in the formulas?

Have you ever tried to put these formulas on Button's OnSelect property to check if it works?

 

In my test,  the formula works well, it can collect all records that meet "Value in Column"condition to the collection.

Annotation 2019-09-26 093807.png

 

It would be better to figure out the issue if you can post more details.

Best regards,

Sik

View solution in original post

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 (8,973)