Power Platform Community Forum Thread Details

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:

Building Power Apps

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)
)