question

SubhamWipro-2202 avatar image
0 Votes"
SubhamWipro-2202 asked EchoDu-MSFT commented

create a Sharepoint form that is exports data to a database

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.

office-sharepoint-onlinesharepoint-workflow
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT commented

Hello @SubhamWipro-2202

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.

102318-1.png

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.

102352-2.png

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

102346-3.png

6.The whole Flow:

102347-flow.png

7.Save and Test this flow

102373-4.png

102336-6.png

102337-5.png

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.



1.png (23.7 KiB)
2.png (18.5 KiB)
3.png (23.3 KiB)
flow.png (111.1 KiB)
4.png (31.1 KiB)
6.png (39.6 KiB)
5.png (10.7 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SubhamWipro-2202 ,

I'm glad I can help you solve the problem. Looking forward to our next cooperation.

Have a nice day!

Thanks,
Echo Du

0 Votes 0 ·