web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter SP Column to re...
Power Apps
Answered

Filter SP Column to return Blank Values

(0) ShareShare
ReportReport
Posted on by 262

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

Categories:
I have the same question (0)
  • Hassan_SZ_365 Profile Picture
    542 on at

    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

     

  • Verified answer
    LaurensM Profile Picture
    12,516 Moderator on at

    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!

  • Skybluekid Profile Picture
    262 on at

    Hi @LaurensM 

     

    Thank you, I used the Switch Function solution

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard