Skip to main content

Notifications

Community site session details

Community site session details

Session Id : erWFHd6vJN6PGaHxe/LjTN
Power Apps - Building Power Apps
Answered

Lookup SharePoint on PowerApps

Like (0) ShareShare
ReportReport
Posted on 1 Nov 2023 03:44:43 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 01 Nov 2023 at 04:16:59
    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 01 Nov 2023 at 04:11:35
    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 01 Nov 2023 at 04:06:30
    Re: Lookup SharePoint on PowerApps
  • dylandavis09 Profile Picture
    438 on 01 Nov 2023 at 04:04:26
    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 01 Nov 2023 at 04:04:12
    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 01 Nov 2023 at 03:58:48
    Re: Lookup SharePoint on PowerApps

    Still not working.

  • v-yueyun-msft Profile Picture
    on 01 Nov 2023 at 03:56:11
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 20

#2
BCBuizer Profile Picture

BCBuizer 10 Super User 2025 Season 1

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

Overall leaderboard