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 / Use Search text box on...
Power Apps
Answered

Use Search text box on gallery on dataverse lookup column

(1) ShareShare
ReportReport
Posted on by 64

Hi,

 

I am trying to provide  a search function a canvas app gallery by using the input from a text box, the datasource is a dataverse table, but the column I want the users to search on is a lookup column to another table column.  Is this possible ?  I have watched various youtube vids and searched the forums but unable to pinpoint a solution.

 

Many Thanks.

Categories:
I have the same question (0)
  • Verified answer
    poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    @MinotaurUK 

     

    Can you check if the posts I gave in the thread linked below may help you?

     

    Sort functionality on Person column inside gallery from data verse 

     

    Especially the most recent post.

    The example I have is the out of the box Owner field of the Accounts table in Dataverse,

    my custom examples cover both sorting and searching on the Owner field along with being able to search on other fields at the same time.

    For example, both the Account Name and the Owner can be searched on.

    Additional fields may be added too.

     

    My example especially covers displaying (in a Gallery control), sorting on, and searching on the out of the box Owner field specifically in Dataverse, which is different from doing this on other kinds of fields.

     

    This may help you because the approach for displaying, searching, and sorting on the out of the box Owner field in Dataverse may possibly apply to or help with your scenario as well.

     

    See if it helps @MinotaurUK 

  • Verified answer
    CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @MinotaurUK Follow the example given below,

    Filter(myTable, ThisRecord.myLookUpColumn.myTextField=mySearchTextField.Text)
     

    Please remember to give a 👍 and accept my solution as it will help others in the future.

  • MinotaurUK Profile Picture
    64 on at

    Thanks for the replies , its really appreciated.  I found this filter funtion and it works as intended...

    --Filter(datasource,StartsWith('columnname'.'fieldname',textinputbox.Text)).--

     

    I will take a look at both the suggestions above and try them out.  Thanks once again 🙂

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

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 345 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 177

Last 30 days Overall leaderboard