cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mkshannon1979
New Member

Create csv with selected columns from multiple lists (if the list contains xxx)

Hi all, hopefully someone can help. I don't think I'm far away but a little stuck.

 

I want to:

 

  • Get Lists
  • Apply to each
    • Condition
      • If the list contains MHE
        • get items
        • create csv with custom selected columns (this is where I am stuck)
        • create one drive csv file

 

I'm unable to find a way to select custom columns though. Is this possible? Thanks

 

mkshannon1979_1-1618415820711.png

       

 

mkshannon1979_2-1618415891213.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

Yes, just run the normal get items action (containing all columns), then add a select action after which reshapes the data to just the columns that you want. Then use the output of the select as the input for the create CSV action.

View solution in original post

4 REPLIES 4
Paulie78
Super User
Super User

Yes, just run the normal get items action (containing all columns), then add a select action after which reshapes the data to just the columns that you want. Then use the output of the select as the input for the create CSV action.

mkshannon1979
New Member

Thanks @Paulie78 

How do I do that though sorry? 

 

I cannot see any list of columns to select from either the value or body of get items (which are the only 2 options available to me)

 

mkshannon1979_0-1618435759738.png

 

mkshannon1979
New Member

Wowsers, I managed with a bit of googling to work it out. I used 

 

dynamic content and item()?['EmployeeName'] for example and it pulled through correctly. 
 
Thanks @Paulie78, you're a superstar.
Paulie78
Super User
Super User

Well done! 👍🏻👍🏻

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,788)