cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helena1
Level: Powered On

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

1 REPLY 1
Highlighted
jSteige
Level: Powered On

Re: Update SharePoint item sets incorrect modified by field

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 426 members 5,197 guests
Please welcome our newest community members: