How to Hide a Column in Power Apps Data Table?

In Power Apps, you can customize the data table by hiding specific columns. This feature allows you to focus on essential information or hide sensitive data from view. Follow this tutorial to learn how to hide a column in the Power Apps data table with different use cases.

Hide a Column in Power Apps Data Table

While working with the Power Apps data table, sometimes we need to hide specific columns or a column as per our requirements. Now, I will show you how to hide a column in the Power Apps data table using different examples. Such as:

  1. How to Hide Power Apps Data Table Column using Button Control
  2. How to Hide Power Apps Data Table Column using Dropdown
  3. Power Apps Hide Data Table Column Based on Text Input
  4. Working with Power Apps Hide Data Table Column based on Current User

Hide Power Apps Data Table Column using Button Control

Let’s take a simple scenario: I have created a Power Apps data table using my SharePoint Online list [Travel Requests] and this list contains the below fields.

Column NameData Type
Trip TitleIt is a Default single line of text
DestinationLocation
Travel Start DateDate and time
Travel End DateDate and time
Requested ByPerson or Group
Number of DaysNumber
How to Hide a Column in Power Apps Data Table

The Power Apps data table displays six columns, as I mentioned above, and Now, I would like to hide the “Number Of Days” column when the Power Apps screen is loaded, and the column should be only visible when a user clicks or taps the button control.

Refer to the below Screenshot:

How to Hide the Data Table Column in Power Apps

To achieve it, follow the below-mentioned steps. Such as:

1. Create a Blank Canvas app and connect it to the specific SharePoint list [Travel Requests] -> Select the Power Apps Screen and set its OnVisible property to the code below.

OnVisible = UpdateContext({varHideColumn: false})

Where,

  • UpdateContext() = This Power Apps function helps to create a context variable
  • varHideColumn = Context variable name
How to Hide Column in Power Apps Data Table

2. On the Power Apps Screen -> Insert a Data table and set its Items property as:

Items = 'Travel Requests'

Where,

  • Travel Requests = SharePoint Online List
Hide a Column in Power Apps Data Table

3. Now select the specific column [Number Of Days] that you want to hide in the data table and set its Visible property to the below code:

Visible = varHideColumn
Hide Column in Power Apps Data Table

4. Then, insert a Button control and set its OnSelect property as:

OnSelect = UpdateContext({varDispColumn: true})
How to Hide the Column in Power Apps Data Table

5. Once your app is ready, Save, Publish, Reload, and Preview the app. You can see the specific column has been hidden in the data table control.

How to Hide the Column in Power Apps Data Table Control

6. Also, if you want to display a specific column then click on the button control like below.

How to Hide Column in Power Apps Data Table Control

Hide Power Apps Data Table Column using Dropdown

Here. I will show you how to hide or disable the Power Apps data table column using a dropdown control with a simple example.

See also  Power Apps Sort Gallery By Calculated Field

Example:

I will also take the above SharePoint Online list [Travel Requests] for this example. In Power Apps, there is a Dropdown control and a data table control. The dropdown control displays SharePoint list column names, and the data table displays all SharePoint list records.

Input:

How to Hide Data Table Column in Power Apps

Now, I would like to hide the column in the Power Apps data table based on the dropdown selected column, as in the screenshot below.

Output:

Hide Column in a Power Apps Data Table Control

To do so, follow the below steps. Such as:

1. On the Power Apps app -> Select the App object [From the left navigation] and set its OnStart property to the code below.

OnStart = Set(
    varListColumnNames,
    Distinct(
        Ungroup(
            MatchAll(
                JSON(ShowColumns('Travel Requests',"Title","Airline","TravelStartDate","TravelEndDate","NumberOfDays"),
                    JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes
                ),
                "([^""]+?)""\s*:"
            ).SubMatches,
            "SubMatches"
        ),
        Value
    )
)

Where,

  • Set() = This Power Apps Set() function can help us to set a global variable to the entire app
  • varListColumnNames = Global Variable Name
  • Distinct() = This function used to remove the duplicates in the table
  • Ungroup() = This function returns a formula for breaking separate records
  • MatchAll() = We can use this function to extract all text strings that match
  • JSON() = This function helps us to represent a data structure as a text so that it is suitable for sorting or transmitting across a network
  • ShowColumns() = The ShowColumns() function includes columns of a table and drops all other columns
  • ‘Travel Requests’ = SharePoint Online List
  • “Title”,”Airline”,”TravelStartDate”,”TravelEndDate”,”NumberOfDays” = SharePoint List Columns
  • “([^””]+?)””\s*:” = Regular expressions to check the text again
  • “SubMatches” = Group Name
How to Hide a Column in Power Apps Data Table Control

2. Next, select the Power Apps screen -> Insert a Dropdown control and set its Items property:

Items = varListColumnNames
Hide a Column in Power Apps Data Table Control

3. Then, insert a Data table control and set its Items property like below.

Items = 'Travel Requests'
Hide Column in Power Apps Data Table Control

4. Now, select the specific column [Number Of Days] that you need to hide in the data table and set its Visible property as:

Visible = If(
    "NumberOfDays" in drp_ColumnNames.Selected.Value,
    false,
    true
)

Where,

  • If() = This function helps us to evaluate unrelated conditions
  • “NumberOfDays” = SharePoint list column which we want to hide in the data table
  • drp_ColumnNames = Power Apps dropdown name
Hide Column in the Power Apps Data Table Control
Note: If you want to remove any other column in data table then you can select the specific column and set its visible property as I mentioned above.

5. Save, Publish, and Preview the app. Whenever the user selects a specific column from the dropdown, the data table will hide that column like below.

How to Hide a Data Table Column in Power Apps

Power Apps Hide Data Table Column Based on Text Input

Let’s see how to hide a Power Apps data table column based on the text input search results with a simple scenario:

See also  How to Select Multiple Items in Power Apps Gallery Control?

Scenario:

I have a Power Apps collection [colBlogDetails] and this collection contains the below fields.

Input:

How to Hide PowerApps Data Table Column

Now, I would like to display these collection records on the data table and Whenever the user enters a specific column name in the text input control, the data table will hide that specific column like below.

Output:

How to Hide Power Apps Data Table Column

To achieve it, follow the below steps.

1. To create a Power Apps collection, select the App object and set its OnStart property like below.

OnStart = ClearCollect(
    colBlogDetails,
    {
        BlogTitle: "Power Apps Collection",
        BlogWebsite: "SPGuides.com",
        PublicationDate: "16/02/2023",
        AssignedTo: "PattiF",
        Status: "Completed"
    },
    {
        BlogTitle: "Power Apps Dropdown",
        BlogWebsite: "EnjoySharePoint.com",
        PublicationDate: "18/02/2023",
        AssignedTo: "Lynee",
        Status: "In Progress"
    },
    {
        BlogTitle: "Create Profile in Salesforce",
        BlogWebsite: "SalesforceFAQs.com",
        PublicationDate: "20/02/2023",
        AssignedTo: "JohannaL",
        Status: "Pending"
    }
)

Where,

  • colBlogDetails = Power Apps collection name
  • BlogTitle, BlogWebsite, PublicationDate, etc… = Collection headers/columns
  • “Power Apps Collection”, “SPGuides.com”, etc… = Collection records/rows
How to Hide the Power Apps Data Table Column

2. Then, on the Power Apps Screen -> Insert a Text input control and set the Default property as blank.

How to Hide Power Apps Data Table Column

3. Next, insert a Data table control and set its Items property as:

Items = colBlogDetails
Hide Power Apps Data Table Column

4. Now, select the specific column [AssignedTo] and set its Visible property to the code below.

Visible = txt_Value.Text <> "AssignedTo"

Where,

  • txt_Value = Power Apps text input name
  • “AssignedTo” = This is the column we need to hide in the data table
Hide a Power Apps Data Table Column

5. Whenever the user enters the specific column that he/she wants to hide in the data table, the data table will hide that column, as shown below.

Hide the Power Apps Data Table Column

Power Apps Hide Data Table Column based on Current User

In the last, I will show you how to hide the data table column based on the current user. I will also take the above Power Apps collection for this.

See also  How to Sort Gallery by Person Column in Power Apps?

Now, I want to disable the specific column [AssinedTo] on the data table based on the current user [If the user email is not equal to the current logged-in user email, then the specific column will be hidden]

Have a look at the output:

Power Apps Hide a Data Table Column based on Current User

To work around this, follow the below steps.

1. On the Power Apps Screen -> Select the Data table control and set the Visible property of the specific column [AssignedTo] like below.

If(
    User().Email = "Lynee@szg52.onmicrosoft.com",
    true,
    false
)

Where,

  • User().Email = We can use the User(). Email function to get the current user email address
  • “Lynee@szg52.onmicrosoft.com” = Another user email address
PowerApps Hide Data Table Column based on Current User

2. Once your app is ready, Save, Publish, and Preview the app. The data table will hide the specific column, as in the screenshot below.

This way, we can hide the Power Apps data table column.

How to Hide Power Apps Data Table Column based on Current User

Conclusion

I hope you get to know now how to hide a column in Power Apps data table with various examples.

  • Hide Power Apps Data Table Column using Button Control
  • Hide Power Apps Data Table Column using Dropdown
  • Power Apps Hide Data Table Column Based on Text Input
  • Power Apps Hide Data Table Column based on Current User

You may also like:

>