I am building a flow that pulls data from Dynamics using a trigger that pulls data when we get an Insert or an Update in dynamics. I then query my sql table using the ID from the trigger to determine if the row is in the table or not. If the row is in the table I send the row down an Update path and if it is not in the table it goes down an Insert path. Here is the flow.
The flow however fails on the insert. The condition seems to be the cause of the problem. I am using this code
Could you please share a full screenshot of the configuration of the "Insert Asset Stage" action in the flow?
Could you please share the full error message of the "Insert Asset Stage" action when the action run failed?
Please share more details so we would try to provide a proper workaround for you.