question

Nidhirao-8268 avatar image
0 Votes"
Nidhirao-8268 asked MikeUrnun commented

Azure Logic app not reading all columns of Sharepoint list

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

office-sharepoint-onlineazure-logic-apps
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Nidhirao-8268 - I will review and share my findings here soon.

0 Votes 0 ·

1 Answer

MikeUrnun avatar image
0 Votes"
MikeUrnun answered MikeUrnun commented

Hi @Nidhirao-8268 - 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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Nidhirao-8268 - Just checking in here, let me know if you're able to provide workflow ID and we can dig in for more clarity.

0 Votes 0 ·