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 Apps / ShowColumns with a loo...
Power Apps
Unanswered

ShowColumns with a lookup column

(0) ShareShare
ReportReport
Posted on by 315

I'm trying to improve the speed of an app. I want to use "showcolumns" as most of the tables only have a few relevant columns that I need. 

I cant seem to filter on a relationship column? Is there a solution for this?

 

ClearCollect(col_PMMS_Site_Items,Filter(ShowColumns(PMMS_Site_Items,"cr20b_site","cr20b_PMMS_Sites"),PMMS_Sites.ID = selectedSite));

 

 

nick9one1_0-1665999864998.png

 

I have the same question (0)
  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @nick9one1, I am assuming that your issue is the Lookup column. Lookup columns should be constructed as below when used in a formula:

    TableWhereYouHaveTheLookupColumn.LookupColumnName.ColumnInTheRelatedTable

     

    Now, to help you with your Formula:

    1. Is PMMS_Sites the table name that has the Lookup Column?
    2. What is the Column name in the Related table that should have the selectedSite values?

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

     

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 Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard