I have a list called Builders that im trying to pull data from in a dropdown box, however i only want to pull current/active builders from the list as its quite a large list.
In the Builders list i have a colum called Builders_x0020_Name and i also have a Boolean column that is called Current and each builder holds a YES/NO value. I'm just wanting the drop down list to pull the company name of the current builders.
I've done a fair bit of playing around and some research but i cant understand why this wont work. Below is the formula - when inputed into powerapps a red sqiggly line appears under the = sign
Filter(Builders.Company_x0020_Name,Builders.Current = 1)
Not extreamly familiar with list, mostly worked with sql tables.
Try below code:
Filter(Builders, Builders.Current = 1)
Then to get column "Builders_x0020_Name" to be the value in the drop down, go to advanced tab and see below screen shot. Set "Value" to be your column.
The Items property of the dropdown should be:
You can wrap the whole thing in a Sort
Then click on your dropdown control and in the right hand side of the screen under the Advanced tab and half way down is a dropdown called Value, click it and select Builders_x0020_Name from the list. In my example I wanted to show the Shipper's name.
The reason why it didn't work before is that Sharepoint Yes/No columns reduce to true/false unlike Sql where Yes/No reduces to 1 or 0. If this answers your question, please mark the thread as solved.
Yeah, I just tried it and it didn't work. I looked at one of my Sharepoint lists and Yes/No columns are reduced to true and false on my side. My formula for filtering a Produce_1 list by discontinued Yes/No worked perfectily.
Filter(Products_1,Discontinued=false). If you remove the Sort, did the filter work for you?
Continue your learning in our online communities.
Stay Up-to-Date by following PowerApps on Twitter
Let's thank our top community contributors
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Features releasing from April 2019 through September 2019!