cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,806)