Using Power Automate Flow to add new row

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,

Answers