Hi @rajkumar88 ,
Do you want to save the current sign in user's Direct reports into a column in your SP list when the user submit a new request?
Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:
Firstly, you need to add a Person type column in your SP List, and enable "Allow Multiple Selections" option for this Person column.
App's configuration as below:
Set the OnSuccess property of the Edit form in your app to following:
Patch(
'20190611_case8',
EditForm1.LastSubmit,
{
DirectReports: ForAll(
Office365Users.DirectReports(User().Email),
{
Claims:"i:0#.f|membership|" & Lower(Mail),
DisplayName: DisplayName,
Email: Mail,
JobTitle:"",
Department:"",
Picture:""
}
)
}
);
Back()
On your side, you should tpe:
Patch(
'YourSPList',
EditForm1.LastSubmit,
{
YourPersonColumn: ForAll(
Office365Users.DirectReports(User().Email),
{
Claims:"i:0#.f|membership|" & Lower(Mail),
DisplayName: DisplayName,
Email: Mail,
JobTitle:"",
Department:"",
Picture:""
}
)
}
);
Back()
Note: The YourPersonColumn represents the Person column in your SP list, which has enabled the "Allow Multiple Selections" option. You need also to add Office 365 Users as data source into your app.
When the user submit a new request successfully, the Person column (allow multiple selections) in your SP list would also be updated with his direct reports.
Please take a try with above solution, then check if the issue is solved.
Best regards,
