In my example, I set lookup columns to “Choice” and date columns to “Date and time”. We further customize the Excel table to assign List column types to spreadsheet columns. This is a great time to perform data validation! Microsoft Lists provide the opportunity to update or “customize” the spreadsheet during the import process. My example spreadsheet does not have any tables and cannot be imported until it does. In this example I am using an existing file stored in OneDrive. Start by navigating to Microsoft Lists, click “New list” and then click “From Excel”.Įither upload the spreadsheet from your computer or use an online file from OneDrive / SharePoint. In this blog post I am going to walk through creating a new List using an existing Excel spreadsheet. The new functionality and a shift to its own dedicated app help to lower technology barriers for citizen developers and better position Microsoft Lists in the Microsoft 365 landscape of apps. I’m very happy to see Microsoft Lists starting to roll-out.
0 Comments
Leave a Reply. |