Not all records filling in User information

(0) Share

Report

Posted on by Dorinda

1,512

@RandyHayes

I have this app that prefills the user information name and employee id

If(
Form1.Mode = New,
First(
Filter(
CurrentEmployeeOrg,
Lower(Email) = User().Email
)
).EmployeeNumber,
ThisItem.EmpId
)

The issue is that not all of the people who login is having the ID fill it, I have less then 2000 records to lookup from the list CurrentEmployeeOrg

I know you gave me the other example

If(
Form1.Mode = New,
LookUp(
CurrentEmployeeOrg,
Lower(Email) = Lower(DataCardValue2.Selected.DisplayName),
EmployeeNumber
)
)

But i do not know how to apply that to this issue?

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dorinda

Yes, definitely ditch the First(Filter in your formulas!

And, no, I don't believe that applies to your issue - you are stating that an employee (based on email) does not have a record in the CurrentEmployeeOrg list?

So, if that is the case, then what do you want the Employee ID to be?

Am I missing something?

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

No they are in the list i have validated that but when they open the form it is not filling it in like it does for me.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Dorinda

So, re-looking over your formula (the one you said I provided), you are trying to compare the lowercase version of the email with the lowercase version of the Display Name - that is not going to compare! The formula I suggested to you compared email to email.

Next, in your first formula, you are comparing the lower of the email from the CurrentEmployeeOrg to the non-lowered User().Email. That will most likely cause issues.

Also sometimes the User function in the lookup causes issues.

It would be better practice to have this formula in the OnStart of the app:

Set(AppUser, User())

Then change your formula to the following:

If(Form1.Mode = New, LookUp(CurrentEmployeeOrg, Lower(Email) = Lower(AppUser.Email), EmployeeNumber ), ThisItem.EmpId )

Was this reply helpful? Yes No