Delete Rows w/ Excel (Business) connector

[Anonymous]

Hello there, 

I am trying to get a list of rows deleted in a excel table every day. But so far, I am unable to get my filtered lines deleted. I am certainly do not get KeyColum and KeyValue right in my workflow. 

If anyone who got it working and can share its experience?

Thanks in advance!

[v-yamao-msft · Accepted solution]

Hi @Anonymous,

I am afraid that you have to make some changes on the action Delete a row.

In the action Delete a row, we are asked to select a column from the drop-down and enter the Key value.

I have made a test likes below for your reference.

In the action Delete a row, select the column from the dropdown, and enter the following code in the Key value field:

item()?['name']

Please check the following screenshots:

Please take a try with it and feel free post back if you have any problem.

Best regards,

Mabel

[Anonymous]

Thank you Mabel, workd perfectly!