How to lookup column in list not showing all possible fields?

How to lookup column in list not showing all possible fields?

Lookup column in list not showing all possible fields Ask Question Asked9 years, 9 months ago Active5 years, 10 months ago Viewed27k times 1

Why is my column not shown in Excel?

I gather that you’re trying to use a lookup to ‘bring in’ additional fields to your current list, but that they aren’t available to select. Some field types are not available for this sort of function. For example, further Lookup fields can’t be brought in. Also, notably and annoying, neither can Choice fields.

Why is the choice column not showing in list?

3 this is a known issue.. even though, Microsoft states here (in the .zip file)that Choice fields are valid lookup fields, it’s not possible to select them column editor. A workaround would be to create a calculated field in ListB and insert the choice column in the formular box.

Is there a way to lookup columns in Excel?

05-15-2018 10:05 AM When it comes to lookup columns you should be able to query them manually. So they don’t show up in the picker but if you use something like That will get the value out. Then you can use something like this to write back to the field.

Why are the lookup columns missing from the DataSource?

I have created SharePoint lists with lookups between. On the list I’m trying to create a Powerapp, when I connect the data connection (or create the app directly from the list) the lookup columns from the list do not appear nor can I find them in the data connection’s list of data cards.

How to use the lookup column in Excel?

The second list keeps track of meeting actions. Among other columns, each item in the action list contains a reference to the meeting the action was assigned in. I am able to use the lookup column feature to do this; I am also able to pull in the date of the meeting.