{"id":6932,"date":"2023-12-21T22:12:45","date_gmt":"2023-12-22T03:12:45","guid":{"rendered":"https:\/\/johndeletre.blog\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/"},"modified":"2023-12-21T22:13:36","modified_gmt":"2023-12-22T03:13:36","slug":"how-i-eliminated-4370-viva-engage-jobs-with-power-automate","status":"publish","type":"post","link":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/","title":{"rendered":"How I eliminated 4,370 Viva Engage jobs with Power Automate"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6932\" class=\"elementor elementor-6932 elementor-6888\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cda3ada e-flex e-con-boxed e-con e-parent\" data-id=\"cda3ada\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-89307c1 elementor-widget elementor-widget-text-editor\" data-id=\"89307c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A few days ago, by mistake, I flooded\/flooded an internal office community in Viva Engage, dedicated to informing my colleagues about the latest Microsoft Teams news. It was not intentional, I assure you! This was the result of a mistake I made when trying to optimize my Power Automate flows. In this article, I&#8217;ll explain what happened and, more importantly, how I corrected my mistake and what I learned in the process.<\/p>\n<h4>My mistake<\/h4>\n<p>It all started when I decided to create a Power Automate flow whose purpose is to reactivate all my inactive or suspended Power Automate flows once a month, because as you know after 90 days of inactivity Microsoft automatically deactivates it. So I created a flow that would go through all my flows and reactivate them if necessary. The problem is that I forgot to filter the automatic publication flow of my blog posts. This flow was supposed to publish a new blog post on the Microsoft Teams Viva Engage community, every time I publish a post on my WordPress Blog. This flow didn&#8217;t work very well and was disabled for a good reason \ud83d\ude05. As a result, the flow was reactivated and published several articles from my blog in a loop, without stopping!<\/p>\n<h4>The result<\/h4>\n<p>In just a few minutes, I created <span style=\"text-decoration: underline;\"><br \/>\n  <strong>4370 ads<\/strong><br \/>\n<\/span> Viva Engage ads with the same content. I didn&#8217;t notice my mistake right away, as I wasn&#8217;t consulting the community at the time. When I realized it, I was surprised! I had polluted my own community with useless duplicates and had probably annoyed all my subscribers and colleagues!<\/p>\n<p>I wanted to delete all the posts I&#8217;d created, but I ran into a roadblock: there&#8217;s no way to mass delete content in Viva Engage using Microsoft&#8217;s administrative tools. At least I haven&#8217;t found any\ud83d\ude2b. I then had to delete each item manually, which would have taken hours or even days!<\/p>\n<h4>The solution<\/h4>\n<p>Fortunately, I found a solution thanks to Power Automate! Yes, the same tool that had caused my error! Back home there&#8217;s an expression for that &#8220;curing evil with evil&#8221; \ud83d\ude09But this time, I used it to good effect. I&#8217;ve created 2 new flows. The first uses the Viva Engage connector to list all posts in the Microsoft Teams community. Once the first flow had been executed, I was able to search for the last article I had published manually. Then, using my second flow, I used an API call to delete each item in a For Each loop.<\/p>\n<p>The combination of these two flows enabled me to remove all the ads automatically generated by my error in less than two days and without any manual intervention. I was relieved to see that my community was clean again and that I hadn&#8217;t caused any irreparable damage.<\/p>\n<h4>1st Flow<\/h4>\n<p>The first step is to define a shutter release. In this case, I&#8217;ve chosen a manual shutter release. Then we define 3 variables:  <\/p>\n<ol>\n<li><strong>varAllMessages<\/strong>, which will unite all Viva Engage ad IDs. In fact, when we ask the Viva Engage connector to retrieve all the ads in a community, it only returns <strong>20<\/strong> \ud83d\ude44<\/li>\n<li><strong>varNoMoreMessages<\/strong>, a Boolean (true\/false) which returns true if there are still messages and false if there are no messages.  <\/li>\n<li><strong>varLastMessages<\/strong>, The ID of our latest ad retrieved from Viva Engage.  <\/li>\n<\/ol>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b27562 elementor-widget elementor-widget-image\" data-id=\"7b27562\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt1.png\" data-elementor-open-lightbox=\"yes\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NjkxNCwidXJsIjoiaHR0cHM6XC9cL2pvaG5kZWxldHJlLmJsb2dcL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjNcLzEyXC8xZXItRmxvdy1jYXB0MS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1062\" height=\"1207\" src=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt1.png\" class=\"attachment-full size-full wp-image-6914\" alt=\"\" srcset=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt1.png 1062w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt1-264x300.png 264w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt1-901x1024.png 901w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt1-768x873.png 768w\" sizes=\"(max-width: 1062px) 100vw, 1062px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4850b6 elementor-widget elementor-widget-text-editor\" data-id=\"d4850b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Then we use the <strong>Do Until<\/strong> operator to collect all the Viva Engage ads until there are none left:  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83040a9 elementor-widget elementor-widget-code-highlight\" data-id=\"83040a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>@equals(variables('varNoMoreMessages'), true)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1be98cf elementor-widget elementor-widget-text-editor\" data-id=\"1be98cf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Thanks to the Viva Engage connector, I&#8217;ve selected my community&#8217;s Group ID, as well as its network ID. Here it&#8217;s very important to use the <strong>Older Than<\/strong> option with the function below, which uses the last ID of the last request of 20 to fetch subsequent ads up to the ID of the last message 0.  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a03d41d elementor-widget elementor-widget-code-highlight\" data-id=\"a03d41d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>if(equals(variables('varLastMessageID'), 0), null, variables('varLastMessageID'))<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7025507 elementor-widget elementor-widget-image\" data-id=\"7025507\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2.png\" data-elementor-open-lightbox=\"yes\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NjkxOSwidXJsIjoiaHR0cHM6XC9cL2pvaG5kZWxldHJlLmJsb2dcL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjNcLzEyXC8xZXItRmxvdy1jYXB0Mi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"2059\" height=\"1550\" src=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2.png\" class=\"attachment-full size-full wp-image-6919\" alt=\"\" srcset=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2.png 2059w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2-300x226.png 300w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2-1024x771.png 1024w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2-768x578.png 768w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2-1536x1156.png 1536w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/1er-Flow-capt2-2048x1542.png 2048w\" sizes=\"(max-width: 2059px) 100vw, 2059px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38e901f elementor-widget elementor-widget-text-editor\" data-id=\"38e901f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Now that we&#8217;ve got all the ads, we need to stop it if we ever get to the last ad. To do this, we use a Yes\/No condition. We check whether the following condition is true <em>(is equal to $true)<\/em>:  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-feb2c9c elementor-widget elementor-widget-code-highlight\" data-id=\"feb2c9c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>empty(body('Get_messages_in_a_group')?['messages'])<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ecb9299 elementor-widget elementor-widget-text-editor\" data-id=\"ecb9299\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If the condition is true, the <strong>Do Until<\/strong> loop is exited, otherwise the False branch is used, which performs the following steps:  <\/p>\n<ol>\n<li>Unites the varAllMessages variable with the body of the Viva Engage connector that retrieves the ads.  <\/li>\n<li>Adds the contents of the union to the varAllMessages variable<\/li>\n<li>Set the ID of the last ad retrieved in the previous step.  <\/li>\n<\/ol>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-124f8d2 elementor-widget elementor-widget-code-highlight\" data-id=\"124f8d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>union(variables('varAllMessages'), body('Get_messages_in_a_group')?['messages'])<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac77f8a elementor-widget elementor-widget-text-editor\" data-id=\"ac77f8a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To retrieve the last ID, we&#8217;ll need to filter our Output to retrieve only the ID, as shown below:  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ffcfa7 elementor-widget elementor-widget-code-highlight\" data-id=\"1ffcfa7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>last(body('Get_messages_in_a_group')?['messages']).ID<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a0fb8b3 elementor-widget elementor-widget-text-editor\" data-id=\"a0fb8b3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Finally, to count the number of total ads, we use Compose with the following input:  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6210075 elementor-widget elementor-widget-code-highlight\" data-id=\"6210075\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>length(variables('varAllMessages'))<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bc1e1cd elementor-widget elementor-widget-text-editor\" data-id=\"bc1e1cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h4>2nd Flow<\/h4>\n<p>Here are the steps of my 2nd Flow :  <\/p>\n<ol>\n<li>Initialized the <strong>token<\/strong> bearer used to connect via API to Viva Engage.  <\/li>\n<li>Initialize a <strong>variable<\/strong> that will include an array with all the Viva Engage ad IDs to be deleted.<\/li>\n<li>Execute an <strong>Apply to each <\/strong>option and delete the Viva Engage ads 1 by 1 via a <strong>DELETE<\/strong> API call.<\/li>\n<\/ol>\n<p>The API call code looks like this:  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcafc08 elementor-widget elementor-widget-code-highlight\" data-id=\"dcafc08\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-json \">\n\t\t\t\t<code readonly=\"true\" class=\"language-json\">\n\t\t\t\t\t<xmp>{\r\n  \"type\": \"Http\",\r\n  \"inputs\": {\r\n    \"uri\": \"https:\/\/www.yammer.com\/api\/v1\/messages\/@{items('Apply_to_each')}\",\r\n    \"method\": \"DELETE\",\r\n    \"headers\": {\r\n      \"Accept\": \"application\/json\",\r\n      \"Authorization\": \"Bearer @{variables('varToken')}\",\r\n      \"content-type\": \"application\/json\"\r\n    }\r\n  }\r\n}<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f32e0f2 elementor-widget elementor-widget-image\" data-id=\"f32e0f2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"656\" height=\"1450\" src=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/2eme-Flow-capt1.png\" class=\"attachment-full size-full wp-image-6921\" alt=\"\" srcset=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/2eme-Flow-capt1.png 656w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/2eme-Flow-capt1-136x300.png 136w, https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/2eme-Flow-capt1-463x1024.png 463w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5eda43d elementor-widget elementor-widget-text-editor\" data-id=\"5eda43d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h4>The lesson<\/h4>\n<p>This misadventure taught me several things. First of all, I&#8217;ve learned to be more careful with my Power Automate flows. From now on, I&#8217;ll always check conditions and filters before activating them. Ideally, I should also test my flows on a development environment before deploying them on a production environment.<\/p>\n<p>Then I learned how to use the Viva Engage connector and make API calls with Power Automate. This is a very useful skill for interacting with web services and automating complex tasks. I&#8217;ll certainly be exploring the possibilities offered by this connector and by API calls.<\/p>\n<p>Finally, I&#8217;ve learned to laugh at my mistakes. Instead of deleting the community and recreating it from scratch and losing all my publishing work, I decided to clean up my current community and turn it into a blog post to share my experience and learnings. By the way, I hope you enjoyed this read and got something positive out of my mistake.<\/p>\n<h4>Source<\/h4>\n<p>Here are the Microsoft sources and articles by other people who helped me design these 2 flows:<\/p>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/connectors\/yammer\/\" target=\"_blank\" rel=\"noopener\">Microsoft | Learn | Viva Engage connector Power Automate<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/rest\/api\/yammer\/rest-api-rate-limits\" target=\"_blank\" rel=\"noopener\">Microsoft | Learn | Yammer REST API<\/a><\/li>\n<li><a href=\"https:\/\/alextofan.com\/2019\/03\/18\/how-to-get-all-messages-in-a-yammer-group-using-microsoft-flow\/\" target=\"_blank\" rel=\"noopener\">Alex T. | Blog |&nbsp; How to get all messages in a Yammer group using Microsoft Flow<\/a><\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=3iGwJ1cHiiQ&amp;t=1s&amp;ab_channel=DanielChristian\" target=\"_blank\" rel=\"noopener\">Daniel Christian | YouTube | Delete Entire Yammer Conversations Using Power Automate<\/a><\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c68cb60 elementor-widget elementor-widget-video\" data-id=\"c68cb60\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;video_type&quot;:&quot;hosted&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-hosted-video elementor-wrapper elementor-open-inline\">\n\t\t\t\t\t<video class=\"elementor-video\" src=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/Delete-Entire-Yammer-Conversations-Using-Power-Automate-by-Daniel-Christian.mp4\" controls=\"\" preload=\"metadata\" controlsList=\"nodownload\" poster=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/Daniel-Christian.jpg\"><\/video>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>A few days ago, by mistake, I flooded\/flooded an internal office community in Viva Engage, dedicated to informing my colleagues&hellip;<\/p>\n","protected":false},"author":1,"featured_media":6893,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[62],"tags":[108,243,109,81],"class_list":["post-6932","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-365-en","tag-power-automat","tag-viva-engage-en","tag-wordpress-en","tag-yammer-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How I eliminated 4,370 Viva Engage jobs with Power Automate &#062; JD. Blog<\/title>\n<meta name=\"description\" content=\"In this article, I explain how I was able to delete 4370 Viva Engage items, thanks to Power Automate.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How I eliminated 4,370 Viva Engage jobs with Power Automate\" \/>\n<meta property=\"og:description\" content=\"In this article, I explain how I was able to delete 4370 Viva Engage items, thanks to Power Automate.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/\" \/>\n<meta property=\"og:site_name\" content=\"JD. Blog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/TheCowboy974\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-22T03:12:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-22T03:13:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"John Deletre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/john_deletre\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Deletre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/\"},\"author\":{\"name\":\"John Deletre\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#\\\/schema\\\/person\\\/76185eeef8e3b5739329b634aab80675\"},\"headline\":\"How I eliminated 4,370 Viva Engage jobs with Power Automate\",\"datePublished\":\"2023-12-22T03:12:45+00:00\",\"dateModified\":\"2023-12-22T03:13:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/\"},\"wordCount\":1071,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/johndeletre.blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/PowerAutomate-post.png\",\"keywords\":[\"Power Automat\",\"Viva Engage\",\"Wordpress\",\"Yammer\"],\"articleSection\":[\"Microsoft 365\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/\",\"url\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/\",\"name\":\"How I eliminated 4,370 Viva Engage jobs with Power Automate &#062; JD. Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/johndeletre.blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/PowerAutomate-post.png\",\"datePublished\":\"2023-12-22T03:12:45+00:00\",\"dateModified\":\"2023-12-22T03:13:36+00:00\",\"description\":\"In this article, I explain how I was able to delete 4370 Viva Engage items, thanks to Power Automate.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#primaryimage\",\"url\":\"https:\\\/\\\/johndeletre.blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/PowerAutomate-post.png\",\"contentUrl\":\"https:\\\/\\\/johndeletre.blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/PowerAutomate-post.png\",\"width\":2400,\"height\":1260},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/2023\\\/12\\\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How I eliminated 4,370 Viva Engage jobs with Power Automate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/\",\"name\":\"JD. Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#organization\",\"name\":\"JD. Blog\",\"url\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/johndeletre.blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/cropped-Sans-titre-3.png\",\"contentUrl\":\"https:\\\/\\\/johndeletre.blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/cropped-Sans-titre-3.png\",\"width\":512,\"height\":512,\"caption\":\"JD. Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/#\\\/schema\\\/person\\\/76185eeef8e3b5739329b634aab80675\",\"name\":\"John Deletre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e517726adf28d9166f91b0b3ea3976a170461f52f609f765df04b90346c87471?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e517726adf28d9166f91b0b3ea3976a170461f52f609f765df04b90346c87471?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e517726adf28d9166f91b0b3ea3976a170461f52f609f765df04b90346c87471?s=96&d=mm&r=g\",\"caption\":\"John Deletre\"},\"sameAs\":[\"https:\\\/\\\/johndeletre.blog\",\"https:\\\/\\\/www.facebook.com\\\/TheCowboy974\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/johndeletre\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/john_deletre\"],\"url\":\"https:\\\/\\\/johndeletre.blog\\\/en\\\/author\\\/johnadmin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How I eliminated 4,370 Viva Engage jobs with Power Automate &#062; JD. Blog","description":"In this article, I explain how I was able to delete 4370 Viva Engage items, thanks to Power Automate.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/","og_locale":"en_US","og_type":"article","og_title":"How I eliminated 4,370 Viva Engage jobs with Power Automate","og_description":"In this article, I explain how I was able to delete 4370 Viva Engage items, thanks to Power Automate.","og_url":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/","og_site_name":"JD. Blog","article_author":"https:\/\/www.facebook.com\/TheCowboy974","article_published_time":"2023-12-22T03:12:45+00:00","article_modified_time":"2023-12-22T03:13:36+00:00","og_image":[{"width":2400,"height":1260,"url":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png","type":"image\/png"}],"author":"John Deletre","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/john_deletre","twitter_misc":{"Written by":"John Deletre","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#article","isPartOf":{"@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/"},"author":{"name":"John Deletre","@id":"https:\/\/johndeletre.blog\/en\/#\/schema\/person\/76185eeef8e3b5739329b634aab80675"},"headline":"How I eliminated 4,370 Viva Engage jobs with Power Automate","datePublished":"2023-12-22T03:12:45+00:00","dateModified":"2023-12-22T03:13:36+00:00","mainEntityOfPage":{"@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/"},"wordCount":1071,"commentCount":0,"publisher":{"@id":"https:\/\/johndeletre.blog\/en\/#organization"},"image":{"@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png","keywords":["Power Automat","Viva Engage","Wordpress","Yammer"],"articleSection":["Microsoft 365"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/","url":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/","name":"How I eliminated 4,370 Viva Engage jobs with Power Automate &#062; JD. Blog","isPartOf":{"@id":"https:\/\/johndeletre.blog\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#primaryimage"},"image":{"@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png","datePublished":"2023-12-22T03:12:45+00:00","dateModified":"2023-12-22T03:13:36+00:00","description":"In this article, I explain how I was able to delete 4370 Viva Engage items, thanks to Power Automate.","breadcrumb":{"@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#primaryimage","url":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png","contentUrl":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png","width":2400,"height":1260},{"@type":"BreadcrumbList","@id":"https:\/\/johndeletre.blog\/en\/2023\/12\/how-i-eliminated-4370-viva-engage-jobs-with-power-automate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/johndeletre.blog\/en\/"},{"@type":"ListItem","position":2,"name":"How I eliminated 4,370 Viva Engage jobs with Power Automate"}]},{"@type":"WebSite","@id":"https:\/\/johndeletre.blog\/en\/#website","url":"https:\/\/johndeletre.blog\/en\/","name":"JD. Blog","description":"","publisher":{"@id":"https:\/\/johndeletre.blog\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/johndeletre.blog\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/johndeletre.blog\/en\/#organization","name":"JD. Blog","url":"https:\/\/johndeletre.blog\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/johndeletre.blog\/en\/#\/schema\/logo\/image\/","url":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2022\/09\/cropped-Sans-titre-3.png","contentUrl":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2022\/09\/cropped-Sans-titre-3.png","width":512,"height":512,"caption":"JD. Blog"},"image":{"@id":"https:\/\/johndeletre.blog\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/johndeletre.blog\/en\/#\/schema\/person\/76185eeef8e3b5739329b634aab80675","name":"John Deletre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e517726adf28d9166f91b0b3ea3976a170461f52f609f765df04b90346c87471?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e517726adf28d9166f91b0b3ea3976a170461f52f609f765df04b90346c87471?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e517726adf28d9166f91b0b3ea3976a170461f52f609f765df04b90346c87471?s=96&d=mm&r=g","caption":"John Deletre"},"sameAs":["https:\/\/johndeletre.blog","https:\/\/www.facebook.com\/TheCowboy974","https:\/\/www.linkedin.com\/in\/johndeletre\/","https:\/\/x.com\/https:\/\/twitter.com\/john_deletre"],"url":"https:\/\/johndeletre.blog\/en\/author\/johnadmin\/"}]}},"jetpack_featured_media_url":"https:\/\/johndeletre.blog\/wp-content\/uploads\/2023\/12\/PowerAutomate-post.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/posts\/6932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/comments?post=6932"}],"version-history":[{"count":0,"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/posts\/6932\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/media\/6893"}],"wp:attachment":[{"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/media?parent=6932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/categories?post=6932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/johndeletre.blog\/en\/wp-json\/wp\/v2\/tags?post=6932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}