Get items from sharepoint with column data only

[demondan]

Hi

I have a simple list (single column) I am extracting from sharepoint and putting into an array variable in Flow.  I've noticed that each item is extracted as a record with a bunch of data I dont need.  Such as author information, created/modified etc, I only want the Title information.  How do I stop it extracting all this unnecessary information?

thanks!

Dan

[Pstork1]

Use DropColumns() to remove the columns you don't want.  You can also use a view to restrict some of the additional columns

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

[demondan]

How do i use DropColumns - presumably I put it in the filter query part of the sharepoint 'get items'.  I type DropColumns in and its not recognised.  Should it be used as part of a more complex query?

Sorry Im new to flow - trying to figure it out as I go!

thanks

Dan

[Pstork1]

Sorry, I need to shift gears. DropColumns() is one of those functions that only works in PowerApps.  For Flow you can limit columns somewhat by supplying a View from the list to limit which column values are included.  But you'll probably need to build your array using a Loop and append the field you want to the array as you loop through the items.

[jwhite]

Hi @demondan,

I had a similar experience and this post helped me solve it: Re: Selecting columns from array

Let me know if this helps you or if you have any difficulties!

[v-bacao-msft · Accepted solution]

Hi @demondan ,

Please try to use the following configuration.

You could use Select action to extract the specified column.

Or you could use variable to extract field values.

Image reference:

Best Regards,

[demondan]

Thanks everyone, managed it!  Im marking v-baco-msft's post as the solution but all the info provided was really helpful!

cheers

Dan

[demondan]

Hi

Sorry I know i've marked this as answered but I have a further question.  I've managed to strip out all the data i dont want and I end up with an array of the format:

{"Title": "string1"},{"Title": "string2"},{"Title": "string3"}

I feel like im being stupid but ideally i dont want the "Titles" in there either.  I just want the string data, is there an easy way of doing this, I guess i could take each element out and do a split on ":" and extract the second half?  Is there a better way?

thanks

Dan

[zYx]

@demondan did you manage to find a way to do this quickly?

[Pstork1]

If you want them in a string without the "Title": Then change the Append to an Array variable to Append to a String variable and just input the Title dynamic content and any delimiter punctuation you want.

[Sergey]

What is the "value" value and what is "Title" for? Is the "value" the name of the column or its value? And no way to add name to "Append array to variable".