I have a sharepoint list column named CcTo that contains multiple email address for example
1@gmail.com;2@gmail.com;3@gmail.com
and another list column named Post that contains multiple email address as well
4@gmail.com;5@gmail.com
my problem is that when the flow is triggered, only 1 email address is recognized
my code for both of my list columns are as follows:
CcTo
Concatenate(
//first argument -
LookUp(
'DataSource',
(SSL = Text(DataCardValueSSL.Selected.Value) &&
Competency = DataCardValueSMU.Selected.Value &&
Rank = DataCardValueRank.Selected.Value),
CcTo
),
//separator
If(
!IsEmpty(
Filter(
'DataSource',
Role.Value = "OPS"
)
),
";",
""
),
//second argument
Concat(
Filter(
'DataSource',
Role.Value = "OPS"
),
'Member Name'.Email,
";"
)
)
Post
Concatenate(
//first argument -
LookUp(
'DataSource',
(SSL = Text(DataCardValueSSL.Selected.Value) &&
Competency = DataCardValueSMU.Selected.Value &&
Rank = DataCardValueRank.Selected.Value),
Post
),
//separator
If(
!IsEmpty(
Filter(
'DataSource',
Role.Value = "Recruitment"
)
),
";",
""
),
//second argument
Concat(
Filter(
'DataSource',
Role.Value = "Recruitment"
),
'Member Name'.Email,
";"
)
)
In my SharePoint list, the email address are valid and written properly.
I do not understand why only 1 email is being read in the flow. the ";" is being read but not the email address. Any form of help is appreciated.
