Import related data

(1) Share

Report

Posted on by MK-02061724-1

I am new to PA. I am trying to build my first app (an asset management app).

I have just started and have 2 tables (Categories & Sub-Categories) that look like this:

Categories:

Sub-Categories:

In Sub-Categories the Name in the Category field matches the name in the Category table Name Field.

The Category Column looks like this:

The Mapping during Import looks like this: (not sure what acca_categoryname is in the 2nd row?)

These 2 export files come from an existing Asse management program and the names in the Category field in Sub-Categories do Match those int he Category table. However, when I do the import, the category field is blank. If I try to edit that for a record and start typing I do get the lookup hints from the Category table.

What am I missing? Did I miss a step?

TIA,

Categories:

Microsoft Dataverse with Power Apps

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

MichaelFP 2,001 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

When do the mapping have you mapped the field name in category, on the category lookup field on the subcategory table?

Was this reply helpful? Yes No
MK-02061724-1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

When I create the Category field in the Sub-Categories table, it only asks me what table to map to not which field.

Was this reply helpful? Yes No
MK-02061724-1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

So here is the "Relationship":

Was this reply helpful? Yes No
MK-02061724-1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried deleting the tables and recreating then re-importing the data. When I go to import for Sub-Categories, I get this:

What is the acca_categoryname vs acca_category? My Sub-Category table has 2 columns I will use 1) Name (default/primary used for the Sub-Category name) and 2) Category (the lookup value from the Categories table.

If I Accept the Match for acca_category and map that to the Category column in the csv file, and map Sub-Category to acca_name, nothing imports.

If I Reject the Match and map Category to acca_categoryname, I get the import but the data in the Category column is blank. and I only have the Sub-Category Names.

Was this reply helpful? Yes No
Verified answer

MK-02061724-1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Figured it out... I was still in the designer and not in the APP. Didn't know it wouldn't work in the designer...

Was this reply helpful? Yes No