You’re offline. This is a read only version of the page.
30
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') ?
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.
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
Hi,
Excel upload will always match with primary name field. please use name instead of guid
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
