How To Automatically Add Excel Data to a SharePoint List with Power Automate

Using Power Automate we can get the data from an Excel table and automatically add it to a SharePoint list. This flow will check the Excel table every morning and not only add in any new records from the Excel table, but also update and records that were modified on that table. 👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Jonathon30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - https://pragmaticworks.com/pricing/ 00:00 - Introduction 00:35 - Preparation: Excel Data in Table Format in OneDrive and SharePoint List Setup 01:26 - Building a Scheduled Cloud Flow in Power Automate 02:32 - Configuring "List Rows Present in Table" for Excel Online for Business 03:50 - Retrieving All Items from the SharePoint List Using "Get Items" 05:03 - Matching Rows and Applying a Loop for Each Row in Power Automate 07:05 - Conditional Check: Update SharePoint List if Row Exists, Create New Item if Not 08:33 - Update Action: Updating Existing Item in SharePoint List 09:53 - Create Action: Creating a New Item in SharePoint List -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook:   / pragmaticworks   ✔️Instagram:   / pragmatic.works   ✔️LinkedIn:   / pragmaticworks   ✔️YouTube:    / pragmaticworks   Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks