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

All responses (6)

Answers (0)

buszi99 on at

Like (1)

Report

Re: Parse object from PowerAutomate

I made view2 as default.
When i try to read same error.
ANB 7,075 Super User 2025 Season 1 on at

Like (1)

Report
Re: Parse object from PowerAutomate

@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
buszi99 on at

Like (1)

Report

Re: Parse object from PowerAutomate

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.
ANB 7,075 Super User 2025 Season 1 on at

Like (1)

Report

Re: Parse object from PowerAutomate

@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
buszi99 on at

Like (1)

Report

Re: Parse object from PowerAutomate

There is a limit and I need to find a walkaround.
ANB 7,075 Super User 2025 Season 1 on at

Like (1)

Report

Re: Parse object from PowerAutomate

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