Azure Logic app not reading all columns of Sharepoint list

Nidhirao 1 Reputation point
2021-06-22T18:24:34.507+00:00

We have a logic app that reads from the Sharepoint list. The issue is SharePoint list has 170 columns whereas the logic app only reads 105 columns consistently. I had an issue with fewer rows being read from the SharePoint list as well(99 vs 546). I got around that issue by specifying the "Top Count" parameter in the 'Get Items' action of Sharepoint. Wondering if there is a workaround to read all columns. I have already tried the pagination option and it does not work

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,839 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,607 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Mike Urnun 9,666 Reputation points Microsoft Employee
    2021-07-01T01:59:29.647+00:00

    Hi @Nidhirao - I confirmed with the Connecter team that the SP connector doesn't impose any limits on the number of columns that can be pulled in. However, there may be certain types of columns that are filtered out. In order to investigate further, we will need a workflow run ID and analyze the logs to determine which columns were filtered out -- if you're able to provide a workflow run ID, please let me know and I'd be happy to help.