Answered

PowerApps people picker field not showing data in edit form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SharePoint custom PowerApps form. My SharePoint list reached the maximum number of lookup column so I created a people picker in Powerapps but in SharePoint list it is a single line of text column. People picker is working fine in Powerapps and on submit saving the field value in the single line of text column in SharePoint list. However, when I select an item from the list and open the edit form, the people picker field doesn't show the value . Can anyone help me what needs to be done to get people picker value on edit form?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

What are you storing in the single line of text column in your SharePoint list?

If it is the Email address of the person (which it should be), then set the DefaultSelectedItems property of your Combobox in your app to the following:

{ Claims:"i:0#.f|membership|" & Lower(Parent.Default), Department:"", DisplayName:Parent.Default, Email:Parent.Default, JobTitle:".", Picture:"." }

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Thank you for the reply. I set the DefalutSelectedItem property. Now the people picker field is showing the value in edit form. However, Email and Phone number fields are not showing value in edit forms. In list, all fields have value. Both are single line of text column and their default property is
Email default property is set to peoplepicker.selected.Mail

Phone default property is set to If(!IsBlank(DataCardValue1),
Concat(Office365Users.UserProfileV2(DataCardValue1).businessPhones,Value&" "))

DatacradValue1 is an email datcard.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

First - What is DataCardValue1? Second - you should not refer to a control like that, you should refer to the property of that control that you want to get the value from.

If you have a control called peoplepicker (which you seem to indicate you do in your formula) then your formula should be based off of that selected item.

If(!IsBlank(peoplepicker.selected.Email), Concat(Office365Users.UserProfileV2(peoplepicker.selected.Email).businessPhones,Value & " ") )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes
Thank you for telling me the best practice. It worked. I really appreciate your help.

Was this reply helpful? Yes No