web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Power Up Program Community
Unanswered

Error on importing data into dataverse Parking Requests

(3) ShareShare
ReportReport
Posted on by 38
HI ,
 
I am receiving the attach error when trying to import Parking requests.
 
Could you please advise how to resolve?
 
Thanks
Maria
Categories:
I have the same question (0)
  • RT-22040501-0 Profile Picture
    150 on at
    Hello
    Please post a picture of the error not a zip file.  Most people would like to help but seeing zip files or other type of attachments is a security risk that the majority will not take.
     
    Rafael
  • MM-06051525-0 Profile Picture
    38 on at
    Goodmorning,
     
    The error is the below:
    Record Field Error            
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:35:00.000Z','mm_parkingrequestname':'PR-994053','mm_vehicle':'CDE 121K'} Couldn't resolve the guid for the lookup field: mm_vehicle. CDE 121K.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:39:00.000Z','mm_parkingrequestname':'PR-994054','mm_vehicle':'BCD 202B'} Couldn't resolve the guid for the lookup field: mm_vehicle. BCD 202B.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:53:00.000Z','mm_parkingrequestname':'PR-994052','mm_vehicle':'CDE 334P'} Couldn't resolve the guid for the lookup field: mm_vehicle. CDE 334P.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-09-02T16:42:00.000Z','mm_parkingrequestname':'PR-994057','mm_vehicle':'ABC 123X'} Couldn't resolve the guid for the lookup field: mm_vehicle. ABC 123X.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:51:00.000Z','mm_parkingrequestname':'PR-994058','mm_vehicle':'DEF 456Y'} Couldn't resolve the guid for the lookup field: mm_vehicle. DEF 456Y.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:54:00.000Z','mm_parkingrequestname':'PR-994059','mm_vehicle':'EFG 303C'} Couldn't resolve the guid for the lookup field: mm_vehicle. EFG 303C.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:53:00.000Z','mm_parkingrequestname':'PR-994062','mm_vehicle':'WXY 909I'} Couldn't resolve the guid for the lookup field: mm_vehicle. WXY 909I.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T08:58:00.000Z','mm_parkingrequestname':'PR-994063','mm_vehicle':'UVW 787Q'} Couldn't resolve the guid for the lookup field: mm_vehicle. UVW 787Q.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:55:00.000Z','mm_parkingrequestname':'PR-994064','mm_vehicle':'FGH 232L'} Couldn't resolve the guid for the lookup field: mm_vehicle. FGH 232L.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T08:36:00.000Z','mm_parkingrequestname':'PR-994065','mm_vehicle':'VWX 222E'} Couldn't resolve the guid for the lookup field: mm_vehicle. VWX 222E.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:39:00.000Z','mm_parkingrequestname':'PR-994068','mm_vehicle':'GHI 789Z'} Couldn't resolve the guid for the lookup field: mm_vehicle. GHI 789Z.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:49:00.000Z','mm_parkingrequestname':'PR-994069','mm_vehicle':'HIJ 666I'} Couldn't resolve the guid for the lookup field: mm_vehicle. HIJ 666I.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:34:00.000Z','mm_parkingrequestname':'PR-994055','mm_vehicle':'ABC 909S'} Couldn't resolve the guid for the lookup field: mm_vehicle. ABC 909S.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:42:00.000Z','mm_parkingrequestname':'PR-994067','mm_vehicle':'FGH 445Q'} Couldn't resolve the guid for the lookup field: mm_vehicle. FGH 445Q.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:48:00.000Z','mm_parkingrequestname':'PR-994071','mm_vehicle':'IJK 343M'} Couldn't resolve the guid for the lookup field: mm_vehicle. IJK 343M.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:56:00.000Z','mm_parkingrequestname':'PR-994072','mm_vehicle':'JKL 321A'} Couldn't resolve the guid for the lookup field: mm_vehicle. JKL 321A.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:34:00.000Z','mm_parkingrequestname':'PR-994074','mm_vehicle':'KLM 777J'} Couldn't resolve the guid for the lookup field: mm_vehicle. KLM 777J.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:42:00.000Z','mm_parkingrequestname':'PR-994073','mm_vehicle':'KLM 505E'} Couldn't resolve the guid for the lookup field: mm_vehicle. KLM 505E.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T08:51:00.000Z','mm_parkingrequestname':'PR-994076','mm_vehicle':'VWX 222E'} Couldn't resolve the guid for the lookup field: mm_vehicle. VWX 222E.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-02-09T16:47:00.000Z','mm_parkingrequestname':'PR-994066','mm_vehicle':'BCD 444G'} Couldn't resolve the guid for the lookup field: mm_vehicle. BCD 444G.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:48:00.000Z','mm_parkingrequestname':'PR-994077','mm_vehicle':'WXY 112N'} Couldn't resolve the guid for the lookup field: mm_vehicle. WXY 112N.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:39:00.000Z','mm_parkingrequestname':'PR-994078','mm_vehicle':'WXY 909I'} Couldn't resolve the guid for the lookup field: mm_vehicle. WXY 909I.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T16:54:00.000Z','mm_parkingrequestname':'PR-994079','mm_vehicle':'LMN 454N'} Couldn't resolve the guid for the lookup field: mm_vehicle. LMN 454N.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-04-09T16:42:00.000Z','mm_parkingrequestname':'PR-994080','mm_vehicle':'NOP 606F'} Couldn't resolve the guid for the lookup field: mm_vehicle. NOP 606F.
    new record Field: mm_vehicle, Row: {'mm_parkingrequestdatetime':'2024-03-09T08:42:00.000Z','mm_parkingrequestname':'PR-994082','mm_vehicle':'UVW 787Q'} Couldn't resolve the guid for the lookup field: mm_vehicle. UVW 787Q.
     
  • timl Profile Picture
    36,383 Super User 2025 Season 2 on at
     
    For the benefit of others, I pasted the content of your file beneath.
     
    The error you see indicates that those vehicles cannot be found in your vehicles table. 
     
    Therefore, can you open your vehicles table and confirm that you can see the registration numbers of those vehicles that are marked in the spreadsheet? 
     
  • Verified answer
    RT-22040501-0 Profile Picture
    150 on at
    Hello
     
    the recommended way to do the import is:
    1. import vehicles
    2. import requests
    3. import inspections
     
    Do not try to import from the dataverse. It gave me errors.  Instead do the imports from powerapps when doing the model-driven app, at least that worked for me.
     
    Rafael
  • MM-06051525-0 Profile Picture
    38 on at
    Hi Rafal,
     
    I imported Vehicles table from Dataverse succesfully.
     
    I succesfully uploaded from Model Driven app.
     
    Thanks 
     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Microsoft Power Up Program Community

#1
timl Profile Picture

timl 512 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 62 Super User 2025 Season 2

Last 30 days Overall leaderboard