Forum Discussion
Count a multivalue lookup column
Hi,
I am new to developing SharePoint so I have a question for you.
I have to Lists
In list A I have two single text columns like this:
| Area | Project |
| A1 | 1 |
| B1 | 2 |
I have another list B that have a lookup column to List A - Column Project, that allows multiple choice like this:
| Client Name | Project |
| A | 1 |
| B | 1 |
| C | 2 |
And I want to add a column in list A that retrieves the total numbers of client for each project like this:
| Area | Project | Clients |
| A1 | 1 | 2 |
| B1 | 2 | 1 |
There is any way to solve this?
Thank you in advance 🙂
AldaSemedo There is no SharePoint out of the box way to achieve this. You will need a workflow / power automate flow which will run on item creation/update in List B & update corresponding item in List A.
OR scheduled flow/script which will run once a day & update items in List A based on values in List B.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
