cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How To Enter Data in Lookup Field Column

Hello Everyone,
I have a table in Data-verse in that table I have a primary key auto number and some records an one more column of lookup data type now when I import the data through flow or through excel it pick up all the record but did not pick up the record for the lookup column... Means after import it has data in all the column but lookup column is blank.. There is no data in Data-verse table for lookup column but in the excel it has a data for the lookup column.
So how is it possible or how can i resolve this issue.

In referencing table it has a record for the lookup column.
Please Suggest.

Thanks 

2 REPLIES 2
ChrisPiasecki
Super User
Super User

Hi @Anonymous,

 

Did you follow the documented steps for Importing data from Excel using a template? Or are you using the Power Apps Add-in  to edit data directly in Excel?

 

In either case, you need to ensure you provide the primary key (GUID) or an alternate key. Have you set up your auto number column on the Lookup table as an Alternate key ?

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

MayankP
Responsive Resident
Responsive Resident

if you are importing them through power automate flow then I guess you need specify entity type and entity id (just label or name) will not work..

https://linnzawwin.blogspot.com/2019/11/power-automate-how-to-set-lookup-field.html

 

for data flow imports refer following articles..

https://docs.microsoft.com/en-us/power-query/dataflows/relationships-in-standard-dataflows

https://dynamicscitizendeveloper.com/2020/04/21/how-to-map-a-lookup-field-in-a-power-platform-datafl... 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,039)