Solved: Re: Can I manually set ModifiedBy in my cloud flow

KASCHN · ‎08-25-2022

Problem: I have a child flow that updates records. Because of our ALM process we are using a service principle for the connection references and then the service principle impersonates the user so any records updated in the parent flow are updated by the current user (ie modifiedby = flow current user). However, this current user impersonation does not pass to the child flow. As a result, any records that are updated in the child flow have ModifiedBy = service principle instead of the user.

I thought I might be able to pass the user info to the child flow and then update the ModifiedBy when I update the record. I do not see ModifiedBy as a field I can update in the Update A Row dataverse action so this doesn't seem posible.

Does anyone have any suggestions?

KASCHN · ‎09-03-2022

This was actually the most helpful for me after @Pstork1 's suggestion. Yes you use the 'HTTP' action but you have to first get a token so it is a two step process. I did not end up using this approach as performance is poor. For example, to update 100 rows in a batch approach it took 23 seconds whereas using a loop and the OOB dataverse update a row, it only took 9 seconds. But, since I cannot update modified by using the OOB dataverse update a row action, I will have to try a different approach with my cloud flow connections.

How to – use HTTP Action to call DataVerse / Dynamics 365 Web API in Power Automate – Nishant Rana's...

View solution in original post

Pstork1 · ‎08-25-2022

There is no built in action that will let you set the ModifiedBy property. But you can use a REST call to do it.

#FlowNinja hack 78 - modifying Modified By and Modified time with Microsoft Flow — John Liu .NET

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

KASCHN · ‎08-25-2022

Thanks @Pstork1. I like the concept but I wasn't able to translate this from sharepoint to dataverse action. Do you have an examples of a Dataverse http action to patch?

Should I be using this action? I wasn't sure about the authentication and how to patch multiple. Any guidance or references would be much appreciated.

Pstork1 · ‎08-25-2022

Sorry, I didn't realize it was Dataverse. I don't think there is any way to change it in Dataverse.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

KASCHN · ‎09-03-2022

This was actually the most helpful for me after @Pstork1 's suggestion. Yes you use the 'HTTP' action but you have to first get a token so it is a two step process. I did not end up using this approach as performance is poor. For example, to update 100 rows in a batch approach it took 23 seconds whereas using a loop and the OOB dataverse update a row, it only took 9 seconds. But, since I cannot update modified by using the OOB dataverse update a row action, I will have to try a different approach with my cloud flow connections.

How to – use HTTP Action to call DataVerse / Dynamics 365 Web API in Power Automate – Nishant Rana's...