question

Agnese-9178 avatar image
0 Votes"
Agnese-9178 asked ·

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

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?

azure-data-factoryazure-sql-database
· 3
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello ,

Just wanted to follow up and check if the below suggestion helped and if you got a chance to provide the feedback , if yes can you please share the link here ?

Thanks & stay safe

Himanshu

0 Votes 0 ·

Hello ,

Since we have not heard back from you so checking if the below suggestion helped and if you got a chance to provide the feedback , if yes can you please share the link here ?

Thanks & stay safe

Himanshu

0 Votes 0 ·
luka80 avatar image
0 Votes"
luka80 answered ·

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.

10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ·

Hello @Agnese-9178 ,@luka80,

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


10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.