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
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

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (72,842)