Filter Combo Box Choices by Different Column

(0) Share

Report

Posted on by forengland

I'm trying to filter an Edit form's combo box items with a different field.

Table: Allocations

Field to Display in Drop down: Project

Field to Filter by: Projects:Status (this is a lookup column in the SharePoint list)

So in this scenario, the dropdown box will show 'Projects' where the 'Projects:Status' = "In Progress".

I've scoured this forum (among others) and have copied/paste all kinds of code, but can't seem to get it to work. In my inexperienced mind it should be:

Filter(Choices([@Allocations].Project), Project:Status.Value = "In Progress")

But it doesn't show any items in the dropdown. Whereas, Choices([@Allocations].Project) shows all 'Projects'...which I would expect.

This has been going on for so long, i've lost track at what i've 'thrown' at the wall. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @forengland ,
I cannot test this, but you cannot filter on Lookup fields, so try
Filter( AddColumns( Allocations, "ProStatus", Projects:Status ), ProStatus="In Progress" ).Projects

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
forengland 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Warren,

I assume this goes in the dropdown datacard (DataCardValue2) ITEMS field. It didn't work, and I tried a few variants. What exactly does the AddColumns function do exactly?

Was this reply helpful? Yes No
WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@forengland ,
You cannot Filter on Lookup columns - it is one of the limitations of using this column type. The AddColumns syntax "extracts" the part of a record-type field such as Choice or Lookup and turns it into text, allowing the Filter. The syntax I gave works on the .Value of a Lookup or Choice field, however I mentioned I could not test yours at the time.
I have now done this on a model and I cannot see a way you can do what you want off that field. You need to go the other way and do the lookup you are doing in SharePoint in Power Apps. Happy to assist if you want to have a go at this and post your code.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No