Set the columns to align with your Excel data. I am importing three dates into my existing list.Īdd an “Apply to each” action using the “value” output from the Excel “List rows present in a table” action.Īdd “Set variable” actions for each of your date columns and set the value to the Excel date columns.Īdd a “SharePoint” – “Create item” task, set it your target site and list name. Add a “Initialize variable” action, set the name to “varDate1” and type to “String”. You will need a variable per date column for import. We’ll use a variable to store the date from Excel and then apply an expression to do the conversion. Excel dates don’t carry over the way you would expect. This next section is targeted for date data. Set the “Location”, “Documents”, “File” and “Table” values to the location and names that you set in the previous section. OneDrive or SharePoint).Ĭreate a new Flow using the “Manually trigger a flow” trigger.Īdd an “Excel Online (Business)” – “List rows present in a table” action. Make sure your Excel file is stored online (i.e.
To start, ensure that your Excel data is formatted as a table and the column names and data types align to the destination List.
This blog post will show how I used Power Automate to import Excel data into an existing SharePoint List. Have you ever needed to import Excel data into an existing SharePoint List? Creating a new list and importing data is easy enough using the Create a list based on a spreadsheet feature but adding data to an existing List is not that straight forward.
0 kommentar(er)
