Choices column not showing from lookup table

[ashokpershad]

I have two tables Element & "CE Plans"

Table Element has Name (text), Number (wholenumber), Owner (lookup), UID (autonumber) and Email(text) columns.

Table "CE Plans" has a column ElementNumber which is lookup from table Element. 

When I add table "CE Plans" in form and want to show ElementNumber column with Table Element's Number column it's only showing following columns in dropdown - Name, Email and UID. It is not showing Number column and Owner columns. Any idea how to show these two more columns ?

[v-xiaochen-msft · Accepted solution]

Hi @ashokpershad ,

I made a sample for you.

AddColumns( TestL16,"tempNumber",Text( Number1),"tempOnwer",If( IsType(Owner,Users),AsType(Owner,Users).'Full Name',AsType(Owner,Teams).'Team Name'))

Best Regards,

Wearsky

[ashokpershad]

@v-xiaochen-msft Thanks for the formula but could you please clarify why we are not getting that column in list when other columns are ?

[v-xiaochen-msft]

Hi @ashokpershad ,

I think it doesn't support Number and owner field. So I use addcolumns() function to create 2 virtual columns and convert them to text field.

Hope it helps.

Best Regards,

Wearsky