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.
If it isn't a binary the you could use:
Otherwise AzCopy might help?
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?
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
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?
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!