Hi all,
I have created two lists in SharePoint: List A and List B (which will be the "master database").
This is what I want to create via PowerAutomate (FLOW):
When an action (item in List A) is completed, one can set the status of this action to "Fully Completed" in a specific column. Once this is done, the whole item should be copied, transferred to List B (master database) and can then be deleted in List A. The two list contain different columns. I provided two screenshots below. Screenshot 1 (List A, with Action Status on the right) and Screenshot 2 (List B, master database).
List A
List B
If anyone could help me out, I would be very thankful!
Hi @lennart0909
Follow the below steps:
1. Create a trigger called "When an Item is created or modified"
2. Check the status with an IF condition whether it is completed
3. Under the Yes condition add a "Create Item" action step
4. Map the relevant values from your trigger
5. Finally use the Delete Item to delete the record. Here pass the id from your trigger.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsDive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
35 | |
34 | |
27 |
User | Count |
---|---|
39 | |
38 | |
34 | |
31 | |
25 |