cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BriceBowden
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
rohsh354
Microsoft
Microsoft

@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

 

Screen1.png

 

Hope this helps !

 

 

View solution in original post

1 REPLY 1
rohsh354
Microsoft
Microsoft

@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

 

Screen1.png

 

Hope this helps !

 

 

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (45,021)