Microsoft Flow to sync data from SharePoint list update/delete records to Dataverse Table
By: Stella
To handle update and delete events in a SharePoint list, you can create a Microsoft Power Automate flow. Here are the steps:
- Open Microsoft Power Automate and create a new flow.
- Choose the "SharePoint" connector and select the "When an item is created, modified or deleted" trigger.
- Sign in to your SharePoint account and select the site where your list is located. Then, select the list that you want to monitor for update and delete events.
- Add a "Condition" action to your flow to check the value of the "TriggerBody()" expression. This expression returns the data for the item that triggered the flow.
- Use the "TriggerBody()?['EventType']" expression to determine whether the item was created, modified or deleted.
- If the item was modified or deleted, you can perform additional actions such as sending an email notification or updating another list or system with the changes.
- If the item was deleted, you can use the "Delete item" action from the SharePoint connector to delete the item from your list.
- Save and test your flow to ensure that it is working as expected.
Note: If you want to monitor for only update events, you can choose the "When an item is modified" trigger instead of the "When an item is created, modified or deleted" trigger.
Archived Comments
Comment on this tutorial
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Related Tutorials
Microsoft Flow to sync data from SharePoint list update/delete records to Dataverse Table
Steps to create Microsoft Flow to sync data from SharePoint list to Dataverse Table
ADFS and ADFS Proxy in Windows Server 2012
365 office login (office 365 login)
Configure SSO for a domain with ADFS - Convert a domain to a federated domain in Office 365
What is Ofice 365 Home Premium
What is Office 365 Small Business Premium?
What is Office 365 Midsize Business Plan?
Migration from on-premise exchange 2003 to Office 365
Create Word, Excel, PowerPoint using Office Web Apps in Office 365
On-premise Exchange and Lync Online integration
Email limits and message limitations in Office 365
Comparison: SharePoint Online Plan 1 vs SharePoint Online Plan 2
Migrating SharePoint WSS2.0 site to SharePoint Online and Backup the SharePoint Online