I answered on your other thread. Please try to avoid postin gin multiple places, especially as this is not the correct one
Its really important that you share your code and what is not working so we can help, plus in this case there isn't any details so writing this is just a pseudo guess.
You have 2 lists.
let's pretend your Combobox is called Department
And let's pretend the List you want to get the the emails from is List2
To get the emails
ONE important detail about the below, depending on how you bound your data to the Department combobox, instead of putting Value, you might have to put the proper column name)
The below will grab all the records from List2, where the Department Value is in and this is important. the concatenated string of all the things selected in the box
Filter(List2, Department in Concat(Department.SelectedItems, Value))
Now, you could do something like (and bare with me I'm eating and one handed typing lol)
// Now I put 'Email List' because you have it in the header with a space. I dont know what the proper COLUMN name is in sharepoint, so please put that, don't put what I typed.
// again change Value to be whatever matching column you have. If its just a list of Strings in the Items property of the Combobox, then Value is correct.
Distinct(Filter(List2, Department in Concat(Department.SelectedItems, Value)), 'Email List')
This gives you just a list of the unique values out of email.. and now we want to create the single email string
Concat(Distinct(Filter(List2, Department in Concat(Department.SelectedItems, Value)), 'Email List'), 'Email List' & ";")
Now one last time, you need to make sure that the proper things are put for
Value
'Email List' #1
'Email List' #2 (this will either be the column name of Value (again lol)
