Answered

Delete Item(s) from List 1 Once Added to List 2

(0) Share

Report

Posted on by Phineas

5,073 Super User 2025 Season 1

I'd like to have someone confirm structure of my flow.

The 'Production List' may have several line items that share the same 'Campaign' number.

Power Apps has a patch that adds an item to the 'Completed List'.

Each new item to the 'Completed List' has a unique 'Campaign Number' (Title column).

That same 'Campaign Number' matches the 'Campaign Number(s)' in the 'Production List' (Campaign column).

Intent:
1. When an item is created in 'Completed List', get items from 'Production List'.

2. Get items from 'Production List' where Campaign number (in Campaign column)
matches 'Completed List' Title column (the Campaign number in the 'Completed List').

3. Delete ALL line items in the 'Production List' where the Campaign number(s) match the
Title column of 'Completed List'.

Categories:

Business Process Flows

All responses (15)

Answers (2)

Verified answer

Tomac 693 Super User 2025 Season 1 on at

Like (0)

Report

Delete Item(s) from List 1 Once Added to List 2

@Phineas

Both flows look solid. The only thing I would add is a "Send An Email" action to the "If No" part of your Conditions, to notify somebody that there was an invalid number of rows in the searched list. Then you've covered all your bases.
Phineas 5,073 Super User 2025 Season 1 on at

Like (1)

Report

Delete Item(s) from List 1 Once Added to List 2

@Tomac

I have a habit of confusing people; I apologize.

This is the flow that deletes multiple items.

This is the flow that deletes one item.
Tomac 693 Super User 2025 Season 1 on at

Like (0)

Report

Delete Item(s) from List 1 Once Added to List 2

@Phineas

Ok hold up. I thought we finished the first flow that needed to delete multiple items and were only working on the flow to delete a single item. Let's be clear on this point:

For the flow that needs to delete multiple items, your Condition should be greater than 0

For the flow that only deletes a single item, your Condition should be = 1

Sorry if I missed the topic change earlier.
Phineas 5,073 Super User 2025 Season 1 on at

Like (1)

Report

Delete Item(s) from List 1 Once Added to List 2

@Tomac

And here is the updated second flow, where only ONE item needs to be deleted.
Tomac 693 Super User 2025 Season 1 on at

Like (0)

Report

Delete Item(s) from List 1 Once Added to List 2

@Phineas Looks great. You've got your trigger, search, and action, and you're even doing a bit of error prevention. That's a solid flow.
Phineas 5,073 Super User 2025 Season 1 on at

Like (1)

Report

Delete Item(s) from List 1 Once Added to List 2

@Tomac

How about this...
Tomac 693 Super User 2025 Season 1 on at

Like (0)

Report

Delete Item(s) from List 1 Once Added to List 2

Close! The apply to each action would be inside the Condition, not the other way around.

You shouldn't need a Terminate action at the end of this flow, either. When the actions complete it will end with a status of successful.
Phineas 5,073 Super User 2025 Season 1 on at

Like (0)

Report

Delete Item(s) from List 1 Once Added to List 2

@Tomac

Regarding you 'array' response, here is my update of the second flow, where only one item needs to be deleted from the list.

Does this look correct?
Phineas 5,073 Super User 2025 Season 1 on at

Like (1)

Report

Delete Item(s) from List 1 Once Added to List 2

@Tomac

Is this what you suggest?

This flow should delete ONLY those 'Campaign' numbers from the Production list that match the 'Campaign' number added to the 'Completed' list.
Phineas 5,073 Super User 2025 Season 1 on at

Like (2)

Report

Delete Item(s) from List 1 Once Added to List 2

@stampcoin

I only want to delete ALL 'Campaign' numbers from the 'Production List' that match the 'Campaign' number
added to the 'Campaign List'.

All other 'Campaign' numbers in the 'Production List' should remain.