Content Type in Create Blob

Andreia Gabriel 0 Reputation points
2023-09-19T15:30:26.7233333+00:00

I have a logic app flow that saves an email attachment into a blob container in azure storage.
The attachment is an excel file so I put in content type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

The flow works and the file is saved as an ".xlsx" but i cant open it. It says that the file extension is not valid.

When i test the flow and go to "raw outputs" the content type is equal to application/json.

How can i fix this?

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,192 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,542 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bhanu Ejjagiri 261 Reputation points Microsoft Employee
    2023-10-01T20:25:33.7866667+00:00

    Hi Andreia Gabriel

    Thanks for reaching Microsoft Q&A, and my apologies for the delay in response.

    "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" is a valid content type for xlsx files.

    Can you please help me with below checks:

    • The file may not support xlsx extension: Can you download the file and change extension from xlsx to xls and try opening it - if working fine, this means the file has to be in xls format only.
    • Is it working for other excel file that was saved by same logic app into the same blob container? - if yes, this means we can skip looking at the logic app's "raw outputs"

    Thanks!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.