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 III
Super User III

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 blogPower 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 blogPower 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.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,552)