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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,864)