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 blogThe first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
74 | |
22 | |
18 | |
17 | |
13 |
User | Count |
---|---|
126 | |
38 | |
29 | |
28 | |
26 |