
Announcements
Hello!
I am trying to create a flow for my SharePoint list. What I would like to happen is when 'STATUS' value = 'Complete', that item will automatically transfer from this list to another list I have created as a repository. I've been trying, but I can't quite seem to get it to work. Help!
Thank you!
Hi Nicole,
Are you able to show us what you have so far?
All you'll need to do is create a flow using the "When an item is modified" trigger. Then, go into its settings, and use the trigger condition " @equals(triggerBody()?['Status'],'Complete') -- that means it will only trigger when this is true.
Then, you'll use a Create Item action pointing to the repository list, and use Dynamic Content from your trigger action to populate it. Then you can delete or archive the item that triggered it.
if you're not familiar with Dynamic Content - if you click into a field, you'll see a dropdown with 2 tabs - dynamic content and expressions. Dynamic content pre-populates values from data that you're interacting with, like the SharePoint list item that triggered it.
Check this out as well:
https://normyoung.ca/2020/10/01/use-power-automate-to-move-microsoft-lists-items-to-another-list/