cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeKi72
Post Patron
Post Patron

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
Post Patron
Post Patron

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
Post Patron
Post Patron

Thanks it works. Gr. P

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!

Users online (4,167)