cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashokpershad
Kudo Kingpin
Kudo Kingpin

Choices column not showing from lookup table

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 ?

ashokpershad_0-1668661367647.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @ashokpershad ,

 

I made a sample for you.

vxiaochenmsft_0-1668669167043.png

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

vxiaochenmsft_1-1668669198926.png

 

Best Regards,

Wearsky

View solution in original post

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @ashokpershad ,

 

I made a sample for you.

vxiaochenmsft_0-1668669167043.png

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

vxiaochenmsft_1-1668669198926.png

 

Best Regards,

Wearsky

@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
Community Support
Community Support

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,095)