Hi!
I would like to access sharepoint lists with my workflow. The Connection with the credentials of the enterprise was successful, but when I try to get many items or any item, I only get metadata of the list, like when the entry was created but the “fields” column is an empty object and I don’t get any actual information from the list entries. Anybody encountered this problem?
Many thanks for your help!
Hi, FabianAlterndorfer!
This happens because Sharepoint list item fields aren’t returned default.
You must explicity expand or select “fields” object when retrieving list items. Otherwhise, Grafh only returns matadata and empty.
In the SharePoint node:
Make sure list items are queried with “fields” expanded or selected
Confirm the user has permission to read the list columns
Documentation:
https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.microsoftsharepoint/
https://learn.microsoft.com/en-us/graph/api/resources/listitem
If this solves the issue, please mark this reply as the solution.