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)

Sort by

fnanfne 260 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No