Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 793 Most Valuable Professional
Michael E. Gernaey 333 Super User 2025 Season 2
Power Platform 1919 268