Answered

Get items from sharepoint with column data only

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (10)

Answers (1)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

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!
Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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

cheers
Dan
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous did you manage to find a way to do this quickly?
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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