As you can see from my pictures i have 4 text column. 2 for employee and 2 for manager. In the first text column i remove the text input and add combo box in the data card. Properties are set as shown in picture. Data saved correctly but in the edit form it doesn't work. Also i am doing this for single person. I need to do this for multi select person.
So my requirement is: Create an edit form that can add and edit multi select person type and fetch manager. All columns in the backend is text type. I hope i explained it proper. Thanks in advance.
Hi @zmansuri ,
Manager's name should be
Office365Users.Manager(ComboBox1.Selected.Mail).DisplayName
and Mail for the one below. The multi-select, however is a larger journey - I may not be the best person here as I rarely use this function (we maintain a separate staff list).
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @zmansuri
For Edit mode, we need to set DefaultSelectedItems property of the AssignToName Combobox to
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(ThisItem.AssignToEmail),
Department: "",
DisplayName: ThisItem.AssignToName,
Email: Lower(ThisItem.AssignToEmail),
JobTitle: "",
Picture: ""
}
Hey, I set the DefaultSelectedItem as you said. But it's still not filling the values in other text fields.
I understand. Thank you anyways.
User | Count |
---|---|
255 | |
114 | |
93 | |
48 | |
38 |