Power Platform Community Forum Thread Details

Update SharePoint item sets incorrect modified by field

Hi!

I have a flow that triggers when items in a SharePoint list is created or modified. At the end of the flow, the flow sets the status of the SP item to completed. Now, this means that the flow will trigger again (because it is modified) and that the user account that is being used for connection will (incorrectly) be set as "Modified by". This seems pretty basic, in SP Designer workflows did not trigger themselves and any modifications to SharePoint items was logged as modified by "workflow on behalf of user X". Much much better. What to do in Flow in order to:

1. Not trigger workflow indefinitely by themselves?

2. Get "Modified by" to the correct user, that is, the one that started the flow?

Regards,

Helena

I too have run into issues with the 'When item is created or modified' trigger. To work around the issue I was facing, I had to get really creative. Not sure it it fits your use case, but I had much better luck with a Schedule trigger. This was due to the fact that I didn't need the item to be updated in real time. So, I scheduled a flow to run once a week (day, minute, and second are options too) and get all items from a list that needed to be updated, then did an apply to each on the list items returned. This saved the amount of flow runs per month I used (I have a 2000 per month limit), as well as eliminates the repeating flow runs.

I don't know of a way to set modify by to anyone but account used in the SharePoint connection. I did find that when you share your flow with others in your org, it will ask them to update all the connections to their own. This would require them to complete the trigger action... which I don't know if scheduling would do. You could also look at a manually triggered flow in the list using a "For a Selected Item", but I understand this is less than ideal and users will forget to do it.

Hope this at least gets you thinking outside the box...

Quick Links