Hello everyone,
I am working on an app where I want to capture the logged in user as a person type field in SharePoint versus a Text field. To this end, I've inserted a combobox control which I would like to default to the current logged in user. I have a variable set in OnStart of the app that captures the logged in user and I've established an Office365Users connection. I've found videos on how to default to the logged in user when using a form control, but I haven't been able to find one for a combobox box alone in a Collection scenario.
As you can see, the idea is that users add expenses via controls in the top line that are collected in the Collection below (scroll down to view an example). Once I have the combobox working, I plan to hide the control. I just want it working in the background, collecting the user's identity to the Collection and then patching it back to a person column in the SharePoint data source when the Submit Expenses button is clicked. I think I can get the Collect and Patch statements correct, but I would appreciate help getting the logged in user populated in the control. My current formula attempts are noted below. Thank you.
OnStart
Set(varUser,User())
ComboBox Items Property
Office365Users.MyProfileV2({Name:varUser.FullName})
CB Default Property
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:Concatenate("1:0#.f|membership|",varUser.Email),
DisplayName:varUser.FullName,
Email:varUser.Email}
CB DefaultSelected Items Property
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:Concatenate("1:0#.f|membership|",varUser.Email),
DisplayName:varUser.FullName,
Email:varUser.Email}
Here is a screenshot of what the Collection looks like as you start to add items. Many thanks to Randy Hayes for his advice on how to add items from the top row into the Collection and then write them back to the data source. Teresa
