Forum Discussion

Anonymous

Not applicable

6 years ago

Best practice to get access to a sharepoint folder

Hello guys, I hope you are well. I'm looking to retrieve some excel files from a sharepoint folder to combine them. I've started to use the function SharePoint.Files but it scans all t...

Icon for Microsoft Employee rank

Microsoft Employee

6 years ago

You can try to change Sharepoint.Files() to SharePoint.Contents() to see if that works better for you. Or you can add a Filter step on the FolderPath before you start combining files.

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Anonymous
Not applicable
6 years ago
Hello mahoneypat and thank you.

Using SharePoint.Contents() instead of Sharepoint.Files() seems to be a good idea.

Nevertheless, when I try to open the folder I have this error :

Do you know how to fix this ?

Regards,
- mahoneypat
  Microsoft Employee
  6 years ago
  Not sure. That should work. Remember that M is case sensitive. Does your [Name = <yourfoldername>] part match case too?
  
  Here one tip to help troubleshoot. Connect again and navigate where you see your folder and a hyperlink of "Table" next to it. Click to the right of the hyperlink (not on it) to preview the contents. Is it empty (null)? If so, put a file there and try again.
  
  If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
  Regards,
  Pat
  - Anonymous
    Not applicable
    6 years ago
    Thank you mahoneypat,
    
    It took me a lot of time to identify the issue. The error was caused because one of the folder name contained a special character, in this case it was "&".