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

[mkshannon1979]

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

[Paulie78 · Accepted solution]

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]

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]

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]

Well done! 👍🏻👍🏻