Greetings,
I have a flow to be used for vendors to complete an agreement and submit/sign additional documentation. It starts in Adobe Acrobat Sign and I am pulling agreement info and creating the files/attachments from the Adobe Acrobat Sign transaction into a SharePoint library.
Our CRM has a place on vendor records where we can "attach" files which we upload from our computer. I want to take my flow one step further and put the signed documents from Adobe Acrobat Sign into the file upload table so that they appear when viewing the vendor profile and can be accessed there.
The SQL database has a table called ClientDcoment where these are stored and each record in the table links to a VendorProfileId in the VendorProfile table.
I cannot figure out how to use Power Automate to upload a file stream from Adobe Acrobat Sign into an SQL table.
I'm able to connect to the Azure hosted SQL server and the database. If I add an SQL Insert Row step and put in the server/database/table, I am able to see the table fields. But I don't know what to do from here.
Using MSSQL I'm looking at a test upload I did and understand that the FilePath in the table is relative to the Azure server.
Any ideas if this is even possible?
Thank you!
