Not able to import file from Azure Automation sandbox

Question

Script: $resultTable | Export-Excel -Path $env:TEMP$excelFileName -AutoSize -AutoFilter -FreezeTopRow -BoldTopRow

Upload the Excel file to Storage Account

$storageContext = New-AzStorageContext -StorageAccountName $storageAccountName -UseConnectedAccount

echo $storageContext

Set-AzStorageBlobContent -Blob $excelFileName -Container $containerName -Context $storageContext -File "$env:TEMP$excelFileName"

Getting error at command Set-AzStorageBlobContent the file is not being retrive by it. Is there a specific perrmission reqired for managed identity

Failed
Could not open Excel Package C:\Users\ContainerAdministrator\AppData\Local\Temp\deleted_devices_20/12/2023_18:52.xlsx (Could not open Excel Package C:\Users\ContainerAdministrator\AppData\Local\Temp\deleted_devices_20/12/2023_18:52.xlsx)

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.
I think in your Set-AzStorageBlobContent command, the path separators in the file name might be causing issues. Try to remove \ in the file name.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **