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)

Report
All responses (
Answers (