cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeKi72
Helper IV
Helper IV

Can not select the Sharepoint column values in the Create CSV table action

Dear Experts,

In my flow i have use the Create CSV table action to specify which columns i want to get from the Sharepoint get items action.

But I do not get the columns to choose. Instead i get the list properties. What do i do wrong?

 

PeKi72_0-1652022933395.png

Gr. 

Peter

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
CraigStewart
Super User
Super User

You'll need to identify them manually and use your own expression
such as  item()?['Employee']

CraigStewart_0-1652032582365.png

 

View solution in original post

4 REPLIES 4
CraigStewart
Super User
Super User

You'll need to identify them manually and use your own expression
such as  item()?['Employee']

CraigStewart_0-1652032582365.png

 

PeKi72
Helper IV
Helper IV

What if my columns has spaces in it? F.e: my column is called: 00:00 - 07:59

 

 

CraigStewart
Super User
Super User

You can check the name in sharepoint, if you do an order by on your list with the column in question the exact name you need will be in the browser after sortfield=

 

Like this 

?sortField=PlusOneName&isAscending 

 

Assuming you haven't renamed the fields previously then it's usually a case of stripping put the spaces. Above example my column is called 'Plus One Name'

PeKi72
Helper IV
Helper IV

Thanks it works. Gr. P

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,386)