Hi everyone,
I’m working on a Power Automate flow where I retrieve a PDF file from OneDrive and upload it to a Dataverse table. Here's what I've configured so far:
1. **Get File Content from OneDrive**:
- Action: "Get file content"
- File: PDF file stored in OneDrive (example: `PO XX123456 ABC MM N21274.pdf`)
- Infer Content Type: Yes
2. **Upload File to Dataverse**:
- Action: "Upload a file or an image"
- Table: `po_content`
- Row ID: Dynamically retrieved from the Dataverse table
- Column Name: `attachment`
- Content: Set to the `Body` output from "Get file content"
- Content Name: Set to the filename including the `.pdf` extension (e.g., `PO XX123456 ABC MM N21274.pdf`)
Problem:
When I try to upload the file, I get the following error:
```
A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) match the content type 'application/octet-stream'.
```
What I’ve Tried:
- I’ve confirmed that the file is indeed a PDF and is recognized as `application/pdf`.
- The "Get file content" action from OneDrive works as expected and retrieves the PDF.
- The file name is correctly set with the `.pdf` extension.
- I’ve also ensured that the Infer Content Type option is set to "Yes."
However, the content type mismatch persists, with the file being treated as `application/octet-stream` instead of `application/pdf`.
Has anyone encountered this issue before, and how can I force the correct content type (application/pdf) during the upload to Dataverse? Any suggestions on how to resolve this content type mismatch would be appreciated!
Thanks!