importing data fails to import lookup values

(3) Share

Report

Posted on by RT-22040501-0

150

Hello

I'm stuck trying to import the data for the powerup challenge. The ParkingRequests table does not get the vehicle column data and the ParkingInspections table does not get the data for vehicle or parkingrequests.

Importing from CSV and importing from Excel do not show the lookup column to be mapped. In this image, i was trying to import from Excel to ParkingRequests, I manually mapped the parkingrequestname and the date and time but there is no option to map the data for the vehicle column.

I was reading from other people's posts but haven't been able to fix this.
any suggestions?

Thanks

Categories:

Final app challenge

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RT-22040501-0

Can you confirm that you've created the Vehicle table and that you've created the relationship/lookup from ParkingRequests to Vehicle?

The best way to carry out this import is to create a model driven app and to import the CSV in the same way that was described in the course. Can you confirm that you're using this approach?

Was this reply helpful? Yes No
Verified answer

RT-22040501-0 150 on at

Like (2)

Report

Tim

thanks for the reply. I have created the tables in dataverse in the order recommended. I made sure the lookup columns are created before trying the import. After that, I tried the import from within the dataverse, which fails.

I created a few records manually, so I know the lookup works as expected.

thanks for reminding me to do this from the Model-Driven app. I thought importing from dataverse was the same and got stuck with that idea but it does not work the same way. Anyway, doing it from the Model-Driven app works fine.

For others having this issue, do the import from the model driven app. If you do not remember how, check out the video "Building Model-Driven apps for a school with MS Dataverse", step 14 shows how to do this from Power Apps.

thanks appreciate the help,
Rafael

Was this reply helpful? Yes No
FRAZ.AHMAD 47 on at

Like (0)

Report

hi

what about data import for parking inspection table? it still shows errors even with model driven app.

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report

Thanks Rafael for your update - I'm' glad you got this work.

For anyone else reading this, here's the follow on post from FA-06050254-0 regarding the parking inspection table import.

https://community.powerplatform.com/forums/thread/details/?threadid=97923250-ae2b-f011-8c4d-7c1e52027a5f

Was this reply helpful? Yes No

Join the conversation

Community site session details

importing data fails to import lookup values

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates

Community site session details

importing data fails to import lookup values

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates