Share
Report
56Hello,
I'm building an automated report menu for some employees at my company. The idea is that an employee would create a report and save it so that they can access it at any time. One of the things that they select is who they're going to email the report to.
I have a combobox that is connected to the Office365Users connection which shows the DisplayName of each user. When the user saves their report, the email information gets saved into a sharepoint list column called "ReportEmails" like so: "BobJoe@company.com;JohnDoe@company.com"
The user selects the saved report name from a dropdown called ddReports.
Using this code in DefaultSelectedValues, I'm able to pull the DisplayNames of each email from the specified report (which is saved in a SP List) and set them as the default values:
RenameColumns(
Split(
Concat(
Split(
ddReports.Selected.ReportEmails,
";"),
First(Office365Users.SearchUser({searchTerm:Result})).DisplayName,
";"),
";"),
"Result", "Value")
The problem is that it does not select the user item with the corresponding DisplayName, it only selects the DisplayName with none of the user data attached.
I'm assuming I'll need to somehow specify all of the different fields of the user in order for it to select the user item, I'm just stuck on how to do this.
Any help is appreciated!
All responses (
Answers (
