Unanswered

Get items from sharepoint with column data only

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
jwhite 191 on at

Like (1)

Report

Hi @Anonymous,
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!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @Anonymous ,

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

cheers
Dan

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
zYx 78 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sergey 2 on at

Like (0)

Report

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".

Was this reply helpful? Yes No