Power Platform Community Forum Thread Details

Hello to all,

I have 2 lists:

First is main list of devices with technical data, prices, ets and with different status(Choice column)

Second list(Available devices) should be automatically managed with flow (If status from first list is Ready then copy to this list - I can do that)

The problem is how to automatically delete item from second list(Available devices) - I would like to do something like that:

If status in First list is set to 'Ready' copy item to Second list. If status in First list has been change for 'Sold' or 'Hire' then delete this item from second list. Can you advise me how to do that? It is possible?

Categories:

Building flows

@lukaszp89 , please create the flow as follows:

1. Create Automated Cloud Flow and add the "When an item or a file is modified" trigger, select the SharePoint site and list

2. Then add "Get changes for an item or a file (properties only)" action to the flow and configure it as shown in below screenshot

3. Then add condition action and on left side of condition select "Has Column Changed: Status" and on left side select True from Dynamic Content -> Expressions

3. Then inside Yes branch of condition you can add more conditions to compare Status values to Sold or Hire, or add switch action and create two cases in switch action for Sold and Hire and add actions further in flow inside condition/switch case to get the item from second list and then delete item or update item of second list.