I have a SPO document library which I use powerautomate for various tasks...
I am able to call files successfully using the following.... (I have replaced the site address, folder path for obvious reasons)
however, when I use the excel run script, it fails and unable to list the files....
the files are not getting listed! - so I used manual entry of the filename to test but even that also fails...
i used \filename.xlsx , /filename.xlsx , filename.xlsx etc... but no luck!
what could be the reason? any pointers would be appreciated....
Solved! Go to Solution.
Hey @Jared_Simon ,
Ok. So files are there in library and they are not getting listed. This only happens it the action cannot find an XLSX file.
Please create a new file xlsx and try to create a new flow and see if that returns the list.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
not working - same error....
is there a way to select "category value" - sales_1 in the excel run script flow step? its not showing currently...
"recreate the SP site"! really?
Is that the best we can do?
What about all the other shared files and links etc... this is an OK solution if you've only just set up your sp site but when it's been running for a few years this solution sucks. (no offence intended Jared)
Isn't there something better like tweaking the permissions or changing the file names, something a little less invasive?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.