Answered

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

All responses (10)

Answers (1)

Sergey 2 on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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".
Pstork1 67,035 Most Valuable Professional on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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.
zYx 78 on at

Like (0)

Report

Re: Get items from sharepoint with column data only

@Anonymous did you manage to find a way to do this quickly?
Community Power Pla... on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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
Community Power Pla... on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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

cheers
Dan
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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,
jwhite 191 on at

Like (1)

Report

Re: Get items from sharepoint with column data only

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!
Pstork1 67,035 Most Valuable Professional on at

Like (1)

Report

Re: Get items from sharepoint with column data only

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.
Community Power Pla... on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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 67,035 Most Valuable Professional on at

Like (0)

Report

Re: Get items from sharepoint with column data only

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