cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeNJ00 Helper I
Helper I

Export List Items in a View to CSV

Hi,

 

I'm trying to create a flow where when an item is added to a SharePoint list, a CSV is created and placed in a SharePoint library with all of the columns filled out.  I can get close to what I'm looking for through the Flow below, but I'm unable to specify that it pulls the information from a view, and not the whole list.  Is there a way to do this strictly through items in the view?

 

ExportFlow.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Export List Items in a View to CSV

 

Hi @MikeNJ00 ,

 

Limit Columns by view cannot be used as a condition for filtering items. As the test results show, it only limits the display of columns.

It is recommended that you migrate the conditions you used when creating the view to Filter Query, please check this blog for more details on configuring Filter Query:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

In addition, if you have any doubts, please tell us.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Export List Items in a View to CSV

Hi @MikeNJ00 

 

Yes, you can here.

 

2020-01-22 15_39_04-Create your flow _ Power Automate.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Super User
Super User

Re: Export List Items in a View to CSV

In the Get items step, insure that you have the Limit Columns by View with the proper view selected, like so:

ListColumnsByView.png

If that doesn't help, if you could provide an expanded screenshot of your Flow and steps, we could likely better assist you. 

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

MikeNJ00 Helper I
Helper I

Re: Export List Items in a View to CSV

I tried limiting columns by view, but that seemed to only pull in the columns in the view, but still displayed all of the items in the list, even though the view displays items that have a certain criteria.

 

For example.  I have a choice column "Work Division" The choices are "East" "West"

I created a view to only display items that are tagged as "East"

 

I'd like only those items to show in the export if possible

Super User
Super User

Re: Export List Items in a View to CSV

HI @MikeNJ00 

 

I know this is super basic, but check if the view has a * next to it? If so you need to save it by click pick "Save as" and pick the same name you'll include in the action.

 

2020-01-22 16_00_44-PMO - Project - My Projects.png

 

Also, you can use the "Edit Current View" and add all the conditions that you need in this section. I'm almost sure that you have the view but it's not filtering still because the action should fetch the information you see in the view.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

MikeNJ00 Helper I
Helper I

Re: Export List Items in a View to CSV

@manuelstgomes 

 

view is correct and only showing two items you see below.  I have that same view selected in the flow, but my export is still pulling every item in the list

 

View.PNGGetItems.PNG

Community Support
Community Support

Re: Export List Items in a View to CSV

 

Hi @MikeNJ00 ,

 

Limit Columns by view cannot be used as a condition for filtering items. As the test results show, it only limits the display of columns.

It is recommended that you migrate the conditions you used when creating the view to Filter Query, please check this blog for more details on configuring Filter Query:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

In addition, if you have any doubts, please tell us.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (5,078)