Unanswered

Opening blob file using power automate desktop

(0) Share

Report

Posted on by jsonrocks

Hi,

I am trying to implement a use case where I am accepting inputs from Azure blob storage into power automate desktop. I want to be able to go to a particular container and read the file contents as input / store in a data structure/variable . Power automate seems to be achieving this using connectors. I did not find the same using PAD. Any help in this regard would be appreciated. Thank you.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

If it isn't a binary the you could use:

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/web#invokewebservicebase

Otherwise AzCopy might help?

https://techcommunity.microsoft.com/t5/itops-talk-blog/upload-files-to-azure-blob-storage-using-power-automate-desktop/ba-p/2316960

Was this reply helpful? Yes No
Rkv_ 166 on at

Like
a
(0)

Report
Copy link

Link copied!

if you can use SQL queries to your blob storage then configure connection string and use Execute SQL statement action.

Was this reply helpful? Yes No
jsonrocks 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response. So is it safe to say the only way for the PAD to access the blob storage files(excel files) is to download them to local machine?

Was this reply helpful? Yes No
jsonrocks 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response. Unfortunately I am dealing with excel files in my blob storage.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

You could download and open them with a local Excel instance or open them using Excel Online and use the API or even better process them with Power Automate cloud flows

Was this reply helpful? Yes No
jsonrocks 6 on at

Like
a
(0)

Report
Copy link

Link copied!

So I did try to use launch excel instance with the URL to the blob file .The flow failed with error. "Failed to open excel document(Excel launching error)".Is there something I am missing here for this method to work?

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

don't think it supports URLs, you need to download it

Was this reply helpful? Yes No