Filtering a gallery with inputs from 2 SharePoint list

(0) Share

Report

Posted on by nalstevens

105

I have two lists

Client
Plans
Plans list fields
1. Plan Name
2. ClientID (number)
3. Project Manager (people picker)

I want to create a gallery filter that only shows the Clients for this Project Manager when they open the app.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@nalstevens possibly reading this wrong, but I think you want your Gallery to display the Plans list and then Filter that Gallery by the logged in user? E.g:

Filter( Plans, 'Project Manager'.Email = User().Email )

What is the need for the Client list, given you have the ClientID already in the Plans List?

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
nalstevens 105 on at

Like
a
(0)

Report
Copy link

Link copied!

I can do this, I what a Gallery to show the clients where the plan list field Project Manager = logged in user

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@nalstevens could you clarify why the above suggestion does not do what you need it to do? You have the ClientID in your Plan list, which you can leverage to get any field you need from the Client list.

Was this reply helpful? Yes No
nalstevens 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Amik. One client can have 20 plans. I don't want a huge list of plans, I have another gallery on the same screen that populates the plans once the client is selected in the gallery in question. So I want only the clients that the project manager is assigned. Then they can select the client to access the plans.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

sorry @nalstevens not matter how many times I re-read your explanation, I am not still getting it. Could you share an example of your data?

In my mind it looks like this:

Was this reply helpful? Yes No
nalstevens 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I'm trying my best to word it correctly 🙂 One client can have multiple Project Manager
Client List Plan List

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@nalstevens right so what I had in my mind was correct.

I can only repeat the same advice, you only need to Filter the Plans table by project manager. It does not matter if one client has multiple project managers, you will still get a Table/Gallery which displays clients associated to the project manager who opened the app.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
nalstevens 105 on at

Like
a
(0)

Report
Copy link

Link copied!

So there is no way to filter the clients list to show only the clients the project manager is listed. If I filter on just the plan someone may have a huge list of 80+ plans to muddle through or search, where they could just have a list of 4 or 5 clients

Was this reply helpful? Yes No
nalstevens 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Does anyone know if this is possible

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nalstevens - I would suggest raising a new post so you get more traction from other community members.

Unfortunately I do not understand what you want.

Was this reply helpful? Yes No