Hi,
I am a complete newbie to this and wondered if someone would be able to offer a suggestion to this problem?
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 below.
I am using a small test folder in the 'Sharepoint Communication Site: https://evergreentuition.sharepoint.com/OneDrive%20Sync/Forms/AllItems.aspx?id=%2FOneDrive%20Sync%2F...
I 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.
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)


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!
Any suggestions would be greatly appreciated!
Kind regards,
Matt