web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown with lookup t...

Power Apps

Unanswered

Dropdown with lookup to parent list

(1) Share

Report

Report

Posted on by Laura3

71

Hi there,

I have two lists: projects and partners. (Not all projects have partners but all partners belong to a project).

In my partner list I have a ProjectID field which is a lookup to the ProjectID in the project list.

I would like to create a dropdown that displays only projects that have a partner (project id exists in the partner list). Any ideas how to do that?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Laura3

You would need to filter, try this and let me know

Filter('Projects', IsBlank('LookUpField'))

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Laura3 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @FLMike

Perhaps I need a bit more detail from you on how to make it work.
I would like my dropdown to show a single count of all the Projects that have a match in the Partners table. The partner table contains a field called ProjectID which is a lookup to the Projects table. I've tried creating a collection with addcolumns, "new column", !IsEmpty(filter(Partners,ProjectID.Value=ProjectID)) but this doesn't work. I tried the option of adding a column with an if statement (if is empty "no partner", "partner"). I tried a distinct function on the partner table then add column, but that runs into a delegation issue. Any ideas?

Join the conversation