Export items from a criteria weekly

%3CLINGO-SUB%20id%3D%22lingo-sub-358152%22%20slang%3D%22en-US%22%3EExport%20items%20from%20a%20criteria%20weekly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358152%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20am%20looking%20at%20a%20way%20to%20export%20a%20criteria%20of%20items%20from%20a%20SharePoint%20list%20to%20Excel%20on%20a%20recurring%20basis.%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%20All%20items%20created%20in%20a%20sharepoint%20list%20in%20the%20past%207%20days%20should%20be%20compiled%20into%20an%20Excel%20document%20and%20emailed%20to%20management.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20used%20Flow%20for%20basic%20things%20in%20the%20past%20but%20not%20sure%20if%20it%20can%20be%20used%20for%20this%20specific%20task%20and%20how%20to%20achieve%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20guidance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360012%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20items%20from%20a%20criteria%20weekly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360012%22%20slang%3D%22en-US%22%3E%3CP%3EScott%2C%3CBR%20%2F%3E%3CBR%20%2F%3EGlad%20to%20hear%20you%20have%20it%20working.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3E%3CBR%20%2F%3ETerry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359777%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20items%20from%20a%20criteria%20weekly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359777%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20reply.%20I%20sort%20of%20worked%20out%20what%20I%20needed%20to%20do%20and%20built%20a%20flow%20that%20worked%20but%20will%20now%20look%20at%20your%20blog%20and%20take%20some%20guidance%20from%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359136%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20items%20from%20a%20criteria%20weekly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359136%22%20slang%3D%22en-US%22%3E%3CP%3EScott%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20can%20be%20done.%20Here's%20an%20overview.%20There's%20more%20detail%20on%20my%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftothecloud.com%2F2019%2F03%2F01%2Fexport-items-from-a-sharepoint-list-to-excel-on-a-recurring-basis-using-flow%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Eblog%3C%2FA%3E%26nbsp%3B-%20hope%20this%20helps.%20Terry%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20313px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84853iCD729645CCCE6144%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22completeflow.jpg%22%20title%3D%22completeflow.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftothecloud.com%2F2019%2F03%2F01%2Fexport-items-from-a-sharepoint-list-to-excel-on-a-recurring-basis-using-flow%2F%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftothecloud.com%2F2019%2F03%2F01%2Fexport-items-from-a-sharepoint-list-to-excel-on-a-recurring-basis-using-flow%2F%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi, 

      I am looking at a way to export a criteria of items from a SharePoint list to Excel on a recurring basis. 

E.g. All items created in a sharepoint list in the past 7 days should be compiled into an Excel document and emailed to management.

 

I've used Flow for basic things in the past but not sure if it can be used for this specific task and how to achieve it.

 

Thanks for any guidance

3 Replies

Scott,

 

This can be done. Here's an overview. There's more detail on my blog - hope this helps. Terry

 

completeflow.jpg

https://tothecloud.com/2019/03/01/export-items-from-a-sharepoint-list-to-excel-on-a-recurring-basis-...

Thanks for the reply. I sort of worked out what I needed to do and built a flow that worked but will now look at your blog and take some guidance from it.

Scott,

Glad to hear you have it working.

Regards,

Terry