cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mahipundir
Helper I
Helper I

Sharepoint list, move item data inc attachments to anther list once there is status change

 

Hola PowerUsers, 

I've got a SharePoint list, which gets data after form submission (till here everything works amazingly including adding attachments to item/s) 

I would like to move the whole item from the list1 (inc attachments) once there are changes in the Status (Column) to the List2
List1 and List2 have the same column. 

 

I've tried and getting the error 

when an item is create or modified.PNGIf Get item.PNGcreate item.PNG

 

 Wondering if anyone has done something similar, and like to guide me in the right direction.? 


Looking forward to some PowerUsers power 😄

 

Many thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @Mahipundir 

According to your description, you want to copy the item from list1 to list2 when the item’s status was changed to completed and with attachment.

I set up a Flow, you can refer to:

This is listA, listB has the same column.

vLilyWmsft_0-1626919075339.png
vLilyWmsft_1-1626919075344.png

vLilyWmsft_2-1626919075346.png

vLilyWmsft_3-1626919075351.png

vLilyWmsft_4-1626919075354.png

vLilyWmsft_5-1626919075364.png

vLilyWmsft_6-1626919075370.png

vLilyWmsft_7-1626919075373.png

This is my whole flow.

vLilyWmsft_8-1626919075376.png

When I change the status to completed.

vLilyWmsft_9-1626919075378.png

New item will created in listB

vLilyWmsft_10-1626919075380.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @Mahipundir 

Maybe you made the wrong choice when choosing dynamic content

vLilyWmsft_6-1627010482464.png

Please check whether the selected dynamic content is correct against my screenshot.

vLilyWmsft_7-1627010482471.png

vLilyWmsft_8-1627010482476.png

Below is my complete flow

vLilyWmsft_9-1627010482480.png

vLilyWmsft_10-1627010482487.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-LilyW-msft
Community Support
Community Support

Hi @Mahipundir 

According to your description, you want to copy the item from list1 to list2 when the item’s status was changed to completed and with attachment.

I set up a Flow, you can refer to:

This is listA, listB has the same column.

vLilyWmsft_0-1626919075339.png
vLilyWmsft_1-1626919075344.png

vLilyWmsft_2-1626919075346.png

vLilyWmsft_3-1626919075351.png

vLilyWmsft_4-1626919075354.png

vLilyWmsft_5-1626919075364.png

vLilyWmsft_6-1626919075370.png

vLilyWmsft_7-1626919075373.png

This is my whole flow.

vLilyWmsft_8-1626919075376.png

When I change the status to completed.

vLilyWmsft_9-1626919075378.png

New item will created in listB

vLilyWmsft_10-1626919075380.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hey, @v-LilyW-msft thanks for your quick reply. 

I tried as you have done in your flow, but no luck I'm getting errors please see the attachment.

 

Status 2.PNG

Status 3.PNG

Status 4.PNG

Status 5.PNG

Status Error.PNGStatus Errors.PNG

 

If you check 2nd photo which body should I use there..? 

If you check 4 photos add attachments I couldn't get ATTACHMENTS CONTENT

 

not sure what I'm doing wrong. 


Thank you so much in advance. 

 

Hi @Mahipundir 

Maybe you made the wrong choice when choosing dynamic content

vLilyWmsft_6-1627010482464.png

Please check whether the selected dynamic content is correct against my screenshot.

vLilyWmsft_7-1627010482471.png

vLilyWmsft_8-1627010482476.png

Below is my complete flow

vLilyWmsft_9-1627010482480.png

vLilyWmsft_10-1627010482487.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,742)