Hi All,
I have a dropdown list that corresponds to columns in my sharepoint list. I would like to return all the blank values of that column to a gallery. I have tried Filter(Table,IsBlank(dropdown.Selected.Value)) but it does not seem to bring any results back. The SP column is a Single Line Text.
Thanks in Advance
Hi @Skybluekid,
Unfortunately dynamic column selection is not possible within Power Apps. Some delegable workarounds I know of are:
(1) Using a Switch() statement with Filter() statements as output
Switch(
dropdown.Selected.Value,
Blank(),
Table,
//Change "Column 1" to one of the values within your dropdown
"Column 1",
//Change Column1 with the corresponding column name
Filter(Table, Column1 = Blank()),
"Column 2",
Filter(Table, Column1 = Blank())
)
Note: You could also use the Switch within your Condition. In this case you don't have to rewrite the Filter statement but this approach will lead to a non-delegable query.
(2) 'Dynamic' selection by adding && and || statements that check both the column and dropdown
Filter(
Table,
dropdown.Selected.Value = Blank() ||
(dropdown.Selected.Value = "Column 1" && Column1 = Blank()) ||
(dropdown.Selected.Value = "Column 2" && Column2 = Blank())
)
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
Hi @Skybluekid ,
Use this formula:
Filter(YourSharePointList, dropdown.Selected.Value = "")
Replace YourSharePointList with the actual name of your SharePoint list. This formula compares the selected column's values with an empty string and returns all the items where the column is blank.
Remember to replace dropdown.Selected.Value with the actual column name if dropdown.Selected.Value is not directly referencing the column name.
Best Regards.
Hassan Raza