Hello ,
I have a cloud flow creating the excel files in one drive, whenever a mail is triggered with only excel attachments. So as using (list rows present in table) action , able to get the excel fields in dynamic content.
So from here , using power automate desktop flow , to copy the excel content into SQL server (MSSQL) . Made use of input variables to get the excel value from dynamic content in cloud flow. And using (open SQL , execute SQL actions) in power automate desktop. So struck in giving query in 'execute SQL' , kindly help with same of giving the required query (insert into) using variables created or suggest any process here to enter the data from excel to SQL (using desktop flow).
Also after data entry in SQL SERVER, there are few conditions to be applied to that data & based on the result , need to generate new different excel files for different results this process also using desktop flow. Kindly guide the process here.
It would be great, if I get any syntax/example for connection string using 'SQL SERVER AUTHENTICATION', not the 'windows authentication' ,to create a connection in (open SQL) action. Kindly look into these, expecting early response.
Thanks in advance.
