cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Receiving inconsistent results with Flow on Sharepoint O365 list

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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-sometim...

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Dual Super User III
Dual Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

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-sometim...

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,872)