Read Excel File from SharePoint Online and create Records in Dataverse | Power Automate Flow
This article discusses how to use Power Automate Flow to pick an Excel spreadsheet from SharePoint Online and create records in Dataverse. The Flow uses the Excel Online and SharePoint Online connectors to perform this operation. The article provides a step-by-step guide on how to set up the Flow, including selecting the SharePoint site and document library, choosing the Excel file and table, and mapping the columns to the fields in Dataverse. The Flow can be run on-demand or automated based on specific triggers. The article also includes screenshots and examples to illustrate the process.
Article 16m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time