Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Lookup field not getting populated after excel import



I have an entity with certain lookup columns which point to other entities, created an app on top of this entity, download the excel and filled it with some values. When i import that excel into the app some of the rows were missing. Noticed that those rows for which the lookup table was huge were getting missed out however other rows where the lookup tables were small got loaded.


Also, if the load is unsuccessful there is no error message other than determining it by check if all the rows were loaded or not. 


Is this expected behaviour that if lookup table is huge then those rows cannot be imported and we could not see any message for the rows that werent imported.


Helpful resources


Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users


We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (25,973)