You’re offline. This is a read only version of the page.
Hi All,
i have a small requirement, i have been working with power apps for quite some time now. So my current project involves dependent drop down based upon a single Field. Now i have a list which has been set as per the criteria, that is i have aligned all the column data so i can use it in my app to provide dependent drop down.
However, for some columns there are blank lines, so when i select a field it shows some blank value which is correct according to the data source but i would also want to remove these blank values from the drop down. is it possible.
Please find the list view data source. Also find the formula for filtering out values and also find image of drop down result.
in the below images the first image shows the template column with a blank value.
the second image shows the blank value in the drop down.
the third image shows the code used for the values.
@kbilakanti i have tried with the formula however it does not work. Please find the screenshot below for the items.
@Anonymous You can apply the check even in your formula. I don't think this should a problem. As per screenshot 3 which you have shared you are using Filter and sort and within that you can add a check to filter Not null values as well.
@kbilakanti i am actually picking out values from another list. its like a lookup. i would want to change in the current formula.
i just want to return non blank values.
@Anonymous You can filter the dropdown collection to check and show only not null values. Try to use the below formula.
Filter(Choices('Your SP list '.'Column Name'), Not(IsBlank(Value)))
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (