We have created VDI automation using Microsoft flow, PowerApps, Sharepoint and Powershell scripts.

Yes, you heard it right, VDI automation by combining office 365 tool set.

This post is not about the above automation but some part of it.

Here is the High level of what has been done.

• PowerAPPS has been used for creating a form that user fills to request VDI.
• Sharepoint list to store the requested input.
• Microsoft flow for running approval work flow.
• PowerShell scripts for all the backend work for sending welcome email & VDI creation.

Recently there was one request missed by the Approval team so they wanted if we can send a daily email of any requests that are still pending and their attention is required.

This post is about how to monitor the SharePoint list with particular status and if found send a alert.

First Step is use the Recurrence as the trigger…

 

Now initialize the array as you need to count number of items and if number is greater than zero, you can generate the alert.

After this use get items activity to get sharepoint List items and filter it by status (you might have different column or status in your automation)

See below filter Query that is relevant to our List but may not be relevant in your case (so change it accordingly)

ADD two parallel branches to it, one will collect the number of items (ID) and other will terminate the flow if above step is failed.

Configure the terminate activity as below.(if get items activity is failed)

Now add a condition if length of array is greater than 0 than send the Alert Email else terminate the flow as success.

In the email alert you can use the variables like compose so that you can send the SharePoint list items IDs that needs attention.

Here is the full flow snapshot (how it looks like after completion)

I hope this will assist you in some way or the other if you are doing some flow based automation.

Note: I have used terminate with success to gracefully exit the flow where possible as this technique reduces unnecessary flow failure alerts.

 

Thanks for reading

Sukhija Vikas

http://SysCloudPro.com