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:

  1. Open Microsoft Power Automate and create a new flow.
  2. Choose the "SharePoint" connector and select the "When an item is created, modified or deleted" trigger.
  3. 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.
  4. 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.
  5. Use the "TriggerBody()?['EventType']" expression to determine whether the item was created, modified or deleted.
  6. 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.
  7. If the item was deleted, you can use the "Delete item" action from the SharePoint connector to delete the item from your list.
  8. 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


Most Viewed Articles (in Office365 )

Microsoft Flow to sync data from SharePoint list update/delete records to Dataverse Table

Configure IIS as SMTP relay server for Office 365

Directory Synchronization tool in Office 365

Configure Outlook Manually for Office 365

Is autodiscover CNAME a must 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

Email limits and message limitations in Office 365

On-premise Exchange and Lync Online integration

Create Word, Excel, PowerPoint using Office Web Apps in Office 365

Configure SSO for a domain with ADFS - Convert a domain to a federated domain in Office 365

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)

What is Office 365 Small Business Premium?

Latest Articles (in Office365)

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

Directory Synchronization tool in Office 365

Comment on this tutorial