Announcements
Hello everyone,can anyone help me with the following issue?I want to lookup a value(not present in office365 user profile) on a text field according to the employee selected on people picker. I tried several options but nothing is working.
Can you send your code so I can review.
I tried several one:1. lookup(sp list, column=datacarddropdown, column) 2. lookup(sp list, column=datacarddropdown.selected).columnThe error message is: Imcompatible type comparison. Text vs Record
Well the issue is that in the Lookup the column value is returning a text value while the drop-down list returns a record. If your drop-down list items are people picker use the code
LookUp(SPList, column = datacarddropdown.Selected.Name).column
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 94
WarrenBelz 82 Most Valuable Professional
Kalathiya 38 Super User 2026 Season 1