Microsoft Lists - Gather related values from list rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2184580%22%20slang%3D%22en-US%22%3EMicrosoft%20Lists%20-%20Gather%20related%20emails%20from%20list%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2184580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20there%2C%20I'm%20developing%20a%20Microsoft%20List%20app%20that%20will%20be%20embedded%20in%20Teams.%20It%20contains%20data%20brought%20in%20from%20a%20very%20long%20spreadsheet.%20Users%20currently%20use%20the%20spreadsheet%20to%20find%20a%20name%20and%20associated%20email%20addresses%2C%20sometimes%20many%20of%20them%20from%20the%20same%20organization.%20They%20simply%20copy%20all%20the%20contiguous%20cells%20with%20the%20required%20email%20addresses%20and%20paste%20them%20into%20Outlook.%20My%20problem%20is%20that%20Microsoft%20Lists%20does%20not%20allow%20us%20to%20copy%20cells%20(email%20addresses)%20in%20the%20same%20way.%20Is%20there%20a%20way%20to%20have%20Lists%20query%20the%20organization%20and%20provided%20a%20concatenated%20list%20of%20values%20(email%20addresses)%20based%20on%20the%20organization%3F%20Any%20help%20is%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2184580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi there, I'm developing a Microsoft List app that will be embedded in Teams. It contains data brought in from a very long spreadsheet. Users currently use the spreadsheet to find a name and associated email addresses, sometimes many of them from the same organization. They simply copy all the contiguous cells with the required email addresses and paste them into Outlook. My problem is that Microsoft Lists does not allow us to copy cells (email addresses) in the same way. Is there a way to have Lists query the organization and provided a concatenated list of values (email addresses) based on the organization? Any help is appreciated.

1 Reply

Just to clarify, when I say query the organization, I mean query the column with the organization within the same list ... to find all the rows flagged, for example, "DPW," and gather up all the data from the rows in the column marked "email addresses" and present them combined for easier copying and pasting. Thoughts?