Programming Tutorials

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

By: Stella in Office365 Tutorials on 2023-03-17  

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.






Add Comment

* Required information
1000

Comments

No comments yet. Be the first!

Most Viewed Articles (in Office365 )

Email limits and message limitations in Office 365

Is autodiscover CNAME a must in Office 365

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

Copy Power Automate Flows from one environment to another

On-premise Exchange and Lync Online integration

Configure Outlook Manually for Office 365

Migration from on-premise exchange 2003 to Office 365

Change Dirsync synchronization frequency

Error: "the current user is required to be a builtin\administrator directory sync - Office 365 Directory Sync

Making your Alias email as 'Send As' in Office 365

Moving changes from a development environment (sandbox) to a production environment in Dynamics 365

365 office login (office 365 login)

Directory Synchronization tool in Office 365

ADFS and ADFS Proxy in Windows Server 2012

Latest Articles (in Office365)

Copy Power Automate Flows from one environment to another

Moving changes from a development environment (sandbox) to a production environment in Dynamics 365

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 Office 365 Small Business Premium?

What is Ofice 365 Home 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

Migrating SharePoint WSS2.0 site to SharePoint Online and Backup the SharePoint Online