SOLVED

Filter and export a List view

%3CLINGO-SUB%20id%3D%22lingo-sub-1581316%22%20slang%3D%22en-US%22%3EFilter%20and%20export%20a%20List%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581316%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Sharepoint%20List%20that%20I%20have%20created%20several%20views%20for.%20I%20am%20needing%20to%20know%20how%20I%20can%20filter%20the%20view%20and%20then%20export%20the%20filtered%20data%20to%20Excel.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1581316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1584113%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20and%20export%20a%20List%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F352640%22%20target%3D%22_blank%22%3E%40Tbruns%3C%2FA%3E%26nbsp%3Bbecause%20the%20Export%20to%20Excel%20exports%20the%20full%20list%20what%20you%20need%20to%20do%20is%20create%20a%20new%20view%20of%20the%20list%20from%20the%20All%20items%20view.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20go%20to%20List%20Settings%20and%20scroll%20down%20to%20the%20bottom%20and%20Create%20a%20new%20view%20from%20All%20items.%20In%20my%20example%20I've%20called%20it%20Cook-Fiji%20and%20I'm%20going%20to%20filter%20then%20export%20just%20the%20airports%20from%20the%20Cook%20Islands%20and%20Fiji%20Islands%20from%20my%20airports%20list.%20View%20the%20new%20list%20you've%20just%20created...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterList0.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212021iCB430E4B11A27469%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22filterList0.png%22%20alt%3D%22filterList0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Band%20filter%20it%20by%20the%20columns%20you%20want%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterList.png%22%20style%3D%22width%3A%20382px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212018i58BF59BB3FEFD1C8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22filterList.png%22%20alt%3D%22filterList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterlist0a.png%22%20style%3D%22width%3A%20484px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212019iF0D43597D21DC33E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22filterlist0a.png%22%20alt%3D%22filterlist0a.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20save%20the%20view.%20And%20click%20on%20Export%20to%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterList2.png%22%20style%3D%22width%3A%20809px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212020i3CC5AFA6A718A708%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22filterList2.png%22%20alt%3D%22filterList2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20will%20export%20just%20the%20items%20in%20that%20view%20to%20Excel%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterList-Export.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212023i4B35B71A7EB26495%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22filterList-Export.png%22%20alt%3D%22filterList-Export.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20future%2C%20if%20you%20need%20to%20export%20that%20filtered%20view%20again%20you%20just%20need%20to%20select%20the%20view%20and%20click%20the%20Export%20to%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20Use%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601700%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20and%20export%20a%20List%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601700%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a Sharepoint List that I have created several views for. I am needing to know how I can filter the view and then export the filtered data to Excel. Thank you!

2 Replies
best response confirmed by Tbruns (Occasional Contributor)
Solution

@Tbruns because the Export to Excel exports the full list what you need to do is create a new view of the list from the All items view. 

 

So go to List Settings and scroll down to the bottom and Create a new view from All items. In my example I've called it Cook-Fiji and I'm going to filter then export just the airports from the Cook Islands and Fiji Islands from my airports list. View the new list you've just created...

 

filterList0.png

 

 and filter it by the columns you want:

filterList.png

 

filterlist0a.png

 

Then save the view. And click on Export to Excel

 

filterList2.png

 

That will export just the items in that view to Excel:

 filterList-Export.png

 

In future, if you need to export that filtered view again you just need to select the view and click the Export to Excel.

Rob
Los Gallardos
Microsoft Power Automate Community Super Use

 

Thank you so much!