Forum Discussion
MladenJ
5 years agoFrequent Visitor
Web.Contents fails with '%' in the filename
Hi, I hope you can help me to get this issue resolved. What the goal is: Load the Excel file (.xlsx) from a SharePoint folder. It seems pretty straightforward thing to do. I am able to do t...
- 5 years ago
Hey all, thanks for your comments.
Unfortunately the Web connector is off the table, as there is no workaround for the special characters issue.
v-kelly-msft - thanks for the article you posted, but it doesn't apply to my case here. Even with the direct link to the file, i'm unable to connect.
Luckily enough, the only workaround i managed to apply is to use the One Drive synced folder and Folder.Files to get to the desired folder.
I guess that i'll have to make sure everyone syncs their One Drive before the use 🙂
v-kelly-msft
Community Support
5 years agoHi MladenJ,
Try to use a try/otherwise statement to handle this issue,see the blog below:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!