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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (42,002)