Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Lookup SharePoint on PowerApps

(0) ShareShare
ReportReport
Posted on by 438

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

  • dylandavis09 Profile Picture
    438 on at
    Re: Lookup SharePoint on PowerApps

    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)

  • Verified answer
    v-yueyun-msft Profile Picture
    on at
    Re: Lookup SharePoint on PowerApps

    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

  • dylandavis09 Profile Picture
    438 on at
    Re: Lookup SharePoint on PowerApps
  • dylandavis09 Profile Picture
    438 on at
    Re: Lookup SharePoint on PowerApps

    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.

  • v-yueyun-msft Profile Picture
    on at
    Re: Lookup SharePoint on PowerApps

    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

  • dylandavis09 Profile Picture
    438 on at
    Re: Lookup SharePoint on PowerApps

    Still not working.

  • v-yueyun-msft Profile Picture
    on at
    Re: Lookup SharePoint on PowerApps

    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

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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard