Issue with Dynamic List Name in SharePoint to Azure DataLake Synapse Pipeline

Question

Issue with Dynamic List Name in SharePoint to Azure DataLake Synapse Pipeline

Sakshi Deshpande 20

Hello,

I’m currently working on building a data pipeline to copy SharePoint Online list data into Azure DataLake. The pipeline uses a Lookup activity to retrieve the list names and a Copy activity within a ForEach loop to process each list.

The pipeline executes successfully when the list name is hardcoded. However, when I attempt to pass the list name dynamically, I encounter the following error:

Requesting response from path SharePointListExample and query $top=10 failed with status code NotFound and message: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> <code></code> <message xml:lang="en-US">Resource not found for the segment 'SharePointListExample'.</message> </error>

It appears that the dynamic list name is not being resolved correctly in the request path. I would appreciate any guidance or suggestions on how to resolve this issue.

Thank you!

Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-13T10:10:27.5166667+00:00
Hi Sakshi Deshpande That error usually means the list name passed dynamically isn’t matching what SharePoint expects. When you get the name from Lookup, make sure it’s the internal name from the list URL (after /Lists/), not just the display name.

In your Copy activity, reference it like:

@item().ListName

(no quotes), and if it has spaces/special characters, wrap it in:

@uriComponent(item().ListName)

Suggest adding a Set Variable before Copy to debug the value. Once it matches the internal URL-safe name, the NotFound should disappear.

For more details, please refer to SharePoint Online List connector docs

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Sakshi Deshpande 20 Reputation points

2025-08-13T10:41:50.0433333+00:00
Hello @Venkat Reddy Navari

Thank you for your prompt response.

This is the dummy link to my SharePoint list:

https://companyname.sharepoint.com/sites/{siteName}/Lists/SharePoint%20List%20Example/AllItems.aspx

The dummy display name for my list is "SharePoint List Example". I have encoded while passing it dynamically. I'm still facing the same error.

When I open the list settings of my SharePoint list, URL bar has this address which contains list GUID:

https://yourdomain.sharepoint.com/sites/sitename/_layouts/15/listedit.aspx?List=%7Babc123-def456-ghi789-jkl012%7D

Also the web address I see is in list settings is:

https://companyname.sharepoint.com/sites/{siteName}/Lists/SharePoint List Example/AllItems.aspx

Note:
When I choose the list name from dropdown in the dataset I'm getting the list name as "SharePointListExample". And the pipeline run is successful.
Sakshi Deshpande 20 Reputation points

2025-08-13T13:59:54.8166667+00:00

The lookup activity is returning the 'SharePointListExample'. It is exactly as shown in the dropdown.

Without encoding as well, the pipeline is throwing the same error.

I have tried with GUID as well. But I'm facing the same issue.

Any help with the setup will be deeply appreciated.
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-13T14:26:56.3133333+00:00

Sakshi Deshpande I kindly request you to provide the details mentioned in the private message so we can identify the root cause and address the issue effectively.
Sakshi Deshpande 20 Reputation points

2025-08-13T16:24:46.61+00:00

Sure.
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-15T04:20:38.3266667+00:00

Sakshi Deshpande We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sakshi Deshpande 20 Reputation points

2025-08-16T04:36:45.28+00:00

Hello,

The information you asked for is sensitive to the company. All the details I have provided in the previous comments are all the information I can provide.
Smaran Thoomu 29,415 Reputation points Microsoft External Staff Moderator

2025-08-18T16:53:48.7133333+00:00

Hi Sakshi Deshpande
To look into your issue further, we'll create a support ticket. This allows us to collect more detailed information, so please provide the requested details in the private message, as it can be viewed securely. We understand your concern, and Microsoft Q&A offers a private message feature you can use. Our engineers will start a private conversation with you, and you can find more information about this feature here. If deeper troubleshooting is needed outside the Microsoft Q&A platform, we'll continue with you via email or phone.

Accepted answer

0 additional answers

Your answer

Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-13T10:10:27.5166667+00:00

Hi Sakshi Deshpande That error usually means the list name passed dynamically isn’t matching what SharePoint expects. When you get the name from Lookup, make sure it’s the internal name from the list URL (after /Lists/), not just the display name.

In your Copy activity, reference it like:

@item().ListName

(no quotes), and if it has spaces/special characters, wrap it in:

@uriComponent(item().ListName)

Suggest adding a Set Variable before Copy to debug the value. Once it matches the internal URL-safe name, the NotFound should disappear.

For more details, please refer to SharePoint Online List connector docs

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Sakshi Deshpande 20 Reputation points

2025-08-13T10:41:50.0433333+00:00

Hello @Venkat Reddy Navari

Thank you for your prompt response.

This is the dummy link to my SharePoint list:

https://companyname.sharepoint.com/sites/{siteName}/Lists/SharePoint%20List%20Example/AllItems.aspx

The dummy display name for my list is "SharePoint List Example". I have encoded while passing it dynamically. I'm still facing the same error.

When I open the list settings of my SharePoint list, URL bar has this address which contains list GUID:

https://yourdomain.sharepoint.com/sites/sitename/_layouts/15/listedit.aspx?List=%7Babc123-def456-ghi789-jkl012%7D

Also the web address I see is in list settings is:

https://companyname.sharepoint.com/sites/{siteName}/Lists/SharePoint List Example/AllItems.aspx

Note:
When I choose the list name from dropdown in the dataset I'm getting the list name as "SharePointListExample". And the pipeline run is successful.
Sakshi Deshpande 20 Reputation points

2025-08-13T13:59:54.8166667+00:00

The lookup activity is returning the 'SharePointListExample'. It is exactly as shown in the dropdown.

Without encoding as well, the pipeline is throwing the same error.

I have tried with GUID as well. But I'm facing the same issue.

Any help with the setup will be deeply appreciated.
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-13T14:26:56.3133333+00:00

Sakshi Deshpande I kindly request you to provide the details mentioned in the private message so we can identify the root cause and address the issue effectively.
Sakshi Deshpande 20 Reputation points

2025-08-13T16:24:46.61+00:00

Sure.
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-15T04:20:38.3266667+00:00

Sakshi Deshpande We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sakshi Deshpande 20 Reputation points

2025-08-16T04:36:45.28+00:00

Hello,

The information you asked for is sensitive to the company. All the details I have provided in the previous comments are all the information I can provide.
Smaran Thoomu 29,415 Reputation points Microsoft External Staff Moderator

2025-08-18T16:53:48.7133333+00:00

Hi Sakshi Deshpande
To look into your issue further, we'll create a support ticket. This allows us to collect more detailed information, so please provide the requested details in the private message, as it can be viewed securely. We understand your concern, and Microsoft Q&A offers a private message feature you can use. Our engineers will start a private conversation with you, and you can find more information about this feature here. If deeper troubleshooting is needed outside the Microsoft Q&A platform, we'll continue with you via email or phone.

Answer 1

Venkat Reddy Navari 5,815 Microsoft External Staff Moderator

Sakshi Deshpande the value SharePointListExample you see in the dataset dropdown is the internal API name the connector expects. If your Lookup is returning "SharePoint List Example" (with spaces), even URL-encoded, the connector won’t match it.

Try having your Lookup return the internal name exactly as shown in the dropdown (SharePointListExample) and pass that directly to the dataset parameter (no encoding).

Alternatively, you can pass the list GUID from SharePoint the connector can resolve that without worrying about spaces.

Once the dynamic value matches the internal API name or GUID, the NotFound error should go away.

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Sakshi Deshpande 20 Reputation points

2025-08-19T05:43:28.3866667+00:00

Hi,

Thanks for reaching out. The issue was resolved after several tries with the solution provided.
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-19T06:28:02.6433333+00:00

Hi Sakshi Deshpande Glad to hear the issue has been resolved. When you have a moment, could you please confirm which specific comment or step helped fix the issue? I’ll convert that into a formal answer.
Once it's posted, kindly mark it as Accept Answer and Yes so it can benefit others in the community facing a similar challenge. Thank you!
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator

2025-08-20T07:28:58.7733333+00:00

Sakshi Deshpande Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sakshi Deshpande 20 Reputation points

2025-08-20T07:31:45.1066667+00:00

Cross-checking with the Internal List name helped.

Share via

Issue with Dynamic List Name in SharePoint to Azure DataLake Synapse Pipeline

0 additional answers

Your answer