Hi,
I am a complete newbie to this and wondered if someone would be able to offer a suggestion to this problem?
Apologies for the length of this - I thought the more info the better?
I've been trying to build a flow on and off for the past couple of weeks that lists all the files and subfolders in a Sharepoint communication site and then send this information to an excel file and google sheet - both of these files have tables set up to receive the information - see flow structure below and screenshot of excel file.
This is the sharepoint communication site:
I am using a small test folder in the 'Sharepoint Communication Site/Documents' to get the flow working properly.
..hence the random folder names eg,
| Shared Documents/1/2/3/4/5/6/7/8/9/10/ |
I just wanted to make sure that the Flow looked inside subfolders etc, so I created a simple file structure with a couple of files in each subfolder.
The folder I am trying to list is located in a Sharepoint Communication Site > Documents with this file path:
Once the flow is working, I will then list all of the files and folders in the 'OneDrive Sync' area which contains many more files (teaching resources)
Flow structure at present:
The output in the Excel file - There are 7 column headers:
Folder Name,
Folder Path,
File Name
File Size
Created At
File Link
Folder Link
This is what is returning in the Excel sheet - happy days!
The 'File Link' and 'Folder Link' both work and open the file via hyperlinks which is what I was after - so great, however, I keep getting this error in the Flow
Here are screenshots of each of the stages of the flow -
I've used AI (chatgpt) to try and debug it and it suggests my issue is:
I've tried these suggestions but issue still remains.
I'm not sure what I've done wrong, possible referenced the file path incorrectly in one of the action steps?
I think it is something so simple, but I just don't have the knowledge to spot it!
The file path of the folder I'm trying to list is:
Any suggestions would be greatly appreciated!
Kind regards,
Matt
