Patch person/group column with dropdown

(0) Share

Report

Posted on by Dulat

102

Hi,

I have admin list1 of my app, the column type there is Person or Group. List size is max 15 people.

Then I used Distinct(AdminList, Admins) for my dropdown menu items.

I have another list2, where I have my document for review by the admins.

I wanted to add an "Assigned to" column, to track to whom which document is assigned.

I have a gallery2, where list2 is pulled to track the workload on admins.

I am struggling with Patch function to edit List2 Person type column with the selected person from dropwdown menu (which is distinct people from List1, also Person type column)

Can someone help with that?

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Ninja_365 99 on at

Like (0)

Report
Re: Patch person/group column with dropdown

hi @Dulat ,
you can try this
Patch( List2, SelectedItemInGallery2, {'Assigned to': DropdownAdmins.Selected} )
If you find this solution helpful, please feel free to accept it. 😊

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Re: Patch person/group column with dropdown

Hi @Ninja_365
I did exactly same thing, but it didn't worked :(.

Patch(mesra_footer,Gallery1.Selected, {Assigned:Dropdown1.Selected})

Was this reply helpful? Yes No
Ninja_365 99 on at

Like (0)

Report
Re: Patch person/group column with dropdown

Hi @Dulat ,
try this
Patch( List2, SelectedItemInGallery2, {'Assigned to': LookUp(Office365Users.SearchUser({searchTerm: DropdownAdmins.Selected.Email}), Email = DropdownAdmins.Selected.Email)} )
If this solution helps you, feel free to accept it. 😊

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Patch person/group column with dropdown

HI @Dulat,

I am confused that is this Distinct() function working if Admins is a Person column?

If Admins is a Person type column, you should modify your Distinct() function as below:

Distinct(AdminList, Admins.DisplayName)

Patch( list2, Defaults(list2), { Title: "6", Responsible: { Email: Dropdown4.Selected.Email, DisplayName: Dropdown4.Selected.DisplayName, Claims: Dropdown4.Selected.Email, Department: Dropdown4.Selected.Department, JobTitle: Dropdown4.Selected.JobTitle, Picture: Dropdown4.Selected.Picture } } )

Was this reply helpful? Yes No