Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Data Table Control Issue

Posted on 14 Nov 2024 09:14:21 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 911 on 26 Nov 2024 at 21:12:58
    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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard