Unanswered

Create Power app form on an existing SharePoint list with more than 12 lookup columns

(0) Share

Report

Posted on by mambiger

Hello everyone, I am new to Power Apps. I am trying to create a customized list form on an existing SharePoint list. I was getting an error "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold" while creating the Power App, because, I just learnt that, the list has more than 12 lookup columns.

I am looking for suggestion as to how to proceed with the power app creation with this existing list. I cannot delete lookup columns from the list.

Thanks

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @mambiger ,

There is no direct way to bypass the 12 LookUp columns threshold of SharePoint lists. Please consider vote for the idea that supports using SharePoint list views as data sources in Power Apps:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/View-in-PowerApps-based-on-sharepoint-list-view/idi-p/168766

Besides, there is a link in that idea which is the tutorial of using flow to get SharePoint list view and pass to Power Apps, please check if it could helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
mambiger 13 on at

Like (0)

Report

Thanks for the reply @v-jefferni . I voted for the idea.

"Besides, there is a link in that idea which is the tutorial of using flow to get SharePoint list view and pass to Power Apps, please check if it could helps." - Can you please give me the link? There are few, I could not understand which one you are referring to.

Thanks

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @mambiger ,

It's the https://www.youtube.com/watch?v=L4pPCDXoL7c

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No