Unanswered

DropDowns filtering on multiple columns and criteria

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

Pretty stumped here I feel like i have tried multiple different ways at this point to get what im looking for - but for some reason I cannot get the result im looking for. I am trying to build a canvas app that will suggest to the user the next available "dock" that is "OPEN" and not the current dock. When I try to apply these functions to the items list I am hitting two different problems i guess im not sure where my approach is wrong.

Using the current filter i get no errors - however the drop down list does not display any values it is blank.

The second function that is commented out - yields only one value - please help anyone!

Filter('Trailer Tracking', Trailer.Value = "OPEN" && Dock.Value <> "B1")

//LookUp('Trailer Tracking', Trailer.Value = "OPEN" && Dock.Value <> "B1", Dock)

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please check the dropdown control's value property.

In addition, please try to delete the formula of the dropdown control (Items property) and add it again.

Finally, you could try to refresh the data source.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello I have tried this - when using the first forumla it is greyed out and says comments