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 link the compan...
Power Apps
Suggested Answer

How to link the company's directory to a field in a form in a Power Apps application ?

(0) ShareShare
ReportReport
Posted on by
Hello,
I am a beginner with power apps and I would need support because I don't know how to parameter the field "Nom du bénéficiaire" to be able to select a colleague (Microsoft user ?), it would be great if I start to type the first letters of the name the entire name is proposed.
Could you help me with that ?
Thanks a lot !
Justine
 
Categories:
I have the same question (0)
  • Suggested answer
    Assisted by AI
    Ruturaj Profile Picture
    41 on at
     use the Office 365 Users connector to drive a choice field inside a standard form, you are essentially replacing a static "Choice" list with a dynamic "People Picker" list from your organization's directory.
    Here is how to set it up step-by-step.
    1. Connect the Data Source
    First, you must add the connector to your app:
     * Click the Data icon (the cylinder) on the left sidebar.
     * Click + Add data.
     * Search for Office 365 Users and select it.
     * Choose a connection (or create one) to link it to your app.
    2. Customize the Form Data Card
    By default, a form field for "Person" or "Text" won't search your whole company. You have to "unlock" the card to change its behavior.
     * Select the Data Card inside your form where you want the user list to appear.
     * Go to the Advanced tab in the properties pane and click the Lock icon to unlock the card.
     * Select the Combo Box control inside that card.
     * Go to the Items property in the formula bar and paste this:
       Office365Users.SearchUser({searchTerm: Self.SearchText, top: 20})
     
     * In the Properties pane for that Combo Box:
       * Set DisplayFields to ["DisplayName"]
       * Set SearchFields to ["DisplayName"]
       * Ensure Allow searching is toggled On.
    3. Saving the Selection (The "Update" Property)
    Because the Office 365 connector returns a "User Object" and your database (like SharePoint or Dataverse) expects a specific format, you must tell the Form how to translate the selection.
     * Select the Data Card (the parent container, not the dropdown).
     * Find the Update property in the formula bar.
     * If your backend is SharePoint, use this specific "Claims" format:
       {
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
        Claims: "i:0#.f|membership|" & ComboBoxName.Selected.Mail,
        DisplayName: ComboBoxName.Selected.DisplayName,
        Email: ComboBoxName.Selected.Mail,
        Department: "",
        JobTitle: "",
        Picture: ""
    }
     
       (Replace ComboBoxName with the actual name of your control, like DataCardValue10.)
    4. Setting the Default to "Current User"
    If you want the form to automatically pick the person currently using the app:
     * Select the Combo Box control.
     * Go to the DefaultSelectedItems property.
     * Paste this:
       {
        DisplayName: User().FullName,
        Mail: User().Email
    }
     
    Quick Summary
     * Items: Office365Users.SearchUser(...)
     * Update (on Card): The JSON record (Claims/Email/DisplayName).
     * DefaultSelectedItems: User() record.
     
  • Umesh Dinkarrao Baradkar Profile Picture
    6 on at
    Hello @JS-28011410-0

    Which database are you using? If it’s SharePoint, you can directly use a Person or Group column, which pulls people from the organization and is automatically added as a default value in the form.

     
     
     
  • WarrenBelz Profile Picture
    155,838 Most Valuable Professional on at
    This blog of mine may be useful to you here.
     
    Please Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like
    Visit my blog
    Practical Power Apps    LinkedIn  
     
     
  • WarrenBelz Profile Picture
    155,838 Most Valuable Professional on at
    A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.
     
    Please Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
    Visit my blog
    Practical Power Apps    LinkedIn   

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 424

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
11manish Profile Picture

11manish 290

Last 30 days Overall leaderboard