cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikaelSvenson
Kudo Collector
Kudo Collector

Specify columns to include when fetching a SharePoint item

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
abm
Super User
Super User

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?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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.

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,152)