Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Flow sharepoint create item more than 1 time

(0) ShareShare
ReportReport
Posted on by 8
 

Hello

 

I have a flow than according to certain conditions in a SharePoint list update a different SharePoint list. I have several "IF" to ensure that the SharePoint item is only copied 1 time, but for some reason, on a random occasion, some items are copied more than 1 time.

 

Any thoughts?

 

I look forward to your comments.

 

Best regards

  • eliu_gaytan Profile Picture
    8 on at
    Re: Flow sharepoint create item more than 1 time

    @rsaikrishna 

     

    It is a production environment, and I made different tests to reproduce the problem without succeeding.

    As a matter of fact, I made a ticket with Microsoft to ask for help because I believe it is related to the flow itself (if it is not I want to know where exactly is the error).

     

    Let me know if you have other ideas.

     

    Best regards

  • rsaikrishna Profile Picture
    3,703 on at
    Re: Flow sharepoint create item more than 1 time

    @eliu_gaytan 

     

    Looks like there is issue in the flow conditions. They need to be reviewed very closely by observing the random items created in the target list. 

     

    If this is not a production environment, I would recommend creating an item and checking it how many times it is copied to the target list. Repeat the test of creating new items with all the scenarios till you observe the issue. Once you observe the issue, check the flow execution results. 

     

    If this is production environment, create new lists with same schema and make a copy of the flow in your test environment to reproduce the issue.

     

    I tried to figure out but without insight into actual flow conditions and execution results, it is very hard to help remotely. I hope, I was able to help you with my recommendations.

  • eliu_gaytan Profile Picture
    8 on at
    Re: Flow sharepoint create item more than 1 time

    @rsaikrishna 

     

    Yes, I have an infinite loop, but that condition is needed for the tool(because of the nature of how we are using the tool internally).

    I used the method of Melissa Hubbard and it should work, but sometimes randomly it doesn't work.

     

    Let me know your thoughts.

     

    Best regards

  • rsaikrishna Profile Picture
    3,703 on at
    Re: Flow sharepoint create item more than 1 time

    Looks like your flow is getting triggered many times as you have "SharePoint List Item Created or Modified" trigger and you are updating the same item inside the flow.

     

    Here is the blog to prevent infinite loop: 

    https://powernimbus.com/2019/06/microsoft-flow-avoiding-the-sharepoint-list-update-trigger-infinite-loop/

     

    There is another post talks about same or similar issue:

    https://powerusers.microsoft.com/t5/General-Power-Automate/Update-Item-Infinite-Loop/m-p/252742 

     

    Please see if this helps you to fix the issue.

  • eliu_gaytan Profile Picture
    8 on at
    Re: Flow sharepoint create item more than 1 time

     

     

     

    @rsaikrishna 

     

    The whole flow work in this way:

    Is monitoring the change on a list of Sharepoint and when a condition is met (specific value in a column) it triggered different actions. One of those actions is to copy items(records) from that Sharepoint List to another. I have a lock to prevent copying more than one time the records. (when copy the item it change the value of a specific column to identify which one are been copied) The problem is even with that logic is still copieng the records more that one time randomly.

     

    Let me know your thoughts.

     

    Best regards

     

     

    Bug copy itemsBug copy itemstooltool

  • rsaikrishna Profile Picture
    3,703 on at
    Re: Flow sharepoint create item more than 1 time

    @eliu_gaytan 

     

    You gave the link to your tenant. I prefer to see screen shots and details of the issue.

     

    Regards

    Krishna

  • eliu_gaytan Profile Picture
    8 on at
    Re: Flow sharepoint create item more than 1 time

    Power Automate 

     

    Please find attached the picture.

    I couldn't trace the problem, because the log because is too big.

  • rsaikrishna Profile Picture
    3,703 on at
    Re: Flow sharepoint create item more than 1 time

    Is your issue resolved?

  • rsaikrishna Profile Picture
    3,703 on at
    Re: Flow sharepoint create item more than 1 time

    Hi @eliu_gaytan ,

     

    Can you please share the screen shots of the flow? 

     

    Also, you can check the execution log of the flow for the item which was copied multiple times. The log can provide you some additional details.

     

    Please provide more details to look into it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,708 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,030 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow