Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Laiq_Rahman
Helper I
Helper I

Need to collect Lookup column values into a variable

‎10-31-2024 03:57 PM

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?

Labels:
Message 1 of 6
608 Views
0
1 ACCEPTED SOLUTION
KNP
Super User
Super User

‎10-31-2024 06:14 PM

Have you tried using the Set Variable action?

 

KNP_0-1730423678511.png

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr		Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

Message 2 of 6
572 Views
0
5 REPLIES 5
KNP
Super User
Super User

‎10-31-2024 06:14 PM

Have you tried using the Set Variable action?

 

KNP_0-1730423678511.png

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr		Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Message 2 of 6
573 Views
0
Laiq_Rahman
Helper I
Helper I
In response to KNP

‎10-31-2024 08:49 PM

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. 

Message 3 of 6
561 Views
0
KNP
Super User
Super User
In response to Laiq_Rahman

‎10-31-2024 09:00 PM

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

But have you looked at these settings?

 

KNP_0-1730433591702.png

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr		Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Message 4 of 6
556 Views
0
Laiq_Rahman
Helper I
Helper I
In response to KNP

‎10-31-2024 09:27 PM

This is what i am doing

Laiq_Rahman_0-1730435173389.png

 

This is the error msg i am getting when i save 

Laiq_Rahman_1-1730435211130.png

 

Message 5 of 6
549 Views
0
KNP
Super User
Super User
In response to Laiq_Rahman

‎10-31-2024 11:00 PM

Sorry I'm not sure how else to get around this. 

Interim lakehouse maybe?

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr		Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Message 6 of 6
528 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

View All
Top Solution Authors
View All