I'm new to PowerApps. I had someone in my company who was very capable recently leave, so my source of review/corrections has also left. ChatGPT is not helping me solve this issue either as I've exhausted the troubleshooting and everything checks, so looking to you for help as I'm not getting the expected results.
I am building an app that collects and displays data. Screen1 has a dropdown list of projects (FilterDrop_ProjectName), which then populates a gallery (GalleryDesignPackageCategories) which is a checkbox list of categories. A user would then pick the categories they would like to see, and it populates the package details in another gallery (Gallery4).
FilterDrop_ProjectName OnChange property I have:
UpdateContext({filteredProjectName: Trim(FilterDrop_ProjectName.Selected.NewProjectName)})
GalleryDesignPackageCategories (the gallery), Check_ProjectCategory (the repeating check box populated by ProjectName) OnCheck property I have:
Collect(SelectedPackageCategories, ThisItem.Value)
Table '[DPC] Design Package Coordinations' has the following columns:
ProjectName - Text
PackageCategory - Text
Screen1 OnVisible property I have:
ClearCollect(
colGallery4Data,
Filter(
'[DPC] Design Package Coordinations',
ProjectName = filteredProjectName && PackageCategory in SelectedPackageCategories
)
);
When I add a text label to count the rows of colGallery4Data, it ends up as 0, but it should return 8. I've reduced the ClearCollect to try and show just ProjectName or PackageCategory, but no matter what it comes back 0, and won't populate my Gallery4 content. What's wrong with my ClearCollect or Filter functions?