Update manager field in a sharepoint list when item is created or modified trouble

[Gti182]

Hi all, 

I'm having some trouble with the following flow. I'd like it to trigger once a user creates a new item or edits an existing item in a sharepoint list.

I've managed to get the flow to do what I need it to but it seems to trigger at random times and runs through all items in the list rather than a single item when it's created or edited. This seems to trigger even when no changes are being made.

SharePoint List example (column 4 to be populated):

Flow run history (it runs through all 3 test rows at indeterminate times):

Flow:

To note: I created above with automated cloud flow not instant cloud flow not sure if this might be the reason

[v-jefferni · Accepted solution]

Hi @Gti182 ,

In your flow there is an Update item action, it updates item in the list but will trigger the flow as well. This is so called infinity loop. To solve this problem, please add a Text column into the list (name it "Edited"), default value set to No, and then in your flow you need to add a trigger condition for the trigger and also set this column to Yes in Update item action. And note that you need Email rather than Display Name in below expression.

trigger condition expression:

@equals(triggerOutputs()?['body/Edited'],'Yes')

Update item:

concat('i:0#.f|membership|', EmailDynamicContent)

Best regards,

[Gti182]

thanks, that makes sense. This above solution sounds interesting will try give it a go