How to get a field value based on the current user?

[Roberto_el_Hajj]

Hello,

I hope all is well,

Problem:

I want to get a field value of the column called "EmloyeeN" from a table called "leave request" of the current user where the "EmployeeNO" field type is lookup on the table "Employees" in order to place the result in a dropdown Datacard automatically on login (the Datacard DisplayMode will be view only)

What I used:

With(
    {
        _EmplID: LookUp(
            Employees,
           currentUserEmail = 'E-Mail'
        ).No
    },

Filter(
        'Leave Requests',
        Employee.No = _EmplID 
)
)

When I used this expression, an "expected a record value" error pops up.

So what is the best practice to solve my issue ?

Thanks

[v-jefferni]

Hi @Roberto_el_Hajj ,

Did you put the formula in Default property of the Dropdown? If it is a Combo box, you need to set it in DefaultSelectedItems property as Default property only accepts single record while Filter function will return a table.

What exactly would you like to display in the Dropdown? There should be multiple records belong to a specific user in the Leave request table, unless you will only need to show the latest request of the user?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.