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?
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?
Hello @Laura3
You would need to filter, try this and let me know
Share
Report
All responses (
Answers (
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
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
