This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Hi
I am trying to come up with a solution where I could move the output of Microsoft Form and insert that data into Azure SQL on a daily basis.
This thread is related to my previous post:
Previously, I came up with a solution where I used "Create file", but by using this, it overwrites a csv file each time somebody submits a form, and that is not the ideal way of collecting data on a daily basis because with current process, I only collect data from a csv file once a day.
Instead of overwriting a data (each time csv file is created), I need to just leave any collected data I get on a daily basis, and move that data into Azure SQL.
I would like to know how to retrieve the data from output of Microsoft Form.
Is there any particular folder and file location of output from Microsoft Form?
Or instead of "Create file" (which overwrites previously collected data), is there any better option to Insert data to a csv file?
Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Hi @King Java , instead of "Create file" after "Create CSV table", why not insert the CSV table directly to your Azure SQL DB?
@Silvia Wibowo Thank you for your help. Are you saying, we insert data directly to Azure SQL DB instead of creating a csv file inside Azure File Storage, correct?
Hi @King Java , that's your goal, isn't it?
@Silvia Wibowo Yes, If I want to insert to Azure SQL database table, is it better to use "Execute a SQL query (V2)" or "Execute stored procedure"?
Hi @King Java , do you have existing stored procedure? Let's handle this with curiosity, as most issues in IT world, your questions can be answered by "it depends". Try it out and see what issue comes up. If it's too difficult, pivot to another option.
@Silvia Wibowo I could definitely use Stored Procedure. But how do I express getting the output from "Create CSV file"?Below is screenshot of output from "Create CSV file":
On the "Execute stored procedure", it only asks for the name of stored procedure.
Do I put parameters inside Stored Procedure?
@Silvia Wibowo Thank you so much for your help and feedback. I am leaning toward tying Azure Automate. If I have some struggle or issue, are you able to help me?
@Silvia Wibowo It appears that in order to use Power Automate, our company has to pay for license fee which I don't think it will work. Can we try the second option (the Power Automate template logic to your current Logic Apps)?
Hi @King Java , of course you can apply the Power Automate template logic to your current Logic Apps.
@Silvia Wibowo Thank you. It worked out. Let me know how to mark your response as "Answered".
Hi @King Java , I think your use case is easier to do with Power Automate instead of Logic Apps:
https://sqlpowered.com/saving-microsoft-forms-responses-to-azure-sql-with-power-automate/
Or you can apply the Power Automate template logic to your current Logic Apps.
Hi @King Java , please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.