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 🙂

All responses (3)

Answers (0)

fnanfne 260 on at

Like (0)

Report

Re: Get Items - Only get a single (one) column

Awesome! That's another way to scratch the cat, I like it, thanks!
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Get Items - Only get a single (one) column

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
fnanfne 260 on at

Like (0)

Report

Re: Get Items - Only get a single (one) column

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