Forum Discussion

Laiq_Rahman's avatar
Laiq_Rahman
Icon for Helper I rankHelper I
1 year ago
Solved

Need to collect Lookup column values into a variable

Hi,

 

I am trying myself familiar with microsoft fabric. I am using lookup activity to collect a column records into a variable as array. For eg: If a column "Fruit" has orange, apple etc, Then my variable activity should collect those information. Can i get help on this?

Pipeline
  • KNP's avatar
    KNP
    1 year ago

    Have you tried using the Set Variable action?

     

     

5 Replies

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    1 year ago

    Have you tried using the Set Variable action?

     

     

    • Laiq_Rahman's avatar
      Laiq_Rahman
      Icon for Helper I rankHelper I
      1 year ago

      Yes.. it's working. thank you. I'm stuck with another issue. It's suggest copy data activity is only possible through enable staging => External but not sure how to configure. We don't have blob or azuredatalake gen2. 

      • KNP's avatar
        KNP
        Icon for Super User rankSuper User
        1 year ago

        I'm not sure as I usually go to a Lakehouse, so not necessary.

        But have you looked at these settings?