excel Update Row Duplicate Key Value

[JimTurner]

HI when I connect to a specific spreadsheet and add in the Table and Key Column I get a duplicate Key Value field and cant get past this as I get a  Definition contains invalid parameters error

any ideas

It works okay om a test workbook but I cant connect to a customer specific template I cant alter

[v-yamao-msft]

Hi @JimTurner,

Do you want to update row in Excel table with the action Update a row?

In the action Update a row, please enter a value under the Key column, then it will run succeed.

I have made the following test, select column “name” for Key column field, then in the key value field, enter the value “dddd” that I am going to update.

It works fine. Please take a try with it on your side.

Best regards,

Mabel Mao

[JimTurner]

The issue I have is that I have two Key Value boxes , I cant get passed this.  If I create a test workbook it works as you describe but If I use the customers workbook it fails 

[v-yamao-msft]

Hi @JimTurner,

Could you share more details on your customer workbook to help reproduce this issue on my side?

Which browser are you using? Please test it with a different browser to see if you will still get duplicate Key Value fields.

Best regards,

Mabel Mao

[JimTurner]

I have tracked it down to a table column called 'id'. If I rename this the error of duplicate key disappears

The table has a formula to generate the row id as row($A1) to generate the row Id's  

I am still struggling to get the row to update at present 

[JimTurner]

My flow has two connectors connecting to two workbooks

Workbook 1 - Two columns Jid ( renamed ID column ) and First Quotation ( its a reduced version of Workbook 2)

Workbook 2 - 54 columns  Jid ( renamed ID column ) and First Quotation

flow is successful and says all has ran sucessfully for both workbooks

updates first workbook fine , second workbook doesnt get updated 

[JimTurner]

My flow has two connectors connecting to two workbooks

Workbook 1 - Two columns Jid ( renamed ID column ) and First Quotation ( its a reduced version of Workbook 2)

Workbook 2 - 54 columns  Jid ( renamed ID column ) and First Quotation

flow is successful and says all has ran sucessfully for both workbooks

updates first workbook fine , second workbook doesnt get updated 

[JimTurner · Accepted solution]

Hi

I have finally got to the bottom of it,

The flow doesnt like spreadsheets with any buttons in them.

As its a customer template there was a button which was previously used to run a macro still in the workbook.

After removing the button the flow works fine.

Took a long time but got there in the end.