Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Microsoft Dataverse / Power Up Challenge: Er...
Microsoft Dataverse
Answered

Power Up Challenge: Error Importing Excel Table with Relationship in Dataverse

(1) ShareShare
ReportReport
Posted on by CU09090954-0 21

Greetings! 

I am in the middle of Power Up Learning course. First task is to make model-driven app.
I have imported the Shelter Table with a primary key of Shelter ID with no problem.
I have created a Foster Family table with a column lookup (Local Shelter) to first table Shelter Table (Shelter ID column).
 
I had this error when importing data to the Foster Family table.
Please help. I can't use dataflow because of free account.
Attached are the tables and the error logs. 
Thank you!
Categories:
Microsoft Dataverse
Shelter table fin...
Foster family inf...
tr_fosterfamilies...
  • Verified answer
    CU09090954-0 Profile Picture
    CU09090954-0 21 on at
    Power Up Challenge: Error Importing Excel Table with Relationship in Dataverse
    hi guys, thanks for the replies.
     
    my csv table is fine.
     
    I found a solution to my problem with the steps below:
     
    1. On my lookup (first) table, I added a new key referencing my primary key (not the default primary key of dataverse table)
    2. On my second table, I created a column with lookup that matches the schema name of the primary key on the first table. 
  • Jonathan Manrique Profile Picture
    Jonathan Manrique 2,682 on at
    Power Up Challenge: Error Importing Excel Table with Relationship in Dataverse
    Hi 
     
    The error that appears in the third file is clear, when it tries to resolve the value of the search column it does not find it, you must check that it is written the same in Excel as in the Dataverse table, otherwise it will always fail.
     
    Also check the way you are saving the csv with comma or semicolon separator
     
    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    You can accept more than one post as a solution
    Follow me on Linkedin, I talk about Power Platform
    www.linkedin.com/in/jonathan-manrique-rios
     
  • Suggested answer
    FLMike Profile Picture
    FLMike 23,258 on at
    Power Up Challenge: Error Importing Excel Table with Relationship in Dataverse
    Hi,
     
    This usually means you have a typo, probably in your lookup column.
     
    Go back to our Tables, do not look at the LABEL Text, look at the schema name
    or bring pictures here to help you, but my guess is your lookup has a typo in it
    so your import fails.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,719

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans