{"id":89,"date":"2023-03-10T00:45:36","date_gmt":"2023-03-10T00:45:36","guid":{"rendered":"https:\/\/smartsource.com.sg\/blog\/?p=89"},"modified":"2023-03-10T00:46:19","modified_gmt":"2023-03-10T00:46:19","slug":"handle-update-delete-events-in-sharepoint-list-while-syncing-with-dataverse","status":"publish","type":"post","link":"https:\/\/smartsource.com.sg\/blog\/index.php\/2023\/03\/10\/handle-update-delete-events-in-sharepoint-list-while-syncing-with-dataverse\/","title":{"rendered":"Handle update\/delete events in sharepoint list while syncing with dataverse"},"content":{"rendered":"\n

To handle update and delete events in a SharePoint list, you can create a Microsoft Power Automate flow. Here are the steps:<\/p>\n\n\n\n

    \n
  1. Open Microsoft Power Automate and create a new flow.<\/li>\n\n\n\n
  2. Choose the “SharePoint” connector and select the “When an item is created, modified or deleted” trigger.<\/li>\n\n\n\n
  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.<\/li>\n\n\n\n
  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.<\/li>\n\n\n\n
  5. Use the “TriggerBody()?[‘EventType’]” expression to determine whether the item was created, modified or deleted.<\/li>\n\n\n\n
  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.<\/li>\n\n\n\n
  7. If the item was deleted, you can use the “Delete item” action from the SharePoint connector to delete the item from your list.<\/li>\n\n\n\n
  8. Save and test your flow to ensure that it is working as expected.<\/li>\n<\/ol>\n\n\n\n

    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.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To handle update and delete events in a SharePoint list, you can create a Microsoft Power Automate flow. Here are the steps: Note: If you want to monitor for only…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[67,65,66,36],"class_list":["post-89","post","type-post","status-publish","format-standard","hentry","category-howtos","tag-dataverse","tag-microsoft-flow","tag-power-automate","tag-sharepoint"],"_links":{"self":[{"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=89"}],"version-history":[{"count":1,"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":90,"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/posts\/89\/revisions\/90"}],"wp:attachment":[{"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}