Is it possible to get the rows in an excel file stored in Azure BLOB storage so that it can be inserted into SQL database
Hi @Anonymous
Yes, it is. There's a BLOB storage connector:
https://emea.flow.microsoft.com/en-us/connectors/shared_azureblob/azure-blob-storage/
It's a premium connector, so you need to check if your license supports these connectors.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
My actual concern is about How to get the excel rows from the file stored in BLOB
HI @Anonymous
My suggestion is to copy the file to a temp folder, check the data, and then remove the file.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
45 | |
16 | |
15 | |
14 | |
13 |
User | Count |
---|---|
77 | |
38 | |
27 | |
18 | |
18 |