Forum Discussion
sbhan4
Nov 02, 2020Copper Contributor
Copy SharePoint List to the another new site
Hello everyone! I am trying to copy the existing SharePoint online list to another site. Can someone help me with this?
RobElliott
Mar 14, 2021Silver Contributor
Al_B_inPT "boolean logic trigger mechanism of if then statements" : streuth, that's wide of the mark, it's so much more than that. A simple example of the flow is shown below:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
David2480
Jun 14, 2021Copper Contributor
- NEEdANov 03, 2023Copper Contributor
I tried something like this but when created item, I am having issues with choice field.
I am not sure what to define here. By right it should copy value from the list.
- RobElliottJun 15, 2021Silver Contributor
David2480 in this example we're just going to copy the first item in our list, Abla, from the list Almeria L3 to the list called Almeria L4. It has an attachment:
In the flow, the get items action returns a maximum of 100 items by default, so if you are goimng to have more than this you need to go into settings for the get items, switch on the Pagination toggle and set it to the number you need or higher. As I'm only interested on this occasion with 1 item I've added a filter query:
Add an apply to each then add a condition to check wither the item has attachments or not, so the condition is HasAttachments is equal to true
If the item doesn't have attachments you can just add the create item action into the red if no channel:
But if the item has attachments, in the green if yes channel and a get attachments action
Next, add a get attachment content action - it will wrap itself in another apply to each.
Still inside this second apply to each add the create item action. Finally add an add attachment action
The result is as folllows:
Hope that helps.
Rob
Los Gallardos
Microsoft Power Automate Community Super User