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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Moving an item from 1 ...
Power Automate
Answered

Moving an item from 1 list to another - Novice needs some guidance!

(1) ShareShare
ReportReport
Posted on by 12
Hi.
I have set up 2 lists on Sharepoint for our Approved Suppliers.  They are exactly the same layout and column titles.  I want have created a STATUS column and in Approved its shows as 'YES' and Non Approved is shown as 'NO'.  I want to be able to move an item to either list and if the status is changed,  and then it automatically moves to the opposite list.  I have spent ages looking through posts and cannot find a direct answer on how to do it.  Im new to sharepoint and want to use this very powerful tool in my company.  Can someone please provide the exact instructions on how to do it?  Thank you. 🙏🙏🙏
Categories:
I have the same question (0)
  • Verified answer
    Cgangweg01 Profile Picture
    881 Super User 2026 Season 1 on at
     
    I could not find a Power Automate cloud SharePoint action to move an item from one SharePoint list to another.
    Since you mentioned that the lists are identical, a usable workaround is to build a flow that creates an identical copy of the item in the corresponding list then delete the original item. I think you also said that the Status column has choices Yes and No.
     
    I created two identical Lists to test this approach.
     
    'List Yes' and 'List No'. Here is screenshot of List No.
     
    The flow starts when a list item is modified in the 'List No' list.
     
    Check if the List item Status has been modified to Yes using a Condition action ...
     
     
    If true, Create identical record in the other List, in this case List Yes ... if False do nothing
     
    After creating the new item in the other list, delete the item in the original list (List No in this case)
    After modifying Record 4, it is now in the 'List Yes' list.
     
    You can create another flow that is based on 'List Yes' and do the same thing but in the opposite direction.
     
    Hope this helps. Please let me know if you have any questions.
     
  • SK-15101028-0 Profile Picture
    12 on at
    Hi.
    Thanks so much for that.  It does create a record and delete the old one.  However, the new record only shows the company name and the status.  Is has not copied all of the other columns across.  Where do I add these?   I have lots of columns as shown below and more after these.
     
     
     
    Thanks so much for your help 😊
  • Suggested answer
    Cgangweg01 Profile Picture
    881 Super User 2026 Season 1 on at
     
    Glad to help!
     
    In the Create item action there are Advanced parameters to select the additional columns.
    Here I've added Category and Tier to both my lists, making up the data.
    The dynamic content comes from the trigger list item that has been added/modified.
    As long as your columns/formats are identical this works.
     
     
     
     
     
     
     
    If this solved your issue, please mark it as ✅ Accepted Answer.
    Click the checkbox at the bottom of the reply:
     
    If it helped, feel free to give it a 🩷 Like!
     
    Much Appreciated!
  • SK-15101028-0 Profile Picture
    12 on at
    Absolutely incredible!!!  Thank you so so much.  That is awesome and makes my job so much easier, but I need to ask a quick unrelated question please.  My columns are set up to show dates.   I have chosen to to display the Friendly format, so should display as 01/01/25.  However, I have a weird thing happening and it is driving me mad.  Some of the columns are showing the date as a long date, even with the friendly format being enabled.  When I change that column back to non and then back to friendly, a different column changes!!   Very weird.   If you could advise on this please, you will be a god!  Thanks. :)
  • Verified answer
    Cgangweg01 Profile Picture
    881 Super User 2026 Season 1 on at
    @SK-15101028-0 you are welcome!
    Glad to help. If you wouldn't mind marking the other replies in this thread as Answered with the checkmark I'd appreciate it very much.
     
    Could you provide screen shots of the date columns that you are referring to and the behavior. I'm not that familiar with SharePoint lists.
    Mask or cover up any private data in the screen shots.
  • Cgangweg01 Profile Picture
    881 Super User 2026 Season 1 on at
     
    I was intrigued by the Friendly date format column in a SharePoint list. For this format 10/17/2025 , Friendly should be OFF. However, I am getting strange behavior as well when I turn it on and off. It does not go back to this format 10/17/2025 visually once off again for records already in the list. If you add a new record or edit an existing, it will be this format 10/17/2025 .
    Existing records that were saved in the Friendly format might need to be converted.
  • SK-15101028-0 Profile Picture
    12 on at
    Strangley, it seems to have sorted itself out.  I could be a bug, but my has cleared the issue.  Good luck in yours.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 484

#2
Valantis Profile Picture

Valantis 477

#3
Haque Profile Picture

Haque 456

Last 30 days Overall leaderboard