Send items meeting column criteria from a SharePoint List via Daily Scheduled Flow

[BriceBowden]

I have created a workflow that populates a SharePoint list with safety findings from different construction sites. The items can have a Status of either "Open" or "Closed". Contractors need to have access to the list of "Open" items in order to track and close them. The contractors from the different sites are outside my organization and therefore cannot view the SharePoint list. I am trying to work around this by using flow to send an email every day with all items from the list that meet certain criteria. ("Status"='Open' and one other column, either "Site"='site name' or "Project"='project name'). 

I was initially trying to solve this by starting with a Scheduled flow and using "Get Items" function from SharePoint and then "Create HTML Table" and finally "Mail" function. I get the following error "The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array."

Any other ideas for how to accomplish sending the sharepoint list via email?

[rohsh354 · Accepted solution]

@BriceBowden 

Hello,

You can initialize an array variable and populate it using append to array action. Please see the example below for reference.

Also, you should consider using Office 365 outlook connector instead of Mail, as Mail connector has limitations on emails per day. https://docs.microsoft.com/en-us/connectors/sendmail/#throttling-limits

Hope this helps !