Announcements
I have a table named "Patients" with 9000+ rows of data. Each row has a value in a column named "Insurance". I want to make this field a Lookup field so the user can choose the correct insurance when adding a new record but also show the existing "Insurance" if it is already populated. I have created a lookup column in the "Patients" table called "Insurance Lookup" which points to the table with all of the insurance names ("Insurance Table"). The "Insurance Lookup" field works fine on my form, but I need all of the existing "Insurance" data to populate in this field. How exactly can I achieve this?
Hi @lpatterson7 ,
What's your data source? SharePoint or Dataverse?
Best Regards,
Wearsky
Sorry! It’s Dataverse
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 330
Mohsin Ali 232
