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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup column saving t...
Power Apps
Suggested Answer

Lookup column saving the wrong value

(0) ShareShare
ReportReport
Posted on by SR-30100126-0 6
I have a canvas app for reporting incidents and have a look up field called "Affected Person" which has a list of employees to choose from to show who has been affected by the incident. Having the issue where if there are employees with the same name (but different IDs), the wrong employee is being added to the lookup when saved.
 
E.g - John Smith (1129) selected but when saved it is saved with John Smith (1140).
 
Any ideas on why this would be happening?

Thanks,
Categories:
Building Power Apps
  • ronaldwalcott Profile Picture
    ronaldwalcott 3,914 Moderator on at
    You probably need to provide some more details as the obvious answer would be that the user chose the wrong person.
    Is this also occurring when there isn't a similar name?
    Are you sorting on name anywhere or performing a lookup on name where the first matching name is chosen. 
  • Suggested answer
    Inogic Profile Picture
    Inogic 1,297 Moderator on at
    Hi,
     
    To prevent confusion when employees share the same name, you can display both the employee's name and ID in the dropdown or combo box. To do this, set the lookup field’s  “DisplayFields”  property to:

    ["fullname & ' (' & ID & ')'"]

    This format will show each employee as, for example, John Smith (1129), helping users select the correct employee. Alternatively, you can substitute another field in place of ID if a different identifier better suits your needs.

    Hope this helps.
     
    Thanks!
    Inogic Professional Services: Power Platform/Dynamics 365 CRM
    An expert technical extension for your techno-functional business needs
    Drop an email at crm@inogic.com 
    Service: https://www.inogic.com/services/ 
    Tips and Tricks: https://www.inogic.com/blog/ 

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 320

#3
Mohsin Ali Profile Picture

Mohsin Ali 246

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans