Forum Discussion
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 SharePoint multli line rich text field in a list. Is there any way I can do it without manually editing SharePoint list field. Like using any PowerAutomation flow that can read table on a SharePoint page. I tried to copy it to excel and from excel reading it with Power Automation. But, when I copy the content from SharePoint page to Excel the content is not in good format and it is broken. Please advise if you have any ideas to achieve this without manually copying. Thank you so much for your help and ideas.
Best Regards,
Narayana Reddy
- 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.- Thank you so much for your reply, I am exploring how to read the html table and insert the data in the SharePoint list.
