I have Gallery1 that displays data from List1.I need to add a Label to Gallery1 that displays related data from List2; The formula output needs to be a total of rows.I'm doing a similar this here that returns the content in the item.LookUp(PoCFTCWarrantyProjectList,ThisItem.ProjectName=ProjectName).ProjectTeamSizeI need something like the above that looks at List2 and counts the number of rows that a ProjectName that matches the content of the Gallery1.Label1 (ProjectName from List1).Something like -LookUp(ProjectList,ProjectName, CountRows(Gallery1.Label1.Text=ProjectName)
Go to Solution.
I don't think you need a LookUp() for this. What I would do is just perform a CountRows() on a filtered List2:
CountRows(Filter(List2, ProjectName = ThisItem.ProjectName))
View solution in original post
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!