Hi,
I am trying to create a new power Automate for handling work orders.
The concept is that on the creation of a work order in the work order table (cr318_sagemworkorders), it will create some records in a linked table (cr318_sdeworkorderpicklists).
I have a trigger on the cr318_sagemworkorders table
then later in the code I have a add new record on the cr318_sdeworkorderpicklists table:-
in the field for the link to the work Order I have put in the SageM Work Order unique ID
using the dynamic content:-
however when I run it I get the following error:-
but if you look at the work order data then this is the correct reference number, and it does exist.
I have also tried using the work order field and that came with the same error message (but with WO021113 instead)
When I have created the record manually and then looked that the Pick list table. it has that same reference code:-
it feels like I have made a simple mistake, but I can't find the flaw in my logic.
Troy
