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

Nested Filter Multiple Tables

Hello, I have two tables, I would like to filter the result based on other table's column values. I tried using nested filter but that show error. Here's the code.

Filter(ArchcorpSpace_Table, ID in Filter(AssignSubzone_Table,  Date_Assignment = Text(Today())))

The error it show is: invalid schema, expected one column table


I know this error would come up because I need to tell which 'ID' of ArchcorpSpace_Table should match with which column of AssignSubZone_Table. But I don't know the correct syntax. 

My Table has the following structure.

-------------------------------------------

ArchcorpSpace_Table:
ID
Name_Space

ArchcorpSubZone_Table:

ID

Name_SubZone
Date_Assignment

ID_Space


The desired output I want is:

Filter the all Name_Space who has been assigned today in ArchcorpSubZone_Table

-------------------------------------------------------------------------------------------

 

 

Thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

I see two problems with your formula.  First, as the error says you need to get your second filter down to a single column to use in.  You also need to filter out the Time value from the Date_Assignment column or it will never match Today().  Try this modification.

Filter(ArchcorpSpace_Table, ID in ShowColumns(Filter('AssignSubzone_Table', Text(Date_Assignment,ShortDate) = Text(Today())), Date_Assignment))


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User III
Dual Super User III

I see two problems with your formula.  First, as the error says you need to get your second filter down to a single column to use in.  You also need to filter out the Time value from the Date_Assignment column or it will never match Today().  Try this modification.

Filter(ArchcorpSpace_Table, ID in ShowColumns(Filter('AssignSubzone_Table', Text(Date_Assignment,ShortDate) = Text(Today())), Date_Assignment))


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Anonymous
Not applicable

Thank you so much @Pstork1 . You have saved my day 🙂

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,954)