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)
)
2
Share
Report
All responses (
Answers (
