cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DTmark
Regular Visitor

Recurrent Sharepoint List to Excel and then emailed via Flow

This is fairly specific of a situation that we are attempting to solve. Any help would be appreciated, we are able to do pieces, accomplishing the whole is the current battle.

 

We have a Sharepoint List that we need to email certain list items as an Excel attachment on the last Friday of the month.

 

We have tried using a template file stored in a separate Sharepoint Document Library, also building the file new each time is fine too.

 

Theoretical steps in the Flow:

  1. Recurrent flow
  2. Get items from Sharepoint List based on certain criteria (we have a Status field)
  3. Write those Sharepoint List Items to Excel
  4. Create Email and attach the created Excel spreadsheet to.
  5. Change Sharepoint List items status to Sent.

Please help in understanding how to accomplish this. There are other specifications in this as well that may alter final Flow but I believe these to be the pertinent ones.

0 REPLIES 0

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

Users online (21,374)