Hi I have a Flow that in one action I get a row from a Dataverse Table that has a field that is a lookup field - so it links to another table. In that Get Row action I use the following filter: cr4e0_EstimateID/cr4e0_scopeidtxt eq 'EstimateID'. EstimateID is a variable that is passed into the flow as an ID. So in this oData cr4e0_EstimateID is the Schema name of the column in Dataverse and cr4e0_scopeidtxt part is the logical column name in the target lookup table. This Get Row filter works perfectly fine with no issues. Now I am trying to add a new row, to the exact same table, and I need to populate the same exact column in the new row, with the exact same Estimate .... so I have put the exact same formula in the EstimateID field in the Add Row Action in the flow. But the same exact oData reference now throws an error. What gives??? I have tried several variations, thinking that maybe I don't need the schema name, and just need the logical field from the target table? But that hasn't been the case. Any help is appreciated. I am attaching a screen shot in case it helps.
This filter works:
This Add Row does not work:
What am I doing wrong? Considering that I kinda see a reference to the linked table, I also tried just: cr4e0_scopeidtxt and /cr4e0_scopeidtxt thinking maybe I no longer need the reference to the schema table? I also tried the logical name of the field which is: cr4e0_ScopeIDtxt. None of these have worked! What am I doing wrong? Please help! Thanks!
