Filtering data across tables

(1) Share

Report

Posted on by JürgenD

166

Hello everyone,

i have two tables that i want to filter:

In table1 i put a filter like this:

Items-Property: Filter(BVW_Einreicher;'Office365-Benutzer'.MyProfile().Mail='E-Mailadresse')

Table1 contains a column called "Key", so i get a result like this:

Key

149

228

238

240

and so on

In table2 i would like to see all entries, where table2.ID matches one of the keys found in table 1, such like this:

Filter(BVW_Vorschlag;ID in Table1.Key)
 
Can you help me how to write the command for this table?
 
Thanks in advance!
Jürgen

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

AdnanDev 30 on at

Like
a
(2)

Report
Copy link

Link copied!

You can do something like that.

Filter Table1 and Get Keys:

ClearCollect(FilteredKeys, Distinct(Filter(BVW_Einreicher; 'Office365-Benutzer'.MyProfile().Mail = 'E-Mailadresse'), Key))

Filter Table2 Based on Keys:

Filter(BVW_Vorschlag; ID in FilteredKeys.Result)

Was this reply helpful? Yes No
Verified answer

AmínAA 1,228 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Greetings JürgenD!

Well, first off, if you have said filter in a gallery (I'm assuming you're not using modern controls since they're not yet fit for production). And that returns you whatever data that includes your 'Key' column, then you would want to make the second filter using the selected values from the gallery. Now there are a lot of ways to do this, but the faster one without setting any variables (Which is not the most recommended method as far as I'm concerned), would be something like this:

Items property of SecondGallery (Assuming the first gallery is called First_Gallery)

Filter(BVW_Vorschlag; ID = First_Gallery.Selected.'NAME OF YOUR COLUMN')

This way, when you select whatever entry on the first gallery (Pointing to the first table), the second one would be filtered by the selected column value which should correspond to the ID in the second gallery (Pointing to the second table).

Now, that is how it would work if you are looking to filter with a single ID. If you wanted to do it using various IDs, it would be a little bit more complex. However I'd like to know if this does indeed solve your problem. If so, feel free to mark this reply as an answer, otherwise feel free to reply as well for further help and/or clarification!

Was this reply helpful? Yes No
JürgenD 166 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi AminAA,

thanks for your detailed answer.

In fact i work with multiple IDs. But not in the way to select them but to look for all existing IDs in the table.

AdnanDev already answered this.

Your suggestion for a single id is nevertheless helpful for me. Always learning a little bit more...

Kind regards

Jürgen

Was this reply helpful? Yes No