Specify columns to include when fetching a SharePoint item

[MikaelSvenson]

I have a get SP item action against a list which has many taxonomy and lookup fields. The query fails with the infamous "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator."

Would it be possible to have an option to specify which fields to return, or have a version of the get items action which take odata filters, but I don't want a collection back....or if the items could return just one item if you specify to only get one item back.

Or what is the preferred approach?

[abm]

Hi @MikaelSvenson,

That error is a limitation of SQL.

https://social.technet.microsoft.com/Forums/en-US/ba240e0c-2435-4215-bb70-41b374634172/the-query-can...

Can you please get a screenshot of your flow?

[MikaelSvenson]

Hi,

I know it's a limitation 🙂 Hence specifying only the needed fields using for example odata filter would work. Doing screen shots on my mobile device is too cumbersome, but basically a get item task based on an ID against said list.

[abm]

Hi @MikaelSvenson,

I just tried the ODATA filter for SharePoint Get list item and it ignored my filter condition. Not sure this is implemented yet. There are other posts in this forum described about ODATA filter is not yet implemented.

Thanks

[v-monli-msft · Accepted solution]

Hi Mikael,

Like @abm said, in this thread:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Logic-Flow-Get-Items-Filter/m-p/636#M616\

One user said that "confirmed with the PG that this functionality has not been implemented yet. It's in the plan to support filter query. We don't have a timeline right now."

Mona