Get Items - Only get a single (one) column

(0) Share

Report

Posted on by fnanfne

260

Hi Power People

I have a SharePoint list with dozens of columns.

When using the Get Items action, I want to get this list, but only have ONE column returned called item_code. Chat-GPT failed me (or maybe I failed it?) so hoping one of my fellow meat brains here can help.

My AI friend said I should use the following in the Filter Query field...

?$select=item_code

However, this produces an error..

"The $filter expression "?$select=customer_code" is not valid. Creating query failed."

Please help 🙂

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

fnanfne 260 on at

Like (0)

Report

I managed to find another way. Let Get Items return all items, then just use one column further into the flow, lol

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @fnanfne

You can also limit the columns by creating view in SharePoint and use the same in 'Get items' action as shown below:

Thanks

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report

Awesome! That's another way to scratch the cat, I like it, thanks!

Was this reply helpful? Yes No