Hi, I am running into an issue when posting an xlsm file on SP using http. I want to use bypass-shared-lock not available using the "create file"
The problem I am getting is after creating the file if I open it, excel online tries to open it and complains "We're sorry we couldn't open your workbook. It's possibly corrupt or using a file format that's not supported"
The Flow I have is very simple
- Get file content on OneDrive for business
- Sent http request
- Site Address - Using pulled down
- Method - Post
- Uri _api/web/GetFolderByServerRelativeUrl('Shared Documents/General')/Files/add(url='sample.xlsm',overwrite=true)
- Headers
- Prefer: bypass-shared-lock
- X-RequestDigest: {form_digest_value}
- Content-Type: application/octet-stream
- Accept: application/json;odata=verbose
- Body: [Dynamic content: File content from onedrive get file]
The file gets created with no error but fails when opening with the error noted. I also tried entering some json code found online on the body but get same result
Appreciate any assistance on working this
