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-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://www.facebook.com/pragmaticworks/
✔️Instagram: https://www.instagram.com/pragmatic.works
✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks
✔️YouTube: https://www.youtube.com/pragmaticworks


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks

Видео How To Automatically Add Excel Data to a SharePoint List with Power Automate канала Pragmatic Works