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?