Unanswered

Delete line by a key

(0) Share

Report

Posted on by MaiD

Hello guys,

I have two Excel lists. One list comes from the colleague, the other one is for monitoring.
The list from the colleague should be searched for the column "Decision". Possibilities are "new", "delete", "update".
If the cell says "delete", I want to delete this row in the monitoring list.

Certain values may appear more than once in the monitoring list. Therefore I need to compare according to a key
(ID, project name, cost center).

The row with the ID, project name, cost center should be deleted in the monitoring list.

is it possible to specify multiple columns in the lead column? If so how do I separate the columns?

At the moment my flow looks like:

first loop over the list from my colleague.
case condition: "new", "delete", "update"
case delete: loop over my monitoring list
if condition: If ( ID, project name, cost center from the list of my colleague == ID, project name, cost center from the monitoring list)
yes -> Delete row with the ID

This works so far but takes a long time. I suspect it is because of the two loops nested Applay to each.

Thank you for helping 🙂

I have the same question (0)

All responses (3)

Answers (0)

Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Delete line by a key

Apply to each and conditions inside is never a good idea. You should try to filter the relevant rows with “filter array”. Maybe xpath can be useful too.

If you provide sample data (please JSON and not screenshots) and desired output, I will provide a solution without loops (except the one you need to delete the rows).

Was this reply helpful? Yes No
MaiD 30 on at

Like (0)

Report
Re: Delete line by a key

Hi Matthy79,

there is the first problem. i dont know how to create a JSON file from my Excel.
My idea is:
Loop over the List
Case condtion
Create 3 JSON files after the column "decision" should be decided
Now i will have 3 JSON files (with "new", "update", "delete") <- Here I am struggling right now
then all three JSON are to be processed in parallel. Depending on the list
What u think about this way?

BR

Was this reply helpful? Yes No
Matthy79 4,178 Super User 2024 Season 1 on at

Like (1)

Report

Re: Delete line by a key

As I said. Loop and condition is never a good choice. You don’t have to create the JSON I requested. The output of “List rows” is a JSON. You can see and copy it, if you check the flow run history.

Was this reply helpful? Yes No