Logic Apps Copying Files from Sharepoint folder to Data Lake getFileContent error File not found

Question

Logic Apps Copying Files from Sharepoint folder to Data Lake getFileContent error File not found

Debbie Edwards 521

I'm attempting to copy some files from a Sharepoint folder to a Data Lake and working through some documentation

There are two files in here. an xlsx and a csv. However when i run the logic app it errors.

I don't know if its been deleted hidden or Im not authorised for this specific file but I would like a way I can just skip any file that is File not found and move onto the next one without the error.

The hope is I can then continue and find the files I want to copy into the Data Lake

1 answer

Your answer

Answer 1

MayankBargali-MSFT 70,936 Moderator

@Debbie Edwards Thanks for reaching out. As per the error 404 and looking into the site address of your screenshot the action is getting failed when you are trying to Get File Content on a folder. As it will return the list of folders and files. Either you can add a condition before executing the Get File Content to check if the iterated value is of type folder or not. If it is not a folder then only execute the Get File Content method else skip it as below.

In a scenario where you want to execute the next action if there is any failure in the previous action then you need to handle the exception in your logic app workflow. You can refer to this document for more details on how you can handle the reception in the workflow.

In the below gif you can see I am forcing my next action to be run if the previous action gets failed and succeded(by default). You need to handle the exception as per your need.

Feel free to get back to me if you have any queries or concerns.

Debbie Edwards 521 Reputation points

2022-03-24T11:52:35.247+00:00

Thank you for the response. the first section has got me past folders. I am struggling to understand the next step. (the live recording is very quick and I cant see how I initialise the variable? I had a go creating a boolean variable but it hasn't made any difference.

I have been left with this error

And now I'm thinking. What if the files I need are over the maximum buffer size of 10457600? How do I deal with this when these may be the files I want to copy?
MayankBargali-MSFT 70,936 Reputation points Moderator

2022-03-25T08:09:31.52+00:00

@Debbie Edwards Thanks for your response. The gif that I have shared was only for your reference on how you can configure the configure run after setting on the next action. In my case, it was the variable action that I have defined. As per your business logic, you need to define the next action and configure the same setting. To learn more about how to handle exceptions you can refer to this document that was shared previously.

Regarding your new issue, this is expected behavior as this is the hard limit of the multi-tenant environment as documented here.
As SharePoint action doesn't support chunking so this will not be applicable for SharePoint connector. Feel free to provide the feature request here if this is something you want to see in the muti tenant logic app.

Share via

Logic Apps Copying Files from Sharepoint folder to Data Lake getFileContent error File not found

1 answer

Your answer