Answered

Need assistance with filtering column from another table

(0) Share

Report

Posted on by Daily

I have a gallery with buttons that display Series 1 information from a SharePoint list. On Select these buttons set varSelectedSeries to the selected Series 1 (Example: varSelectedSeries=0100).

There is another SharePoint list with Occupations that filters on varSelectedSeries as shown below. In this example you can see all of the Series 1 are showing.

Occupations
Series 1	Series 2	Job Title
0100	0110	HR
0100	0120	Manager
0100	0130	Nurse
0103	0140	IT
0104	0150	Maintenance

Finally there is an existing SharePoint list of applicants but the applicants only have an Occupation name and that is a choice/lookup column that feeds from the Occupation list. What I am trying to figure out is how do I get a collection to pull all of the applicants that have HR for an Occupation based on a variable set to 0100?

Applicants
Name	City	Occupation
Joe	Chicago	HR
Bob	New York	HR
Jeff	Atlanta	Manager

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

KRider 577 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
So, if series 2 is in a gallery and you have a button you can:

Set(gblVariable, ThisItem.Occupation)

That then sets the occupation name. You can then set the applicants gallery to your new variable.
Daily 2 on at

Like
a
(0)

Report
Copy link

Link copied!

What I am trying to accomplish is collecting all applicants that have an occupation that matches up with job title text in the 0100 series.
Verified answer

v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Daily ,

According to your Description, we create the data source below.

We insert the Button and fill the formula below to apply the function you want.
Set(var0100,Filter(Applicants,' Occupation' in Concat(Filter(Occupations,'Series 1' = "0100"),'Job Title',",")).Name)

Click the Button.
We can see the result we expect through the Gallery.

Hope this will help you,

Best Regards,
Tina