Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter SP Column to return Blank Values

(0) ShareShare
ReportReport
Posted on by 252

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:
  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Filter SP Column to return Blank Values

    Hi @LaurensM 

     

    Thank you, I used the Switch Function solution

  • Verified answer
    LaurensM Profile Picture
    LaurensM 12,510 on at
    Re: Filter SP Column to return Blank Values

    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!

  • Hassan_SZ_365 Profile Picture
    Hassan_SZ_365 542 on at
    Re: Filter SP Column to return Blank Values

    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

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard