Answered

Lookup SharePoint on PowerApps

(0) Share

Report

Posted on by dylandavis09

442

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))

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

Still not working.

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No