Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Data Table Control Issue

(1) ShareShare
ReportReport
Posted on by 2
Hi Team,
I have inserted datatable control to show data also added 4 dropdowns to filter out the table. I am using multiple Filter expressions to filter out the data in data table control and its working fine in Edit Mode. But when i published the app, on published version i am getting empty data table. Also i did RnD on this but issue is not resolved.
Kindly help me on this.
Categories:
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,931 on at
    Data Table Control Issue
    pls try the following:
     
    Ensure the data source (e.g., SharePoint, Dataverse, SQL) is properly connected in the app and is accessible in the published environment:
    Go to File > Data Sources in Power Apps Studio. Reconnect the data source to ensure it’s active. Test access to the data source in the published environment: Open the app in the published environment. Check if data from the source is visible without filters.
     
    Verify that users accessing the app have sufficient permissions to read data from the source. For SharePoint: Users must have at least Read access to the list/library. For Dataverse: Users must have appropriate security roles. For SQL: Users must have valid credentials or access policies configured.
     
    Ensure your filter expressions are delegable to the data source. If they are not delegable, Power Apps processes only the first 2,000 records by default (this limit can be increased but may affect performance).non-delegable filter: Filter(MyDataSource, StartsWith(ColumnName, "ABC"))
     
    Replace with a delegable filter: Filter(MyDataSource, ColumnName = "ABC")
    Use the OnStart property of the app to initialize variables and collections - Set(varDropdownValue1, "Default");
    Set(varDropdownValue2, "Default");
    ClearCollect(MyCollection, MyDataSource);
     ensure the logic accounts for empty or default dropdown values:
    Filter(
      MyDataSource,
      (Dropdown1.Selected.Value = "All" || Column1 = Dropdown1.Selected.Value) &&
      (Dropdown2.Selected.Value = "All" || Column2 = Dropdown2.Selected.Value) &&
      (Dropdown3.Selected.Value = "All" || Column3 = Dropdown3.Selected.Value) &&
      (Dropdown4.Selected.Value = "All" || Column4 = Dropdown4.Selected.Value)
    )

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard