Mapping Share Point Lists via Look Up function and bringing in information from multiple choice columns

Question

Mapping Share Point Lists via Look Up function and bringing in information from multiple choice columns

Dimitrova,Mariya 21

I have created 2 Share Point Lists - List A and List B. Column A has a column with multiple choice information. I want to bring in the information from the multiple choice column into List B. I tried using the Look Up function but it does not give me the option to bring in the multiple choice information. How can I bring in information that was populated through multiple choice information? From what I am seeing, it allows me to select columns only that are single text.

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Renjie Sun-MSFT 2,861 Microsoft Employee

Hi @Dimitrova,Mariya ,

Surely that we create list relationships by using lookup columns.

However, lookup column does not support all column types. Single line of text, choice (single value), number, currency, date and time, lookup (single value), person (single value) are supported.
More information about lookup column limitation.

You mention that your column in listA has multiple choice information. If your column type is Choice or Multiple lines of text, with multiple values, it cannot be lookup.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Dimitrova,Mariya 21 Reputation points

2022-11-08T13:29:09.137+00:00

That's good to know. Thank you! Is there another function that I can use to map the 2 lists and bring me the information from the multiple choice column? Thank you!
Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee

2022-11-09T07:41:50.17+00:00

Hi @Dimitrova,Mariya ,

Thanks for the reply.
This is not possible with conventional methods。

As a workaround, you could transfer your choice column to 'Single line of text', and then lookup this text column in ListB.

You could transfer by creating a flow in ListA.

Here is a flow template:

Answer 2

Dimitrova,Mariya 21

Thank you!

Share via

Mapping Share Point Lists via Look Up function and bringing in information from multiple choice columns

1 additional answer

Your answer