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?
Solved! Go to 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
Hi @MikaelSvenson,
That error is a limitation of SQL.
Can you please get a screenshot of your flow?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi,
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi 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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
43 | |
17 | |
15 | |
14 | |
13 |
User | Count |
---|---|
73 | |
38 | |
27 | |
20 | |
18 |