Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Up Program - Building model-driven apps w... / Search PowerFx function
Power Up Program - Building model-driven apps w...
Unanswered

Search PowerFx function

(1) ShareShare
ReportReport
Posted on by LJ-18030207-0 2
Hi,

Here, if we didn't have StudentFullName as a calculated field, then would there be a way to look for the value from student table like this: 
ThisItem.Student.'Full Name'

or is using search function requires only 1 table?



 
Categories:
General Discussion
  • timl Profile Picture
    timl 35,173 Super User 2025 Season 1 on at
    Search PowerFx function
     
    The Search function can only accept a sing table as the data source. Since the name of the student is a column in the student table rather than the loans table, it's necessary to create the 'student full name' calculated field and to search on that. It's not possible to call the Search function and to search on a related table without the calculated field.
     
    If however you want just to display the student name on a gallery that is bound to the Loans table without creating a calculated field, you can do this by using this ThisItem.Student property. The syntax would look something like this:
      
    ThisItem.Student.'First Name' & " " & ThisItem.Student.'Last Name'
     
  • Michael E. Gernaey Profile Picture
    Michael E. Gernaey 42,786 Super User 2025 Season 1 on at
    Search PowerFx function
     
    Its hard to answer your question without actual details about the tables.
     
    There is no way for us to know if we can help you get the name without understanding how the data on the screen relates to the Table that has the name.
     
    If you can provide that please, that or still need that but we need to search Profiles based on some information on the screen.
     
    I am sure we can figure it out.

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 - Lets Get Started!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans