cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmaly1
Frequent 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
v-bacao-msft
Community Support
Community Support

 

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
efialttes
Super User
Super User

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!



v-bacao-msft
Community Support
Community Support

 

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,442)