Airtable field with comma separated values into Gmail cc

[Moiz_Abdulkader]

Hi everyone.

I have a record being pulled from airtable which contains 2 fields, a to: email and a cc: email. The to always contains a single email address and with the map toggled on in the gmail module that works fine.

However, the cc: field in Airtable has multiple address that are comma separated. I have tried to map this but it doesn’t work and I tried a text aggregator but that caused all sorts of issues with the rest of my flow.

Any help appreciated.

Thanks.

[Prem_Patel]

Hi @Moiz_Abdulkader , Welcome to the community!

I think you just need to use split function like this - Enable mapping option in cc and map field with cc email addresses in split function.

It will solve your problem.

Best,
@Prem_Patel

[Moiz_Abdulkader]

Thanks @Prem_Patel

I tried that, but for some reason the cc fields ended up blank, ie it didn’t cc anyone.

and there is definitely data in that field:

[Prem_Patel]

You are mapping array value directly.

There are 2 ways to solve this :

1. You have to use first function with split here, so map it like split(first(email cc);,)

or

2. Map 1st item directly in split like this (2nd mapping is your ref.; 1st one is what you are using for mapping) just expand the cc email mapping field with a little dropdown like arrow on left and select 1st item. You can place number of item you want to retrieve from output array. by default it’s 1, but you can write 1 manually in between square bracket space.
   
   

This will help you in this case.

Best,
@Prem_Patel

[Moiz_Abdulkader]

@Prem_Patel

You have to use first function with split here, so map it like split(first(email cc);,)

This worked! Thank you.

[Prem_Patel]

Glad that it helped! @Moiz_Abdulkader

Please mark the previous reply which helped you in solving your problem as Solution using this option

Best,
@Prem_Patel