Unanswered

Cloud Connector call failed

(1) Share

Report

Posted on by Patrick_Perea

Hello,

I am writing a flow to download a file from SharePoint to local computer and in my for each loop, I am getting Cloud connector call failed status code 'NotFound'. I think I found the issue but dont know how to fix it, This is my list folder action:

There is only one file but this variable is coming up first so when I go through my for each loop it errors out at get file content.

Is there any way that this one does not appear. Here is the 2nd variable that is coming back correct.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Patrick_Perea 41 on at

Like
a
(1)

Report
Copy link

Link copied!

last thing to add the flow setup

Was this reply helpful? Yes No
eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

How does your Get file content using path -action look like? What parameter do you use from the currentItem -variable? Try using %CurrentItem['Path']% in the Get file content using path -action File Path field.

Also if it will always return only one file and you know that then you could remove the For each -loop and just use variable from List folder and refer to the first item %ListFolderResponse[0]['Path']%
Like so:

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like
a
(1)

Report
Copy link

Link copied!

This is my get file using content

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like
a
(1)

Report
Copy link

Link copied!

My folder metadata and list folder

folder is /folder name

Was this reply helpful? Yes No
eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Oh now I think I understand. I read you opening post again. Since the first one is not a file but a folder it will give an error in the first loop.
You want to use Get file content using path -action only to an item that is not a folder but a file. So .IsFolder needs to be False.

So add a condition that checks that the current item is not folder with IsFolder parameter.
EDIT:
fixed if statement: If %CurrentItem['Folder']% = %True% then Next loop

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like
a
(1)

Report
Copy link

Link copied!

Does that work with a document library in sharepoint?

Was this reply helpful? Yes No
eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

I haven't used that but I would assume so. The logic is that you cant read file content from a folder since there is no file to be read. You only want to use Read file content using path -action to an actual file and not folder or it will go to error. That's why you want to check before trying to read the file content that the current item is an actual file and not a folder.

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like
a
(1)

Report
Copy link

Link copied!

I was able to get past the error but new issue, when I go through the flow no file is created

The get file by path variable comes back blank

Was this reply helpful? Yes No
eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Okay so GetFileContetntByPathResponse -variable is empty after you have run Get file content using path -action successfully for a file.
It should look something like this:
But for you it has no value?

For troubleshooting I would test with only Get file content using path -action where you just take the file content without any variables. So find the file manually for it and run that one action and see if that returns anything. If it doesn't then maybe try a different file.

When you run the flow make sure that it actually goes to those actions and doesn't go to Next loop in every instance. I changed the if statement a bit to make sure it checks the IsFolder value correctly:

I have had trouble with old excel format (.xls) when using Excel actions in Power Automate Cloud.
Add a dummy excel that is in .xlsx format and try to use Get file content using path -action to that.

Was this reply helpful? Yes No