Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Receiving inconsistent results with Flow on Sharepoint O365 list

(0) ShareShare
ReportReport
Posted on by 10

I currently have an automated Flow that has been created for a O365 Sharepoint list that is giving inconsistent results.  The flow is setup to trigger upon a new or modified Sharepoint item and then look at a condition for a field to see if it is not Null.  The flow is to then take the entry from a Multiline appended field and copy the entry to a different Multiline field that is not set to append.  This is being used for the purposes of capturing all of the history in a hidden field so the list can be exported with all entries when needed, as well as so that we can easily see the details in some Views within Sharepoint.

 

The results that I am receiving are inconsistent in that sometimes it puts the Date, Name of the person who entered and the text.  Then sometimes it only puts the entry of the text.

 

On top of this, I have some instances where the Flow is "skipped" and nothing happens.  I havent been able to find any guidance on what causes a Flow to skip.

 

Anyone have some thoughts?   Below is an example of the results and my Flow.

2020-02-10 20_42_35-Clipboard.png2020-02-10 20_35_26-Clipboard.png2020-02-10 20_36_05-Clipboard.png

  • Verified answer
    v-bacao-msft Profile Picture
    on at
    Re: Receiving inconsistent results with Flow on Sharepoint O365 list

     

    Hi @cmaly1 ,

     

    From this post, you seem to have found a workaround to solve your problem.

    https://powerusers.microsoft.com/t5/Using-Flows/Receiving-inconsistent-results-with-Flow-and-sometimes-it-skips/m-p/470162#M11992

    The problem you encountered is really tricky, because as long as When an item is created or modified and Update item action are configured in the same Flow, the infinite loop mentioned by @efialttes will appear.

    A super user wrote a blog to solve this problem, please refer to it and see if it helps:

    https://o365scott.blog/2019/12/18/stopping-infinite-loops-when-updating-sharepoint-list-items/

     

    Best Regards,

  • efialttes Profile Picture
    14,756 on at
    Re: Receiving inconsistent results with Flow on Sharepoint O365 list

    Hi

    Not sure it will help you to fix the issue, but my suggestion when updating the item is to explicitly force column Value 'Next steps' to an empty string value. IF you leave it black, its previous value will be kept and I guess your flow will be triggered again, thus getting into a neverending loop.

    Hope it helps

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,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow