Unanswered

Delete Rows w/ Excel (Business) connector

(0) Share

Report

Posted on by Community Power Pla...

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!

téléchargement (2).jpg téléchargement (3).jpg

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft on at

Like (2)

Report
Re: Delete Rows w/ Excel (Business) connector

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Delete Rows w/ Excel (Business) connector

Thank you Mabel, workd perfectly!

Was this reply helpful? Yes No