Forum Discussion

Copper Contributor

Aug 24, 2023

SharePoint List - Concatenate multiple rows

Hello! Thank you so much for any assistance, truly. I am hoping to create a SharePoint calculated column. I have a SharePoint list In which I display agent's leads. Within the list, it sho...

Bronze Contributor

Aug 25, 2023

Hi bryanfrumkin47

I would create two lists instead of using a calculated column... One for leads and one for the regions of the leads. The "Region Assignment" list has a lookup back to the "Leads" list

Then I would create a new site page and add both lists using lists webparts. Now I would configure dynamic filtering on the webpart of the "Assignments" list and set it to be filtered by the value that is selected ion the "Leads" list

Now I have both lists on that page.
If I select a lead, the "Region" list automatically filters to show only the entries for the lead

Best Regards,
Sven

bryanfrumkin47

Copper Contributor

Aug 25, 2023

Thank you so much for your assistance, SvenSieverding

From excel, I am uploading data and one aspect of this data is the agent's profile; therefore, this solution isn't what I am looking for because when a user is selecting a lead they are looking to view information of the entire lead - not just agent region info.
Within the list, it shows the lead, the agent assigned, and which region the lead is assigned to, so if an agent is assigned to multiple, different, regions, it will display such - in this new column (even if they are viewing only one of their leads).