Aug 09 2021 12:28 AM
I'm trying to use the Create File action in Power Automate with SharePoint Online. However the operation fails with the error "File not found" if the filename includes # or %
Both of these are valid characters in SharePoint file names. The Update File action works fine with filenames that contain these characters.
I've tried using the encodeUriComponent function on the filename. This does allow the file to be created, but # and % characters are replaced with %23 and %25.
I've also noticed that the characters { } and ~ get replaced with _
Any suggestions?
Oct 27 2022 11:22 AM
Oct 30 2022 08:35 AM - edited Oct 30 2022 08:37 AM
Hi Tim!
You can create a file with special characters, you need to use Http Request for SharePoint Connector in conjunction with Create a File to do this, as you need to update the file name after creating it...
Did a blog post a while back for exactly this, you can more or less just copy the code in there, just update the fields you need changed:
https://yourmodernworkplace.com/blog/create-sharepoint-file-with-special-characters-with-power-autom...