Create one list item and copy it to another list and create a next available ID number

Kak Tak 11 Reputation points
2023-05-24T08:50:01.6866667+00:00

Hi all,

I am new to power automate and need help with 2 questions. I hope that you guys have wish to help me. We have couple of Sharepoint lists and some of the tasks repeats in them, I mean in every list we have 4-5 tasks that are the same in all lists. 

My questions is how to create item in 1 list and automatically copy it to all lists. I can use When item is created but that will copy every item that I create in a master list.

Next question is regarding ID. We have a column with ID and there we put next available number. If we start tasks with 5000 then new item will have 5001 and so on. Is there a way to automate that so that we don't need to populate it manually?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,251 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
549 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Haoyan Xue_MSFT 22,231 Reputation points Microsoft Vendor
    2023-05-25T06:28:06.67+00:00

    Hi @Kak Tak ,

    Regarding the question of how to create item in 1 list and automatically copy it to all lists, use "When an item is created" as the trigger condition, and then create several corresponding "Create item"action for which lists you want to copy to.

    User's image

    You can also refer to this thread: https://powerusers.microsoft.com/t5/Using-Flows/Copying-one-SharePoint-list-items-to-another-SharePoint-list/td-p/973343

    Also, don't forget to repost another thread of yours, we'll fix it for you quickly.

    Have a nice day!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.