Filter table based on another table

Like (0) Share

Report

Posted on 14 Mar 2024 11:11:32 by jda2005py

Hi all,

Have two tables, the first one already filtered based on another page record. The second table has more information and I want to filter based on the records from the first table.

I'm writing this:

Filter('Portfolio EOS Outputs','Project ID'in DataTable1)

How do I specify the column from the table 1 that I want to filter from? The above is current not working.

Categories:

General Questions

I have the same question (0)

All responses (5)

Answers (0)

jda2005py 21 on 14 Mar 2024 at 14:04:51

Like (0)

Report

Re: Filter table based on another table

Sorry, didn't quite get it.

Was this reply helpful? Yes No
v-mengmli-msft on 14 Mar 2024 at 13:31:59

Like (0)

Report

Re: Filter table based on another table

Hi @jda2005py ,

I didn't think of DataTable1 as the name of the control.

If your DataTable1 displays the first filtered table, copy the formula on the Items property of DataTable1 and replace "DataTable1" in the current formula.

Best regards,

Rimmon

Was this reply helpful? Yes No
jda2005py 21 on 14 Mar 2024 at 13:25:58

Like (0)

Report

Re: Filter table based on another table

When I add the DataTable1.'Project ID' it says the name isn't valid. And when I just write DataTable1. the options are:

Was this reply helpful? Yes No
Rahman1005 109 on 14 Mar 2024 at 12:12:38

Like (0)

Report

Re: Filter table based on another table

Hi,
Can you please refer below article examples are covered in different away.
https://www.matthewdevaney.com/power-apps-filter-functions-examples/

Was this reply helpful? Yes No
v-mengmli-msft on 14 Mar 2024 at 11:55:22

Like (0)

Report
Re: Filter table based on another table

Hi @jda2005py ,

Is there a column store project ID in DataTable1? If so, I assume that it also names "Project ID". Please try this.

Filter('Portfolio EOS Outputs','Project ID'in DataTable1.'Project ID')

Best regards,

Rimmon

Was this reply helpful? Yes No