title: Problem while importing Lookup type field from excel into Power Apps Dataverse
body: <p>I have 2 related excel tables, originally came from SQL:</p>
  <p>tbl Program - &quot;Dimension&quot; - with unique records (WHID = primary key):</p>
  <p><a href="https://i.stack.imgur.com/B8AtH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B8AtH.jpg" alt="enter image description here" /></a></p>
  <p>tbl Attendance -&quot;Fact&quot; - with duplicate records (ProgramWHID = foreign key):</p>
  <p><a href="https://i.stack.imgur.com/ukD41.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ukD41.jpg" alt="enter image description here" /></a></p>
  <p>I need to import them into Dataverse and then - to create PowerApp canvas (or any type) Form, based on tbl Attendance.</p>
  <p>So, that the <em>[ProgramName] Attendance</em> field would be a drop-down type, taking data from <em>[ProgramName] Program</em>.</p>
  <p>And so that <em>[ProgramWHID] Attendance</em> value would be automatically populated from <em>[WHID] Program</em>, after user changes / creates record.</p>
  <p>For that I performed the following actions:</p>
  <ol>
  <li><p>Created tbl Program, as</p>
  <p>WHID = Primary Name Column (Text);</p>
  <p>ProgramName = Text</p>
  <p>I really need WHID as &quot;Whole Number&quot;,  but the choices were only &quot;AutoNumber&quot; or &quot;Text&quot;.</p>
  </li>
  <li><p>Created tbl Attendance, as:</p>
  <p>AttendID = Primary Name Column (AutoNumber)</p>
  <p>Date = Date Only</p>
  <p>ProgramName = Lookup (Related table = Program)</p>
  <p>ProgramWHID = Lookup (Related table = Program)</p>
  </li>
  <li><p>Imported tbl Program from excel, mapped fields to create tbl Program in Dataverse</p>
  <p>This table has been imported with no problems.</p>
  </li>
  <li><p>Tried to import tbl Attendance from excel, tried to map fields to create tbl Attendance in
  Dataverse</p>
  <p>Here is the main problem:</p>
  <p>After I mapped all custom fields including ProgramName and ProgramWHID to my excel fields from
  pic above - receiving the following error:
  <strong>&quot;Import Failed&quot;  &quot;Couldn't resolve the guid for the lookup field: cr118_programname&quot;</strong></p>
  </li>
  </ol>
  <p>I am able to import Attendance tbl from excel and successfully map fields - only if my ProgramWHID and ProgramName fields in the Attendance Dataverse table are non Lookup format.
  If I change them to &quot;Text&quot; type, for example, then the import works with no problems!</p>
  <p>But I need those fields to be Lookup - so the data should be coming from Program tbl!</p>
  <p>Do I have to use a different way of creating this relational &quot;Model&quot;?
  Should I try to create &quot;Model Driven&quot; App instead of using Dataverse and the the canvas App?</p>
  <p>Please, H E L P !</p>