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

Return Count to Gallery from Different List

I have Gallery1 that is displaying data fromProjectList1.

I have the need to display related data from DetailsList2.

Action:
If 'ProjectName' of DetailsList2 matches the content of Gallery1.Subtitle1 (ProjectName from ProjectList1).Text then return the content of Details2.ProjectTeamSize.

Not sure if I need to do a LookUp or other.

CountA(ProjectList.ProjectTeamSize, If(ProjectName = Subtitle1.Text))

Phineas_0-1664231095767.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @Phineas ,

 

Do you want to get the corresponding field value in another list based on the 'ProjectName' of the current item?

Maybe you could try the following formula:

LookUp(DetailsList,ThisItem.ProjectName=ProjectName).ProjectTeamSize

I have made a similar test for your reference.

1. Here are my lists.

vyujincuimsft_0-1664250664463.jpeg

2. Here is my App.

vyujincuimsft_1-1664250679825.png

 

 

Best Regards,

Charlie Choi

View solution in original post

1 REPLY 1
v-yujincui-msft
Community Support
Community Support

Hi @Phineas ,

 

Do you want to get the corresponding field value in another list based on the 'ProjectName' of the current item?

Maybe you could try the following formula:

LookUp(DetailsList,ThisItem.ProjectName=ProjectName).ProjectTeamSize

I have made a similar test for your reference.

1. Here are my lists.

vyujincuimsft_0-1664250664463.jpeg

2. Here is my App.

vyujincuimsft_1-1664250679825.png

 

 

Best Regards,

Charlie Choi

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.

Top Solution Authors
Top Kudoed Authors
Users online (1,854)