Patch specific employee name to a person field based on other datacardvalue

[amoshe2]

Hi,

Is there an option to Patch specific employee email value depend on other field in the form to a people picker value?
That mean that the people picker/Person field is still kept as a choice option(pick other employees) unless specific value is picked for other datacardvalue

Thanks
Almog

[v-yujincui-msft]

Hi @amoshe2 ,

Do you want to patch the value of the Person field based on the employee's name or email address?

I have made a test for your reference.

1. Here is my SharePoint List.

2. Select the ComBo Box Control in the Employee_DataCard and apply the following formula on its DefaultSelectedItems property as:

If(!IsBlank(DataCardValue13.Text),
        {//Query person by employee email address
           '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
           Claims: "i:0#.f|membership|" & First(Office365Users.SearchUserV2({searchTerm:DataCardValue13.Text}).value).Mail,
           Department: "",
           DisplayName: First(Office365Users.SearchUserV2({searchTerm:DataCardValue13.Text}).value).DisplayName,
           Email: First(Office365Users.SearchUserV2({searchTerm:DataCardValue13.Text}).value).Mail,
           JobTitle: "",
           Picture: ""
        },
        {//Query person by employee name
           '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
           Claims: "i:0#.f|membership|" & First(Office365Users.SearchUserV2({searchTerm:DataCardValue12.Text}).value).Mail,
           Department: "",
           DisplayName: First(Office365Users.SearchUserV2({searchTerm:DataCardValue12.Text}).value).DisplayName,
           Email: First(Office365Users.SearchUserV2({searchTerm:DataCardValue12.Text}).value).Mail,
           JobTitle: "",
           Picture: ""
        }
)

3. Add an Icon Control and apply the following formula on its OnSelect property as:

SubmitForm(Form3)

Result Screenshots:

Best Regards,

Charlie Choi

[amoshe2]

Let me clear my question again :

I need that the person field will popup automatically based on other datacardvalue 

When I select the option "Legacy Product Request" on the Request Type datacardvalue that the PDP Owner datacardvalue will show as "PDP Legacy Products@intel.com" and If selected "Current Products Request" on Request type data card than that the PDP owner field will be kept to be as choices field - hope that now I clear my question 

I have attached pic below for my fields 

Thanks 

Almog

[amoshe2]

I have more clear my question now , can you please advise on this 

Thanks 

Almog