How can I filter a table based on the values in a column in another table?

[Anonymous]

Hi,

I want to filter a table based on values from another table. Both tables have a common column. When I try the following code it is showing an error "Cannot use Table values in this context!"

ClearCollect(
    MyAssignments,
    Filter(Table2,Table1.TaskID in Table2.TaskID)
    )

This is the table structure

Regards,

Aakash

[eka24]

You can go around it as follows:

Insert a combobox1 and put table1 in the Items of the combobox.

Then you can filter as follows:
Filter(Table2,TaskID=combobox1.Selected)

OR

Insert a combobox1 and put table1.TaskID in the Items of the combobox.

    Filter(Table2,TaskID=combobox1.Selected.TaskID)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

@eka24  Combobox or any other manual input won't work for me. I need users to see a filtered list of the tasks they created on a click of a button. Filtering is happening with the help of collections and a final collection (resultant table) is being created and displayed on the next screen.

TaskID column from Table1 (which also has many other columns with information) should filter Table 2 (main database).

The following will be the resultant table (stored as a collection) which users need to see (information from different tables are being matched and getting displayed in a gallery).

Regards,
Aakash

[eka24 · Accepted solution]

In that use:

  ClearCollect(MyAssignment,
      Filter(Tabel2,TaskID in Tabel1.TaskID))

You can then use the Collection MyAssignment

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

@eka24 it worked! Thanks mate!

Aakash