I am adjusting the 'Leave Request' template. Everyone can choose their own approver in the template. I want to determine the approver for everyone.
I got an Excel table:
Mail address logged in person | Mail address approver
The power app formula must look in the excel file, find the current user and take the approver of it. Then the formula should look in Office365Users and put the entire user in a variable.
I already tried:
But it isnt working.
Here Office365Users.UserProfile() function is expecting value like single email address(firstname.lastname@example.org), and it will return us the table of content, which will have details in our case like "Job Title", "Display Name", "Telephone" etc. So here we need to more specific while retrieving the required info.
I hope you got my point and let me know if you need any additional info on this.
I thought this would work, but it gives me the following errors
Invalid Argument Type (Table) needs TEXT
the function UserProfileV2 has some invalid arguments
this is my expression
VAR Table TableHead UserInVar TableHead
Set(_defaultApprover; Office365Users.UserProfileV2(Filter(Balance; EmployeeEmail = _myProfile.Email).Approver)));