I trying to find: When a user PowerApps in with my name, the system looks up the 'Full Name' to match the current user, and then displays that name in columns such as 'Assign,' 'Principal,' etc as value. That’s which will show as name in Advisor Assign on the screen from match the full name is based on user current on PowerApps.
Like that? Lookup('DHS Students Users', 'Full Name'=User().FullName, 'Advisor Assign'.Value))
Thank you for help! It's working now! Also, can you check another post I still need to help with SharePoint. Link: Lookup Sharepoint to PowerApps - Power Platform Community (microsoft.com)
Hi , @dylandavis09
Can you try to use this code in your side :
LookUp('DHS Students Users','Full Name'= User().FullName).'Advisor Assign'.Value
If this return blank, you need to check the User().FullName[You can put it in the label to display] is the same as the text in your sharepoint list. You can also use :
LookUp('DHS Students Users',Upper('Full Name')= Upper(User().FullName)).'Advisor Assign'.Value
Best Regards,
Yueyun Zhang
As for SharePoint, the 'Full Name' is stored as text in a column, not as an email address. Therefore, we need PowerApps to perform a lookup in SharePoint's 'Full Name' based on a match with the currently logged-in user in PowerApps. After this, we will filter the Advisor Assign choices to find the corresponding value. This will be displayed on the screen, indicating 'Missy Kaler' based on a match with your full name.
Hi , @dylandavis09
Thanks for your quick response ! Dose it get an error code(if this can you share me the error code screenshot) or just return a blank value in your side ?
And if you use the " Lookup('DHS Students Users', 'Full Name'=User().FullName) " or " Lookup('DHS Students Users', 'Email'=User().Email) " can return a record in your side?
Best Regards,
Yueyun Zhang
Still not working.
Hi, @dylandavis09
According to your Expression, Your Expression seems to have one more parentheses. You can try to use the :
Lookup('DHS Students Users', 'Full Name'=User().FullName, 'Advisor Assign'.Value)
If you still get an error , you can also first check this code can return the right value:
Lookup('DHS Students Users', 'Full Name'=User().FullName)
And you also need to check if the User().FullName is the same as your item in SharePoint.
If your case is inconsistent, you can use the Upper() function to control the case,like this:
Lookup('DHS Students Users', Upper('Full Name')=Upper(User().FullName), 'Advisor Assign'.Value)
You can also use the Email field to lookup to find the corresponding value.
Best Regards,
Yueyun Zhang
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional