Unanswered

Parse object from PowerAutomate

(1) Share

Report

Posted on by buszi99

Hi. I want to send a whole JSON array with SharePoint list item to PowerApps. This object comes from 'Send HTTP request to SharePoint', because i don't see any different method than this because a network error occures "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by administrator"

How I can parse this in powerapps and then show these values?

Best Regars,

Kamil

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

HI @buszi99 , You need to make sure that in your SP list you do not have more than 12 lookup column in the view. This the limit set by Microsoft.

Please check this and this post.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
buszi99 on at

Like (1)

Report

There is a limit and I need to find a walkaround.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

@buszi99 For the workaround i shared the post in my previous answer, I hope you have gone through it. It says this:

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
buszi99 on at

Like (1)

Report

I made a view with only few columns (no lookup) and in powerapps when I run this:
ClearCollect(
newcoll,
LookUp(
Requests3,
ID = 1
)
); still the same error.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
@buszi99 The default view which is All Items should have less lookup column. Do one thing, whatever new view you have created, make that as default using this:

Click on newly created view from List Setting.

And then try again.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
buszi99 on at

Like (1)

Report

I made view2 as default.
When i try to read same error.

Was this reply helpful? Yes No