cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,355)