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,[email protected]" could not be saved in column "REP". This column is restricted to CONTACT_LIST values only.

any advice or recommendation,

Regards,

Toufong Vang

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 intoPA_REP.
3. Create a column formula,=[PA_REP]@row,in the contact list column,REP.

Cheers!