Azure Data Factory import lookup fields with options "Allow Multiple Values" ON from Sharepoint Online List

Question

I need to import data from Sharepoint online list using Azure Data Factory in SQL Azure DB. The share point online list contained a fields of Lookup type, with options "Allow Multiple Values" ON.
I use Azure Data Factory as tool to copy data from SP to Azure SQL DB. If field is a normal lookup field, i have no problem and i import his value. If field is a lookup field with options "Allow Multiple Values" ON, i have problem and i don't see the field in mapping, so i can't import. I search in documentation but i don't find nothing to highlight this case.

Is there a way to import SP lookup field with options "Allow Multiple Values" ON with Azure Data Factory?

Answer 1

The official document mentions that Azure Data Factory can copy the data of the SharePoint Online look up column, but it does not mention how to copy the multiple value look up column.

Anyone who can solve this problem?

L.

Answer 2

Hello @Agnese ,@Luca Di Odoardo ,

Thanks for the question and using the forum .

The fields with “Allow Multiple Values” will be treated as complex type which are not supported currently.

We would suggest you to add the feedback here .All of the feedback you share will be monitored and reviewed by Azure data factory Microsoft engineering team.

Once you have added the feedback , please share that here , so that other community members can upvote that .

Please do let me know if you have any further queries .

Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 3

Does Azure Data Factory support Allow Multiple Values fields yet?