Let’s begin with the fundamentals. I created a movement that may set off when the Cost Standing column of a transaction file is up to date to the worth of Despatched. As soon as that’s accomplished, I retrieve the present worth from the related Contact file, increment the entire transaction quantity after which replace the entire transaction quantity on the Contact file.
Let’s begin with the set off. I create an replace set off on the Transactions desk (customized), set the filtering attributes to the column that I need it to set off on, and at last set the Run as triggering person.
I’ve additionally set the Connection Reference to make use of the Service Principal account that I used. In fact there are not any points to this point.
Subsequent, I add logic to retrieve the related contact file (I solely want the transaction quantity column), test if the worth is null and set the worth of the Complete Transaction Quantity within the variable. If the contact file has present worth, I may also increment the variable.
Lastly, I’ll name an Replace motion on the contact file, and set the Complete Transaction Quantity column to the worth of the variable that I set within the earlier step. The ultimate step appears to be like just like the picture beneath.
Now for the check. I ran the check two occasions, and with two totally different outcomes based mostly on some adjustments to the motion that updates the contact file. The record beneath reveals the 2 data that have been up to date within the transaction desk:
The primary time that I ran the method, I used the Service Principal account that I created.
The outcomes on this state of affairs have been that the file that was up to date confirmed that it was modified by the Service Principal account, and never be the person that was set because the Triggering person of the movement. I assume this is smart, as I ought to be capable of inform the system in every motion whether or not I need it to be executed by the triggering person, or by the Service account itself.
Since I don’t actually need to present that this was executed and up to date by the Service Principal account, I wanted to see what needs to be modified to be able to get this working. If we check out the extra choices for the Replace file motion, we see that there’s an choice to Use invoker’s connection. This may principally execute this motion as the identical person account that was set on the set off of the movement. The picture beneath reveals the Invoker’s connection set.
As soon as I modified the second transaction Cost Standing to despatched, I may see that the second up to date file incorporates the proper modified by worth, which is the triggering person.
The subsequent step is to deploy this to a better surroundings, as a part of the answer. As we already know, after we deploy throughout environments, and we have now flows which are utilizing connection references, we have now to supply the connection reference that the movement will use within the larger surroundings. In that case, we might want to create a brand new connection reference in every surroundings and when importing the answer, set it accordingly.
The one factor to note, is that as connection references are nonetheless in preview, there may be at the moment a restrict of what number of flows can use a single connection reference. On the time of penning this, that restrict is 16. I’m fairly positive that by the point that connection references are out of preview, that restrict will change.
I’ll replace this as we discover out new adjustments on connection references.