Name Column and Help with @odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser

[kgordish]

Hello,  I am having issues with the name column updating.

As soon I learn one trick another brickwall is placed in my way.

Column 3 is Person Column in SharePoint. I was able to populate with the names I wanted by using:

Distinct(Filter(CDLTest, Department1.Value="Yes"),Person.DisplayName)
My Column name is Body_Exterior.

Now its my understanding I have to use the odata.type formula to have SharePoint insert the selected name into the SharePoint Column. 
Thank you for the help. I am almost there. 

1. Is Formula Below Correct?
2. Where do I place this formula?

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",        Claims:"i:0#.f|membership|"&Body_Exterior.Selected.Result,
Department:"",  
DisplayName: First(Office365Users.SearchUser({searchTerm:Body_Exterior.Selected.Result})).DisplayName,         Email:Body_Exterior.Selected.Result,     
JobTitle:"",      
Picture:""   }

[Eelman]

@kgordish 

The problem here is that Distinct() only returns a single column table whereas you need a multi column one for the person field.

Try using a Filter only for your names, ie

Filter(CDLTest, Department.Value="Yes")

then in the RHS panel, select DisplayName as the option to show in your ComboBox

The DataCard Update property could then just be set to

DataCardValue3.SelectedItems

[mdevaney]

@kgordish 

It does not appear necessary to write the lengthy section of code to insert DataCardValue3 into SharePoint.

Simply put this code in the Update property of BodyExterior_DataCard1

DataCardValue3.SelectedItems

Then put this code in the OnSelect property of your button and the value will be inserted into SharePoint.

SubmitForm(Form1)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[kgordish]

@mdevaney 

Thanks for reaching out. I wrote the formula to populate a drop down with specific names (7-10) from a specific department instead having a person type in a Person Column.

I can use a "Choice Column" and hard code names by typing them, but the names are essentially text or string data. I was trying to connect names to Outlook Users. I was able to generate the drop down and submit info into SharePoint, but the selected name was not being saved to SharePoint.

[v-siky-msft · Accepted solution]

Hi @kgordish ,

If the combo box can populate the user names as you expected, try to put the following codes to Update property of Body_Exterior Data Card.

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"&First(Office365Users.SearchUserV2({searchTerm: DataCardValue3.Selected.Result}).value).Mail,
Department:"",  
DisplayName: DataCardValue3.Selected.Result,
Email: First(Office365Users.SearchUserV2({searchTerm: DataCardValue3.Selected.Result}).value).Mail,     
JobTitle:"",      
Picture:""   }

 Hope this helps.

Sik