Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Up Program - Power Up Final Challenge / Errors Uploading Parki...
Power Up Program - Power Up Final Challenge
Suggested answer

Errors Uploading Parking Requests csv Data to Parking Requests Table

(2) ShareShare
ReportReport
Posted on by CU02060038-0 2
Hi there, 
 
I imported the vehicle csv data successfully to the Vehicles table but when I went to try and import the data into the Parking Requests table, I keep getting error messages: Couldn't resolve the guid for the lookup field: pa_vehicleid. DEF 020T. (among others with different vehicle names). 
 
Here's the troubleshooting I've done so far: 
  • Deleted all the tables (and the solution) and started over 
  • In the Parking Request table, checked the Data Model file to make sure that the ParkingRequestName isn't set to Autonumber yet because I can see the Parking Requests csv first column is PR-99xxxxx. 
  • Checked the column relationships for the "Vehicle" column in Parking Request table and made sure it is a lookup to the 'pa_Vehicle' table
  • I compared the license names (DEF 020T) in the Parking Request csv to the actual data I imported and verified that they do exist in the Vehicles table. Only 2 vehicles in the vehicles table are not present in the Parking Request table but that seems ok because I'm assuming some vehicles may not have requested parking
  • Tried replacing the vehicle name (DEF 020T) column in the csv file with the actual pa_VehicleID unique vehicle IDs which were created after I imported the vehicle data into that table
Kind of at a loss of what to do right now! Hoping someone can help :) 
Categories:
General Discussion
pa_parkingrequest...
  • CU08050024-0 Profile Picture
    CU08050024-0 10 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    The below suggestion worked for me.  Thanks!
  • Suggested answer
    w.p Profile Picture
    w.p 4,593 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    you can't using import option in the designer.
     
  • CU08050024-0 Profile Picture
    CU08050024-0 10 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    I'm not sure what I'm missing but when I go into MDA to import from CSV...nothing happens.  I'm beyond frustrated now
  • w.p Profile Picture
    w.p 4,593 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    try to import via MDA
  • AT-03062108-0 Profile Picture
    AT-03062108-0 2 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    Hi all, 
     
    I have the exact same problem. I tried to import from the Parking Request app but for some reason my environment doesn't respond to import thru there. 
     
    I tried change the vehicle licience number with vehicle unique identifier (see example):
    ParkingRequestName ParkingRequestDateTime GUID_vehiecle
    PR-994052 9/2/2024 16:53 177c9884-b040-f011-b4cb-002248325ed5
    PR-994053 9/2/2024 16:35 127c9884-b040-f011-b4cb-002248325ed5
    PR-994054 9/2/2024 16:39 117c9884-b040-f011-b4cb-002248325ed5
    PR-994055 9/2/2024 16:34 147c9884-b040-f011-b4cb-002248325ed5
    PR-994056 9/2/2024 16:49 187c9884-b040-f011-b4cb-002248325ed5
    PR-994057 9/2/2024 16:42 157c9884-b040-f011-b4cb-002248325ed5
    PR-994058 9/2/2024 16:51 167c9884-b040-f011-b4cb-002248325ed5
    PR-994059 9/2/2024 16:54 197c9884-b040-f011-b4cb-002248325ed5
    PR-994060 9/2/2024 16:56 347c9884-b040-f011-b4cb-002248325ed5
    PR-994061 9/2/2024 16:34 1a7c9884-b040-f011-b4cb-002248325ed5
    PR-994062 9/2/2024 16:53 337c9884-b040-f011-b4cb-002248325ed5
     
    and I got a new error:
    Record,"Field","Error"
    ,"General error","Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Unable to parse import file eda9c88c5d06480195b120a03175a336.xlsx Error details PQOnline failure - Type=System.Net.WebException, Msg=The remote server returned an error: (400) Bad Request."
     
    Has anyone managed to resolve this...?
     
  • CU02060038-0 Profile Picture
    CU02060038-0 2 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    Sure thing, thank you for the quick replies by the way:
    1. From power apps -> select tables -> click on parking request table -> at the top select import data from excel
     
    2. Selected the file (unzipped and extracted) - mapped the columns as such: 
     
    3. selected 'save changes' and then 'import' 
     
    From reading the comments it seems I should import through the model driven app instead? I would think that this way should still work though. I'll try doing it through the model driven app though, thank you for sharing the link to the other reply. 
  • Suggested answer
    CU05051000-0 Profile Picture
    CU05051000-0 21 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    Hi, are you importing the Parking Requests in the Model Driven App? 
     
  • w.p Profile Picture
    w.p 4,593 on at
    Errors Uploading Parking Requests csv Data to Parking Requests Table
    can you share screenshots to show how you import the data and map the columns?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans