{"id":660,"date":"2020-02-17T08:30:00","date_gmt":"2020-02-17T08:30:00","guid":{"rendered":"https:\/\/www.malka-unscripted.com\/?p=660"},"modified":"2020-02-14T16:16:15","modified_gmt":"2020-02-14T16:16:15","slug":"powerapps-create-people-picker-field","status":"publish","type":"post","link":"https:\/\/www.malka-unscripted.com\/?p=660","title":{"rendered":"PowerApps: Create People Picker Field"},"content":{"rendered":"\n

In a Canvas App, there is no People picker field like you have in SharePoint. Instead, you can configure the ComboBox control to act as your people picker field.<\/p>\n\n\n\n

First, Add Office365Users<\/strong> as a data source to the app.<\/p>\n\n\n\n

\"\"
Add Office 365 Data Source<\/figcaption><\/figure>\n\n\n\n

From the Insert tab, \u00a0select the input drop down menu and add the Combo box control to the app.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, let’s configure the settings for the Combo box:<\/p>\n\n\n\n

First, let’s look at the items properties. To get all the O365 users as choices in the combo box, enter the following formula:<\/p>\n\n\n\n

Office365Users.SearchUser({searchTerm: ComboBox.SearchText}).DisplayName) <\/p>\n\n\n\n

I used DisplayName as the field that will display from the UserProfile but you can review the available fields and change it as needed.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This will list all the users in the organization as a drop down menu. Loading all users can slow down the app. So instead, we will only load the users if the search box is not empty, and then it will only return the users that are relevant for that search. Here is the updated formula:<\/p>\n\n\n\n

If(!IsBlank(ComboBox.SearchText), Office365Users.SearchUser({searchTerm: ComboBox.SearchText}).DisplayName)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Some other properties you may want to configure:<\/p>\n\n\n\n

  • DefaultSelectItem <\/strong>property <\/strong>to set the current user as the default value use this formula: Office365Users.MyProfile()<\/strong><\/li>
  • SelectMultiple<\/strong> property to determine if multiple users can be selected. The value can be true or false.<\/li><\/ul>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    In a Canvas App, there is no People picker field like you have in SharePoint. Instead, you can configure the ComboBox control to act as your people picker field. First, Add Office365Users as a data source to the app. From the Insert tab, \u00a0select the input drop down menu and add the Combo box control […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[5,41],"tags":[57,63,42,6],"class_list":["post-660","post","type-post","status-publish","format-standard","hentry","category-general-sharepoint","category-powerapps","tag-office-365","tag-people-picker-field","tag-powerapps","tag-sharepoint"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8wyUs-aE","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=\/wp\/v2\/posts\/660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=660"}],"version-history":[{"count":3,"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=\/wp\/v2\/posts\/660\/revisions"}],"predecessor-version":[{"id":674,"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=\/wp\/v2\/posts\/660\/revisions\/674"}],"wp:attachment":[{"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.malka-unscripted.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}