Using Power Automate Flow to add new row

Mario Cadena

Hi Community,

I am creating a power flow that creates rows in SS based on an email. Everything works fine until I want to add data in a contact list column.

I have tried different formats without luck:

• only email
• only name
• First name, last name, email
• { email: emailAddress, name: name}

I get the following error

The value "Mxxx, Cxxx, Mxxxxx@wxxxx.com.au" could not be saved in column "REP". This column is restricted to CONTACT_LIST values only.

any advice or recommendation,

Regards,

TVang

Hi, @Mario Cadena,

Here's one workaround.

1. Create a helper column, e.g., PA_REP.
2. Configure your Flow to insert the email address into PA_REP.
3. Create a column formula, =[PA_REP]@row, in the contact list column, REP.

Cheers!