Forum Discussion
Torbjrn
Feb 21, 2023Copper Contributor
Data from 365 list
I need to export data from a Sharepoint list to an Excel file. The Sharepoint list is located on a site belonging to an organization which I have access to through a user ID. After clicking the «Expo...
SergeiBaklan
Feb 21, 2023Diamond Contributor
iqy defines how to import data from SharePoint and how to sync it. With another account it can't sync and give such error. You need to use account which has access to SharePoint.
- TorbjrnFeb 21, 2023Copper Contributor
I have now logged on my Microsoft 365 with the userID I use in the organization holding the list I want to export from. Unfortunately that did not help. I got the same error message.
Any other ideas?
- SergeiBaklanFeb 21, 2023Diamond Contributor
Do you have access to SharePoint from that computer? If so you may try to generate another query from scratch to check if it works.
- TorbjrnFeb 21, 2023Copper ContributorI do have access to Sharepoint from my PC through the userID I use in the organization. It is I who created the Sharepoint list. I have tried many times to export the list data to Excel. Is that what you mean by "generate another query from scratch"?