Compare the filtered data of a table with another table

(0) Share

Report

Posted on by AlwynSchutte

Good day

New to Power Apps and trying to accomplish the following:

I have two tables named Contacts and Groups. The Contacts table has a column named Group and the Groups table has a column named Group_short_name which has the same values. The Group table also has a column named Process_sequence_number.

I want a filtered list where the values in the Group column of the Contacts table is equal to the values in the Group_short_name column of the Groups table and where the Process_sequence_number in the Groups table is equal to Can1.

So I want this filtered list- Filter(Groups,Process_sequence_number="Can1") to be compared to the Group column in the Contacts table.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AlwynSchutte

Based on your picture, can you describe what the resultant table is that you want from that sample data?

Is it groups you want a filtered result from, or Contacts?
AlwynSchutte 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy
The filtered list must be from the Contacts table.
AlwynSchutte 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy
To try and explain it better. I display a gallery with title and subtitle. The gallery title and subtitle list must be populated from the Contacts table which is the Full_name column and the Group column in the Contacts table. The filter must compare all values in the Group column from the Contacts table to the Group_short_name in the Groups table as well as where the corresponding values in the Process_sequence_number column in the Groups table is equal to Can1. So the Contacts table list must be limited to only Can1 values in the Process_sequence_number column in the Groups table.
AlwynSchutte 69 on at

Like
a
(0)

Report
Copy link

Link copied!

What I got so far is Filter(Contacts,Group in Groups.Group_short_name) now I want the filter limited to where Group_short_name is equal to Can1 in the Process_sequence_number column in the Groups table. There will be multiple Can1 values in the Process_sequence_number column- all of them must be included in the final filtered list.
AlwynSchutte 69 on at

Like
a
(0)

Report
Copy link

Link copied!

This function returns only one record instead of three: Filter(Contacts,Group in Filter(Groups,Process_sequence_number="Can1").Group_short_name)
Verified answer

AlwynSchutte 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I actually had a look at the my Contacts table again and the function works! Some of the data changed and when I add new data the filtered list updates.
Filter(Contacts,Group in Filter(Groups,Process_sequence_number="Can1").Group_short_name)