People picker Dependency

[amoshe2]

HI,

I have the below code on my items for People picker field but it's not working properly - please advise 

If Value in on Datacardvalue3 is equal to "PDP Legacy Request" than set the PDP owner field(People picker field) as "PDP Legacy Products" . else put it as a choice option (Choices(['Almog test list'].'PDP Owner'))

If(DataCardValue3.Selected.Value="PDP Legacy Request",
set(ThisItem.'PDP Owner'="PDP Legacy Products"),
Choices(['Almog test list'].'PDP Owner')
)

Thanks 

Almog

[PowerAddict]

Hi @amoshe2 , 

You cannot use the Set function to update a record with a specific value, like I am assuming you want to update the PDP Owner of the given record (ThisItem) to PDP Legacy Products. Also, if this is for the Items property, using Set wont work. In both your If and Else conditions, you are picking only one value. So are you trying to use that for the Items property of the people picker?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[amoshe2]

Thanks for the replay, and Yes I'm  trying to use that for the Items property of the people picker?

So what is the correct code line for that 

Thanks 

Almog

[v-qiaqi-msft]

Hi @amoshe2,

Do you want to populate the people picker with a text value "PDP Legacy Products"?

Could you please tell me more about your column settings?

If you want to pass a text value to a Person field, I am afraid there is no way to achieve this in Power Apps currently. If you want to update the Person field, you must assign a person from the Azure AD to the Person field. A text string could not be updated to the Person column.

[amoshe2]

HI,

I don't want it to be a text field , I just want the EMP name will show automatically there and that the people picker field will find it out (it will be a valid value to be submitted)

the email name is "PDP Legacy Products@Intel.com" and I want it to automate put it out on the people picker field 

Hope I clear myself now

Thanks 

[v-qiaqi-msft]

Hi @amoshe2,

So "PDP Legacy Products" is a Display name in your Azure AD, right?

Then please modify your formula for Items as below:

If(DataCardValue3.Selected.Value="PDP Legacy Request",Office365Users.SearchUser({searchTerm:DataCardValue3.Selected.Value}),Choices(Actions.Teacher))

 Modify your formula for the Update property of the person field data card as below:

{
            DisplayName: First(Office365Users.SearchUser({searchTerm: DataCardValue3.Selected.Value})).DisplayName,
            Claims: "i:0#.f|membership|" & First(Office365Users.SearchUser({searchTerm: DataCardValue3.Selected.Value})).Mail,
            Department: "",
            Email: First(Office365Users.SearchUser({searchTerm: DataCardValue3.Selected.Value})).Mail,
            JobTitle: "",
            Picture: ""
        }

[amoshe2]

Hi,

Not sure what is Choices(Actions.Teacher))

as I don't have this choice. this is what I put on my end

 If(DataCardValue3.Selected.Value="PDP Legacy Request",Office365Users.SearchUser({searchTerm:DataCardValue3.Selected.Value}),Choices([@'Almog test list'].'PDP Owner')

and where exactly I need to put the Email I want 

PDP Legacy Products <pdp.legacy.products@intel.com>?

[v-qiaqi-msft]

Hi @amoshe2，

That's my data source and person column, you should replace it with yours.

Here is an issue you may miss that the Choices() function returns a different table with the table that Office365SearchUsers() function returns. Eg. The Choices() has a Email column but the Office() has a different one named Mail, so you could not keep them same within the If statement.

As an alternative solution, I will suggest use the same Office365() function within the If() statement.

Set the Items property as below:

If(DataCardValue3.Selected.Value="PDP Legacy Request",Office365Users.SearchUser({searchTerm:"Wearsky",top:999}),Office365Users.SearchUser({searchTerm:"",top:999}))

Then you should set the DisplayFields property of the people picker as:["Mail"]

[amoshe2]

The office365 isn't finding the PDP Legacy Account username or email and also not giving me the right employee list from the corporate.

only if I'm doing choice it's direct me to the correct employees under the dropdown box

my search field is by ["DisplayName"]

again it should have the choice at the end of the code

 If(DataCardValue3.Selected.Value="PDP Legacy Request",?(How to add PDP Legacy account user name????) ,Choices([@'Almog test list'].'PDP Owner')

hope you can help me to achieve this 

Thanks

[amoshe2]

The office365 isn't finding the PDP Legacy Account username or email and also not giving me the right employee list from the corporate.

only if I'm doing choice it's direct me to the correct employees under the dropdown box

my search field is by ["DisplayName"]

again it should have the choice at the end of the code

 If(DataCardValue3.Selected.Value="PDP Legacy Request",?(How to add PDP Legacy account user name????) ,Choices([@'Almog test list'].'PDP Owner')

hope you can help me to achieve this 

Thanks