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
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
23 | |
16 | |
11 | |
10 | |
8 |
User | Count |
---|---|
32 | |
27 | |
25 | |
17 | |
16 |