web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / if choice column chang...
Power Automate
Unanswered

if choice column change in one list do action in another list

(0) ShareShare
ReportReport
Posted on by 49

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:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: if choice column change in one list do action in another list

    @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

    annajhaveri_0-1612269899155.png

    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

    annajhaveri_1-1612269984738.png

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard