Generate CSV containing Lookup columns

I have a question about the Generate CSV action.
In this action, the Computed Column (e.g. Lookup column with a single value Lookup from Relation) is not output to CSV.
Is there a way to include the Lookup column in the output CSV?

Hi,

Computed columns are not included in the CSV. Not sure if it’s the case for all of the computed columns type though.

1 Like

image

Have you tried using “Select columns” here? I just tested and my lookup column does show in the list and I can include it with a check.

2 Likes

EDIT: Just tried again @ThinhDinh and you were right I have the computed values in the CSV, always thought it was not included :melting_face:

On my side yes it appears on the list but the data from computed columns are not exported in the CSV so I always assumed it was normal behavior?

2 Likes

Wow!
I never realized there was a “Select Columns” option!
Thanks to your guys’ advice, I was able to solve this problem perfectly.
Thanks so much @ThinhDinh and @Lucas_Malguy1 for the advice!

Hi, ThinhDinh! How you have configured your lookups. I tried and no luck.

It’s a simple single relation + lookup. Nothing special there. Do you not see those columns in the “select columns” screen?

1 Like

Ah, yes, bit confusing. Just i was thinking about Lookup as an array that’s why was curious to know it possible to use in csv source. As single value it is clear. Thanks!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.