Hey guys!
So I have created a flow using "Retrieve Email Messages" that is fetching the email attachments (mostly docx documents) and saving them into a folder. Now I need to insert those attachments into a database table, specifically a BLOB column.
My company hasn't purchased Azure Blob Storage, so I cannot use it.
I tried using the INSERT INTO statement, but it didn't work. And as I have done my research, it needs to be done with a procedure that has a database directory. So I have to use a local database tool to make the procedure. However, I have Power Automate Desktop installed on a different server so I don't think I can call the procedure within Power Automate since my folder with attachments is on a diferent server.
Does anyone have any idea how to solve this? Is it possible with INSERT INTO?
Any help would be appreciated, thanks!

Report
All responses (
Answers (