How do I create a CSV in Azure Storage using a Logic App?

Question

Ok, I'm trying to get a CSV that is stored on a local server up to Azure Cloud storage. I have the connection to the file server working fine, but I keep getting the following error when I try to write the CSV to the blob storage using Create blob (V2).

{
  "status": 403,
  "message": "This request is not authorized to perform this operation using this permission.\r\nclientRequestId: 5ec46bbd-f2e1-4cb9-b86b-5500008e705a",
  "error": {
    "message": "This request is not authorized to perform this operation using this permission."
  },
  "source": "azureblob-cus.azconn-cus-001.p.azurewebsites.net"
}

Here is the action that is failing.

As you can see I'm trying to provide the access using managed identity. I have the system assigned identity turned on for the Logic App.

In the storage account, I have Logic App managed identity as an owner of the entire resource at this point, and have it added to the Resource Instances section in the networking for the Storage Account. (Setting the Storage Account to Enabled from all networks doesn't change the behavior.)

I'm not sure what other permissions I can actually give this thing to allow it access to the storage account.

Answer 1

Thank you for reaching out to Microsoft Q&A.

I understand that in spite of giving the logic apps owner permission in the Storage account, you still cannot create blob using logic apps. Are you using Blob Storage or ADLS Gen2? If using ADLS Gen2, can you please confirm the container where you are creating Blob has write permissions as well as shown below-

Please refer to Manage ACLs for ADLS Gen2- https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control