Forum Discussion
SharePoint List - Concatenate multiple rows
Hi bryanfrumkin47,
How are you storing the information for regions mapped to the agent?
If it's a separate list with 2 columns (agent, regions) then you can use this list to pick the agent name in the Leads list, and additionally display the regions column automatically.
Refer the below link for more details, "Adding a Lookup column to an existing list"
https://support.microsoft.com/en-us/office/create-list-relationships-by-using-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632
Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.
- Hello nimesht
I am storing the region information in a single line of text column that is being uploaded from an excel spreadsheet.
Furthermore, Is my goal only possible with two lists?Hi bryanfrumkin47,
Will it be possible for you to share the screenshots with the details about your requirements and the relevant lists?
Mask the confidential data and then upload the image.
nimesht
Within the list, it shows the lead, the agent assigned, and which region the lead is assigned to (choice column); moreover, I want to create a calculated column that will be next to the my agent assigned column that will display the name of the different region choices they are assigned to. That way if an agent is assigned to multiple, different, regions, it will display such (even if they are viewing only one of their leads).
