web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Referencing Lookup Col...
Power Apps
Answered

Referencing Lookup Columns in Sharepoint lists

(0) ShareShare
ReportReport
Posted on by PeterDonohue 162

I have 1 List - Master Project List. This has Project Name / Project Owner / Project Sponsor columns

I have a second List - Project Charter List

Project Charter List has a Lookup Column to the Column Project Name in Master Project List as well as Project Scope and Project Resource columns

 

I have a form based on Project Charter list in my PowerApp

I want the first 3 fields in the form to be from Master Project List 

 

Project Name (Dropdown)

Project Owner (pre-populate based on Project Name)
Project Sponsor (pre-populate based on Project Name)


I want the rest of the fields to be filled in by the user

Is that possible?

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 156,417 Most Valuable Professional on at

    Hi @PeterDonohue ,

    If they are read-only, you can do this with labels in a custom card with a Lookup. You have not said what common field joins the list - I will call them Join1 and Join2 below - you would need something like

    Lookup(
 'MasterProjectList,
 Join1 = ThisItem.Join2
).'Project Name'

    and so on for the rest of them

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • PeterDonohue Profile Picture
    PeterDonohue 162 on at

    @WarrenBelz yeah, it's a little confusing.

    I tried

    LookUp('Master Project List','Project Name' = ThisItem.'Project Name'.Value,'Project Manager'.DisplayName)

    and there are no errors, it just doesn't return anything? I know I'm missing something in there, I just can't nut it out hahaha 

  • v-yutliu-msft Profile Picture
    v-yutliu-msft Microsoft Employee on at

    Hi @PeterDonohue ,

    Do you want to pre-populate the value of Project Owner and Project Sponsor based on the selected of Project Name?

    If so, you could set like this:

    1)Project Name Dropdown's Items:

    Choices('Project Charter'.'Project Name')

     2)label's Text for Project Owner:

    LookUp('Master Project','Project Name'=drop down1.Selected.Value,'Project Owner')

      3)label's Text for Project Sponsor:

    LookUp('Master Project','Project Name'=drop down1.Selected.Value,'Project Sponsor')

    Then these two labels will display data based on the selected value of the lookup field.

     

     

    Best regards,

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 156,417 Most Valuable Professional on at

    Hi @PeterDonohue ,

    Using your syntax

    LookUp(
 'Master Project List',
 'Project Name' = ThisItem.'Project Name'.Value,
).'Project Owner'

    and 

    LookUp(
 'Master Project List',
 'Project Name' = ThisItem.'Project Name'.Value,
).'Project Sponsor'

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • PeterDonohue Profile Picture
    PeterDonohue 162 on at

    Hmmmm, still no luck. A bit more detail..

    Project Owner / Sponsor are people fields so I have to specify the attribute but still not working. @WarrenBelz Can I ask why you put the .'Project Owner' outside the brackets and don't specify a Result in the lookup? (I'm just learning hahaha)

  • Verified answer
    PeterDonohue Profile Picture
    PeterDonohue 162 on at

    Ok, I got it 🙂

    I had to reference the  Text explicitly (will look more into this as I'd rather use the Record ID if I can) but this works 🙂

     

    LookUp(
 'Master Project List',
 Label19.Text = ThisRecord.'Project Name',
 'Project Owner'.DisplayName
)

     

  • WarrenBelz Profile Picture
    WarrenBelz 156,417 Most Valuable Professional on at

    OK @PeterDonohue ,

    but you have marked your own post as the solution.

  • PeterDonohue Profile Picture
    PeterDonohue 162 on at

    Is that an issue @WarrenBelz ? What I put in was the solution so I figured it was best to mark it as such

  • WarrenBelz Profile Picture
    WarrenBelz 156,417 Most Valuable Professional on at

    @PeterDonohue .

    Totally up to up but you should also mark a post that helped to get there (would you have figured it out without the post)?

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 150 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans