Forum Discussion
APinglay
Jul 16, 2024Copper Contributor
Creating a sharepoint list programatically
Hi, I have an excel file with 100~ columns which was exported from another SharePoint list (that I don't have access to). I would like to create a list on my SharePoint site from this file but th...
Expiscornovus
Jul 16, 2024Iron Contributor
APinglay if PowerShell is not possible I would suggest to have a look at something like Power Automate cloud or desktop flows. Via these products you should also be able to automate some steps.
You could for example read the table with list rows in table action and use Send an HTTP request to SharePoint action to create your fields in a cloud flow.
Desktop flows (RPA) also has a lot of Excel actions: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel and also supports Python code, https://learn.microsoft.com/en-us/power-platform/release-plan/2024wave1/power-automate/use-python-v3-power-automate-desktop