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 / How to search by perso...
Power Apps
Answered

How to search by person to find further details

(0) ShareShare
ReportReport
Posted on by

Hi all 

 

I have a sharepoint list which I have imported into power apps: 

 

Screenshot 2022-10-06 at 12.45.14 PM.png

 

 

Screenshot 2022-10-06 at 12.48.06 PM.png

 

How do I creating something in this app to allow me to search by pupil? 

 

The pupil field is a Person field within sharepoint

 

Please help!

Categories:
  • Feiteira Profile Picture
    199 on at

    Hi there @AB21 

     

    First of all, I sugest you set the names of the components accordingly so if you grow this app to something much larger, you can still keep track of all those labels and text inputs.

     

    Looking at your problem, I supose you will want to filter the Provisions List acording to the pupil searched.

     

    Take a look at what I have done and let me know if it works.

     

    SharePoint List items

    Feiteira_0-1665060249365.png

     

    PowerApp TextInput for Search and Gallery

    Feiteira_1-1665060345943.png

    Let me know if you have any question.

     

     

    Please give this reply a Thumbs Up if it helped you out and don't forget to "Accept as solution" 😀

  • AB21 Profile Picture
    on at

    Hi @Feiteira 

     

    Screenshot 2022-10-06 at 2.00.15 PM.png

     

    Which do I select for me to enter that code you put in your screenshot? 

  • Feiteira Profile Picture
    199 on at

    @AB21 Sorry, forgot to mention that one 😊

    Put that code in the "Items" property of your "Gallery"

    Feiteira_0-1665064136354.png

     

  • AB21 Profile Picture
    on at

    Hi @Feiteira 

     

    Thank you, I have this error when I go to the items im unable to add the "Pupils" field it fails as its a person field I think? 

     

    Screenshot 2022-10-06 at 3.05.35 PM.png

  • Feiteira Profile Picture
    199 on at

    You are trying to show the "Pupils" collumn in a text field, the thing is: a Person field is considered as a Record (or technically an object in terms of programming definition) and in this case I supose you have the ability to select multiple users, so it turns into a table.

     

    A simple fix for that matter is to use the Concat() function in order to show the DisplayName or Email of all those pupils in a single string:

    Try it like this one:

    Concat(
     ThisItem.Pupils,
     Value & "; "
    )

    Doing that will show (for each record in the Provisions list) as following:

    Feiteira_0-1665066477955.png

     

  • AB21 Profile Picture
    on at

    @Feiteira 

     

    Sorry my mistake I need to show a table containing all the columns they appear in like this: 

     

    Screenshot 2022-10-06 at 3.38.25 PM.png

     

    When searching for the pupil 

  • Feiteira Profile Picture
    199 on at

    @AB21 , just to be clear, those fields are from the Provision list right?

     

    Select the Gallery and click on the "Pencil" (edit) button  Feiteira_3-1665071085404.png

     

    Feiteira_0-1665070748074.png

     

    It will look like this

    Feiteira_4-1665071134570.png

     

     

    On the top ribbon, click on "Insert" and add a Label for the same amount of collumns you want to show.

    Feiteira_1-1665070864266.png

     

    Drag and edit those labels to make it the way you want. Then, for each label, insert the "ThisItem." and after the " . " there will show the name of the collumns, just select the collumn you want in each collumn as the example bellow (using a collumn with the name "Assunto").

     

    Feiteira_2-1665071013952.png

     

    Let me know if this helped

     

  • AB21 Profile Picture
    on at

    Hi @Feiteira 

     

    Thanks for this I would like to do this with Pupils (this is a person field) what would the code be for that? 

     

    Screenshot 2022-10-06 at 10.08.13 PM.png

     

    On my first page I have the ability to select the icon I have squared how do this? 

     

    Screenshot 2022-10-06 at 9.58.20 PM.png

    Which opens this

     

    Screenshot 2022-10-06 at 9.59.24 PM.png

     

  • Verified answer
    Feiteira Profile Picture
    199 on at

    @AB21 Lets see if I get it right.

    You want to click on the arrow icon  Feiteira_0-1665159537468.png and open other screen where you will show the selected record. Now, what do you want to show, is it just the "Provisions" selected record?

    If so, try the following:

     

    • When you click on the Icon, put this code in the OnSelect property of the Icon
    • Navigate( Name_of_Screen_you_want, ScreenTransition.None, { selectedProvision: ThisItem} )
    • In the screen that will show the record, add a Form and set its DisplayMode to View.
    • Set the Item property of the form, simply put selectedProvision.
    • At last, choose the fiedls you want to show.
  • AB21 Profile Picture
    on at

    Thank you! @Feiteira 

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard