You’re offline. This is a read only version of the page.
45
I am creating a flow to upload a excel file to a list everytime it changes. I am using the "List Rows present in a Table" feature, followed by 'apply to each'.
The file is stored on sharepoint. Because the List Rows tool required checking out a file, and flow can't do this, I set it up to first make a copy of this file on my personal onedrive. The script works until here.
I then added the "list rows" tool. In this tool I am trying to locate the excel file (that now already exists there), but the script can't find it. When I browse through onedrive I can see all files except the excel file that has been copied to my onedrive by flow. Why could this be the case?
I've also tried manually typing in the file URL, but when I try to select the table in the next dropdown it does not show me the required excel file that just has been created, and I can only select other excel files on my onedrive.
What am I doing wrong?
(FYI, I already had some issues with the filename in the condition there because of something to do with encoded filenames, hence my variable)
Hi @RobinV86 ,
If the file is stored in a SharePoint Library, change the Location to SharePoint Site.
The file that can be used here must be a file that has already been created. In addition, after the file is created, we need to close Flow and then re-open Flow to select the file we have created.
Files can only be selected through File Browse. If you want to select the file generated by Create file action, this is not feasible, because this file has not been created, so it cannot be selected.
Please take a try again.
Best Regards,
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
