Look up filed delegation issue SharePoint-PowerApp

Brass Contributor

Hello All,

 

I have two SharePoint lists.

1-Contract List

IDContract NameCustomer Name(Look Up from Customers List below)
1  
2  

 

2-Cusomers List

IDCustomer Name
1Dell
2HP
3IBM
4Microsoft
 over 200.000 customers

 

There are over 20.0000 customers in the Customer List.

I want to create a Power App form for the Contract List. I am extracting customer name data from the Customer List as look up.

 

It gives me an error and do not let me to create the PowerApps form for the contract list.

 

I guess there is a way around to manipulate it with delegation. But I do not know how to do it.

 

I would appreciate if someone could help me out on this issue.

 

Thanks

 

3 Replies

@Naligurtan what is the error because there isn’t a reason you can’t do that because of a lookup column I use them all the time. 

@ChrisWebbTech Please see the screenshot of the error. 

Error.png

That doesnt tell me much. This doesnt even look like an error in powerapps. Usually this stems from sorting or filtering on a column that is not indexed in the Sharepoint list with the large number of items.