Answered

How to import into lookup field using alternate key?

(0) Share

Report

Posted on by michael-w

I'm trying to import excel files into pet table. The pet table contains a pet_owner field. GUID is hard to retrieve, I don't want to use GUID, I want to use alternate keys. Can I use Web API style addressing method to uniquely identity a pet_owner, perhaps looks like pet_owners(external_id='U001') ?

25-excel-with-guid

I have tried but failed, the error message is 'The lookup reference could not be resolved.'

Background:

I have two tables: pet_owner and pet. Pet table has a pet_ownerid field.

Pet table has an alternate key with only one column: external_id.

Pet_owner table has an alternate key with only one column: external_id.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @michael-w,

Please walk through the following doc as it outlines how to import the data with the alternate key...
https://docs.microsoft.com/en-us/powerapps/user/import-data

Hope this helps!

Thanks,
Drew

Was this reply helpful? Yes No
Kundan Sah 45 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Excel upload will always match with primary name field. please use name instead of guid

Was this reply helpful? Yes No
Verified answer

michael-w 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks @dpoggemann . I have found the solution. While import, click Review Mapping button, click the "magnifying glass" icon,will open Lookup reference section, change to external_id.

Refer this link https://docs.microsoft.com/en-us/powerapps/user/import-data

Was this reply helpful? Yes No