Microsoft Flows - Send e-mail with items that need to be reviewed

Summary of steps

Description

Recurrence - Only for testing

varApprovalRequiredItems - items that required approval and that will be sent by email to approver.

Get Request Items - Get SharePoint list items based on filter

Apply to each Pending Request - If conditional checking if request is not Data Sensitive and External request. 

If doesn't meet the condition, item will be added to array.

Condition CheckIfArrayIsNotEmpty - Send e-mail only if there are items that require approval:

Expression to check if array is not null:

length(variables('varApprovalRequiredItems'))