cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phineas
Post Prodigy
Post Prodigy

LookUp and CountRows

 

 

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
JasonWS
Resolver II
Resolver II

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

1 REPLY 1
JasonWS
Resolver II
Resolver II

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,243)