- I have 2 Dataverse Tables Pre User and User.
- Both the tables contain Created By column which is a lookup to User Table.
- First data will be added to Pre User Table and then flow is run to add the data from Pre User table to User Table.
- The problem I am facing is when Created By name is getting added to User Table it is getting changed to user name who has created the flow, i need the Created By name in User Table to be same as Pre User Table.
- For Example in Pre User Table if Created By is Jayakanth after flow is run and data is added to User Table Created By is getting changed to Sharath who is the flow owner.
- I also tried changing the Run as option in flow to Modifying User but still the same problem.
I need help in resolving this issue