Forum Discussion
narayanareddy
Jul 11, 2023Copper Contributor
How to copy a table column on SharePoint page to SharePoint list column
Dear all, I have a requirement to copy a column of the table which has hyper links and normal text in 100 number of rows. This is on SharePoint page, I need to copy this entire column of rows to a S...
H2O
Jul 11, 2023Iron Contributor
Here are some ideas or solutions to achieve this task
* Use Power Automate with Parse JSON action. This is a good option if you want to automate the process and avoid manually editing the SharePoint list field. You can create a flow that can read the table data from the SharePoint page, parse it into JSON format, and then create or update items in the SharePoint list.
* Use Access with Export - SharePoint Site Wizard. This is a good option if you want to have more control over the data import process. You can import the table data from the SharePoint page into an Access database, and then export it as a list to the SharePoint site.
* Use a third-party tool. There are a number of third-party tools that can help you copy data from a SharePoint page to a SharePoint list. These tools can be more complex to use than Power Automate or Access, but they may offer more features and flexibility.
Here are some additional tips for copying data from a SharePoint page to a SharePoint list:
* Make sure that the table data is in a consistent format. This will help to ensure that the data is imported correctly into the SharePoint list.
* Test the data import process before you use it to copy a large amount of data. This will help to identify any problems with the process and ensure that the data is imported correctly.
* Back up the SharePoint list before you use the data import process. This will help to protect the data in the event of any problems with the process.
* Use Power Automate with Parse JSON action. This is a good option if you want to automate the process and avoid manually editing the SharePoint list field. You can create a flow that can read the table data from the SharePoint page, parse it into JSON format, and then create or update items in the SharePoint list.
* Use Access with Export - SharePoint Site Wizard. This is a good option if you want to have more control over the data import process. You can import the table data from the SharePoint page into an Access database, and then export it as a list to the SharePoint site.
* Use a third-party tool. There are a number of third-party tools that can help you copy data from a SharePoint page to a SharePoint list. These tools can be more complex to use than Power Automate or Access, but they may offer more features and flexibility.
Here are some additional tips for copying data from a SharePoint page to a SharePoint list:
* Make sure that the table data is in a consistent format. This will help to ensure that the data is imported correctly into the SharePoint list.
* Test the data import process before you use it to copy a large amount of data. This will help to identify any problems with the process and ensure that the data is imported correctly.
* Back up the SharePoint list before you use the data import process. This will help to protect the data in the event of any problems with the process.
- narayanareddyJul 11, 2023Copper ContributorThank you so much for your reply, I am exploring how to read the html table and insert the data in the SharePoint list.