cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MoEdu
Helper III
Helper III

copy items inc attachments from one list to another based on a condition

Hello

 

I have created a flow with a condition whereby where there are any items in the existing list that is set to 'Yes' to create those items in new list and to also copy over the attachments

 

Could anyone please tell me where I am going wrong as the condition is not being fulfilled and the items are not being copied over to the new list

 

MoEdu_0-1611782082444.png

MoEdu_0-1611783069523.png

 

 

 

4 REPLIES 4
Ler
Advocate I
Advocate I

hi @MoEdu 

 

i guess your SharePoint item set is not text entry, maybe you used check options like "yes or no"

so you can try "true" instead of "yes"

that is working for me if i use "true"

2021-01-28 12_11_02-编辑你的流 _ Power Automate 和另外 8 个页面 - 工作 - Microsoft​ Edge.png

2021-01-28 12_11_41-运行历史记录 _Power Automate 和另外 8 个页面 - 工作 - Microsoft​ Edge.png

2021-01-28 12_12_21-运行历史记录 _Power Automate 和另外 8 个页面 - 工作 - Microsoft​ Edge.png

I hope it helps.

 

BR

Ler

v-duann-msft
Microsoft
Microsoft

Hi @MoEdu 

 

Thank you very much for posting.

 

Accordingly to your screenshots, it looks like the condition couldn’t make you find ‘Yes’ result and start the yes branch.

 

If that’s the case, please kindly share me your SPO list if necessary and check condition again. In condition area, whether you selected “items('Apply_to_each')?['columnname/value']” or just “items('Apply_to_each')?['columnname’]”. This part is quite important to determine whether you get the value of this column or not.

v-duann-msft_0-1611818332251.png

 

 

I tested with no issue. Here is my flow for your reference:

v-duann-msft_1-1611818332263.png

 

 

v-duann-msft_2-1611818332266.png

 

 

To move attachments to another list, you could also refer :

https://powerusers.microsoft.com/t5/General-Power-Automate/Copy-attachments-from-one-SharePoint-list...

 

Hope the content above may help you.

 

Thanks

Anna

MoEdu
Helper III
Helper III

@v-duann-msft @Ler thank you

 

It was a yes/no check box, I tried Yes and true it still would not work I have now deleted the check box and created a choice menu called 'Migrate to' which has the value 2020 in it

 

so the flow should only move the items which have 2020 against them to another list but the flow still does not work

 

within the list i have items for the year 2019 and 2020, 2019 items should remain in that list and the 2020 items in the list need to be copied over to another list

 

MoEdu_0-1611821167771.png

MoEdu_1-1611821253453.png

 

 

Hi @MoEdu 

 

Thank you for your further update.

 

Could you please try to change expression in condition to : items(‘Apply_to_each’)?[‘Migrate/Value’]

 

Here are similar scenario for your reference:

https://powerusers.microsoft.com/t5/General-Power-Automate/Move-attachment-from-one-list-to-another/...

https://powerusers.microsoft.com/t5/General-Power-Automate/Copy-SharePoint-Lists-attachments-to-a-Sh...

 

Hope it helps.

 

Thanks

Anna

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (42,756)