
Announcements
https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/sharepoint
So in using that documentation, I have successfully been able to Get file content, convert binary to file, and use that file in my bot (Below)
However, when I go to update the file
I get the following message:
{
"StatusCode": "502",
"Message": "",
"Body": {
"error": {
"code": 502.0,
"source": "unitedstates-002.azure-apim.net",
"message": "BadGateway",
"innerError": {
"status": 502.0,
"message": "The file or folder name \"https://site.sharepoint.com/sites/PeopleSoftBlog/Shared Documents/AP Inbox Automation/AP_VENDOR_MAINT_FORM.xlsx\" contains invalid characters. Please use a different name. Common invalid characters include the following: # % * : < > ? / |\r\nclientRequestId: 9f533820-0af1-4f47-adff-a97a193e274e-self\r\nserviceRequestId: 00905ca0-5002-2000-58d3-b3d8c8a2464a;00905ca0-4006-2000-58d3-bf7c65811b84",
"source": "https://site.sharepoint.com/sites/PeopleSoftBlog/_api/web/GetFileByServerRelativePath(decodedUrl=@p)/$value?@p='%2fsites%2fPeopleSoftBlog%2fhttps%3a%2f%2fgppower.sharepoint.com%2fsites%2fPeopleSoftBlog%2fShared+Documents%2fAP+Inbox+Automation%2fAP_VENDOR_MAINT_FORM.xlsx'",
"errors": [
"-2130575245",
"Microsoft.SharePoint.SPException"
]
}
}
}
}
I'm supplying Update file the same file name as "Get file content", so I'm not sure how to resolve the issue
Side note, I also can't get "Get file metadata" to work either, but I'm less concerned about that.
I know this is a new feature, but any help would be appreciated, since I am unable to do a "Save" action on an existing SharePoint file using the Excel actions either. Save As works just fine, but I have not gotten overwriting a file to work.....so if you know anything about that, I'm all ears as well!
Well, I just solved my own issue. I got the bright idea to go out to Power Automate and see how "Update File" works out there, and realized File Identifier only needed this portion of the path: /Shared Documents/AP Inbox Automation/AP_VENDOR_MAINT_FORM.xlsx
Once I updated my action in PAD, it worked like a charm!