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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint Lookup Colu...
Power Automate
Unanswered

SharePoint Lookup Columns not available in power app

(0) ShareShare
ReportReport
Posted on by 7

Hi, my SharePoint list contains lookup columns, however these columns are not visible when I connect the list to my form in Power Apps.  Is there something in the list that I need to change? 

Categories:
I have the same question (0)
  • UdayAdhikari Profile Picture
    450 Most Valuable Professional on at

    Hi @VickyB - I refer to thread below in Power Apps forum for answers to your question. I have stopped using lookup columns in SP as mentioned in the discussion, you may want to consider that.

    https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-lookup-column-with-powerapps/m-p/519999

     

    Thanks

    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.

  • VickyB Profile Picture
    7 on at

    Hi @UdayAdhikari , thank you for your response.  I failed to advise that I'm trying to display lookup columns within a gallery.

     

    I have a list called Cohorts that contains a lookup column called Stakeholders (refers to list called Stakeholder names), I've inserted a gallery and connected my data source, being the list called Cohorts.  The column called Stakeholders does not appear when I go to select or change my fields to display.  

     

    does that explain things better?

     

  • UdayAdhikari Profile Picture
    450 Most Valuable Professional on at

    @VickyB - appreciate the additional details. Shane Young has a YouTube video covering your exact question:

    https://www.youtube.com/watch?v=43ekj5MlNJU

     

    Give this a try and let us know if you have any additional questions.

     

    Thanks

    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.

     

  • MattWeston365 Profile Picture
    1,701 on at

    Hi @VickyB lookup columns are supported in SharePoint, but Power Apps struggles when you have a lookup field which allows multiple selections. In a single selection scenario, the lookup field will appear in your list of fields quite happily. But when you have multi select it returns the data differently, it returns a table of data rather than just a single record.

     

    In my example, my lookup column is called "Test" (imaginitive I know!). So if I have a gallery pushing out the main data in my list, I need a gallery inside that which is going to show the items from my lookup field. You won't be able to use the data source selector for the data source, but you can select the "Items" property, and type in ThisItem.<your field name> e.g. ThisItem.Test. Once you have wired up the gallery, you can then add your controls (labels etc) and then use your field selector as normal. You'll have the option of ID and Value.

    MattWeston365_0-1597219333922.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard