Forum Discussion

Mr_Coffee's avatar
Mr_Coffee
Frequent Visitor
4 months ago
Solved

how to Dynamically set connection GUID from variable array

  Hey All,  I am trying to dynamically pull the connection GUID from an array variable.  My setup is as follows:  I am using a lookup activity that pulls a single row of data from a SQL Table. ...
Pipelines
  • nilendraMS's avatar
    nilendraMS
    4 months ago

    the real issue is connection GUID field simply does not support dynamic expressions in Fabric

    Try this plz

     

     

    after your foreach, add a Set Variable activity and do:

     

    @variables('pl_metadata')[0].copy_job_connection_id

    store it in a simple string variable, then use that in Copy activity

     

    ir try skip the append variable altogether and just reference lookup output directly in your set variable

nilendraFabric's avatar
nilendraFabric
Super User
4 months ago

the real issue is connection GUID field simply does not support dynamic expressions in Fabric

Try this plz

 

 

after your foreach, add a Set Variable activity and do:

 

@variables('pl_metadata')[0].copy_job_connection_id

store it in a simple string variable, then use that in Copy activity

 

ir try skip the append variable altogether and just reference lookup output directly in your set variable