web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / New PAD SharePoint Con...
Power Automate
Unanswered

New PAD SharePoint Connector - Update File question

(0) ShareShare
ReportReport
Posted on by 929 Super User 2024 Season 1

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)

ryule_0-1660924524394.png

 

However, when I go to update the file

ryule_1-1660924574613.png

 

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

 

ryule_3-1660924997177.png

 

ryule_2-1660924960703.png

 

Side note, I also can't get "Get file metadata" to work either, but I'm less concerned about that.

ryule_4-1660925203913.png

 

 

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!

 

I have the same question (0)
  • Verified answer
    ryule Profile Picture
    929 Super User 2024 Season 1 on at

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard