Filter table on a record in another table

(0) Share

Report

Posted on by JB0007

308

Hi Power Apps community,

I Have 2 databases that I need to link with each other. Both contain an account number that I can link the data with each other. However, one of my databases is organized and the other is not. Which means that I don't know specifically were the account number is stored. It can be stored in Column 1 and after a few rows in Column 2.

I have tried on my side but no success:

Filter(Database 2, Database1.AccountNR in Database 2)

Any help will be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JB0007 ,

Do you mean that

1)in database2, some data is stored in Column 1 and some is stored in Column2?

2)in databased1, data is stored in AccountNR field?

3)do you want to filter database2 that items have the the data with AccountNR field?

If so, I suggest you filter based on these two fields.

Could you tell me these fields data type? I assume that these are all text type.

Try this formula:

Filter(Database 2, Column1 in Database1.AccountNR||Column2 in Database1.AccountNR)

Best regards,

Was this reply helpful? Yes No