Answered

Autofill SP columns from Powerapp

(0) Share

Report

Posted on by SectorOMEGA

338

Im little bit lost and trying to fight my way to accomplish the following. I have two SP fields added as Person or Group: 1. Employee Name and Employee manager. Im trying to figure is there a way to populate the employee manger based on the Employee name with format of the columns. I know it can be done if the columns are text ones but I need those to be searchable in our company AD to ease the use of the app. Thank you in advance for the help

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Abhilash_Swain 901 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SectorOMEGA ,
If it is a text field:- use Office365Users.Manager(User().Email).DisplayName [to use this add Office365users as a data connector]

It will show the current user's Manager.
Please give a thumbs up or accept it as a solution if I answered your query.
Thanks
Abhi

Was this reply helpful? Yes No
SectorOMEGA 338 on at

Like
a
(0)

Report
Copy link

Link copied!

Both fields are created in SP as Person or Group in order to be able to search the company AD. Th current user is not useful in my case. Employee name will be filled by the user and should be different.

Was this reply helpful? Yes No
Verified answer

sayyedkohler 313 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SectorOMEGA
I tested with your requirement.
If you are trying to get manager in PowerApps form then this is the correct solution:

Step1: Insert Form in PowerApps
Step2: Unlock Manager fields.

Step3: Set Manager Combo Box DefaultSelectedItems property with this code:
Note: Replace DataCardValue6 with your Employee Combo Box Name.
{Claims:"i:0#.f|membership|"& Office365Users.Manager(First(DataCardValue6.SelectedItems).Email).Mail, Email:Office365Users.Manager(First(DataCardValue6.SelectedItems).Email).Mail, Department:"", DisplayName:Office365Users.Manager(First(DataCardValue6.SelectedItems).Email).DisplayName, JobTitle:"", Picture:""

Thanks

Was this reply helpful? Yes No
SectorOMEGA 338 on at

Like
a
(0)

Report
Copy link

Link copied!

@sayyedkohler That did it. However is there a way to ignore the error that it gives me when the employee name is empty?

Was this reply helpful? Yes No
sayyedkohler 313 on at

Like
a
(1)

Report
Copy link

Link copied!

You can set condition on DefaultSelectedItems property of Manager:
If( !IsBlank(EmployeeField.SelectedItems), 'Paste your default code here')

Was this reply helpful? Yes No
SectorOMEGA 338 on at

Like
a
(0)

Report
Copy link

Link copied!
@sayyedkohler If I put it like this:
If(!IsBlank('Employee email'.SelectedItems), {Claims:"i:0#.f|membership|"& Office365Users.Manager(First(DataCardValue4.SelectedItems).Email).Mail, Email:Office365Users.Manager(First(DataCardValue4.SelectedItems).Email).Mail, Department:"", DisplayName:Office365Users.Manager(First(DataCardValue4.SelectedItems).Email).DisplayName, JobTitle:"", Picture:""})
It gives me an error here:
If(!IsBlank('Employee email'.SelectedItems),
Im trying to input the filed with/without '' and still not accepting it. Where Im wrong?

Was this reply helpful? Yes No