Solved: multiple email address not being read properly in flow

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.

Categories:

Using Apps Using Formulas