'Get File Content' step with sharepoint connection in the logic app

M.K 0

Hello,

I’m trying to retrieve an Excel file from SharePoint and generate a copy of it on a file server. While a file is successfully generated, some rows from the original Excel file are consistently missing in the output. What could be causing this issue? The original files are only around 16KB in size.

User's image

Khadeer Ali 1,400 Reputation points Microsoft Vendor

2024-12-16T19:39:16.0533333+00:00

@M.K ,

Welcome to the Microsoft Q&A Platform! Thank you for reaching out regarding your query on 'Get File Content' step with SharePoint connection in the logic app.

Could you try disabling the "Automatic decompression" option.

If automatic decompression is enabled, the connector might try to decompress the content, causing corruption or incomplete data retrieval for non-compressed binary files like Excel files.

If the issue still persists, please let us know for any additional troubleshooting steps are needed!
M.K 0 Reputation points

2024-12-16T20:15:22.7733333+00:00

Hi @Khadeer Ali Thank you so much for your suggestion. I disabled 'Automatic decompression', but am still encountering the same issue.

The above is the original excel file, and the below is the excel file created by this step

1 answer

Khadeer Ali 1,400 Reputation points Microsoft Vendor

2024-12-16T22:50:15.4433333+00:00
@M.K ,

There might be few scenarios where some rows are missing when retrieving the Excel File form SharePoint.

The file might still be locked or open, leading SharePoint to serve a cached or incomplete version.

There could be a format or encoding issue causing Logic Apps to misinterpret parts of the file.

To rule out retrieval issues, we can try fetching the file using 'Get File Content Using Path', which ensures we reference the correct version explicitly. Before this use a Compose action or log the raw content from Get File Content before creating the file. This will confirm if the issue is during retrieval or file creation.
Please sign in to rate this answer.

2 people found this answer helpful.
M.K 0 Reputation points

2024-12-18T11:12:26.4266667+00:00

Hi @Khadeer Ali Thank you so much for your help! After investigating, I discovered that the issue was caused by the file being locked or opened during earlier steps, as you suggested. To resolve this, I created a separate Logic App dedicated solely to reading the files and regenerating them on the file server, and it worked perfectly. I truly appreciate your assistance!

Khadeer Ali 1,400 Reputation points Microsoft Vendor

2024-12-19T16:46:02.17+00:00

M.K,

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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

'Get File Content' step with sharepoint connection in the logic app

1 answer

Your answer