create a Sharepoint form that is exports data to a database

Question

I want to create a form in sharepoint that we complete, enter data like, the users name, the assets they have been provided and when they were provided it, ideally this form would be sent to the user for approval and then be stored in a database so the information can be retrieved if an audit is needed.

Answer 1

Hello @Subham Wipro ，

Based on my research, we could not export the SharePoint form data to database, it is by design. However, you can store the SharePoint form data in a SharePoint list.

Please following step:

1.Create a list named "ListA" and add the corresponding columns in the list.

2.Create another list named "ListB" and add the same columns as the "ListA" list.

3.On the "ListA" list and click Integrate >> Power Apps >> Customize forms.

4.On the Power Apps page, You can customize form. More information, please refer to "Customize a form for a SharePoint list".

5.Go back "ListA" list and click Integrate >> Power Automate >> Create a flow

6.The whole Flow:

7.Save and Test this flow

Thanks,
Echo Du

===================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.