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 - [ Ссылка ]
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: [ Ссылка ]
🔗Pragmatic Works On-Demand Learning Packages: [ Ссылка ]
🔗Pragmatic Works Boot Camps: [ Ссылка ]
🔗Pragmatic Works Hackathons: [ Ссылка ]
🔗Pragmatic Works Virtual Mentoring: [ Ссылка ]
🔗Pragmatic Works Enterprise Private Training: [ Ссылка ]
🔗Pragmatic Works Blog: [ Ссылка ]
Let's connect:
✔️Discord: [ Ссылка ]
✔️Facebook: [ Ссылка ]
✔️Instagram: [ Ссылка ]
✔️LinkedIn: [ Ссылка ]
✔️YouTube: [ Ссылка ]
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks
