Power Platform Community Forum Thread Details

Hello Folks,

I'm trying to get the user ID based from the current logged in user, that will be from tbl_employee.

I have another list which is named tbl_eval_content, of the column here is related with the tbl_employee, emp_ID column.

Now, I want to get the user ID from tbl_employee and fetch that ID then add it to tbl_eval_contents.

Below is my code:

Set(CurrentUserEmail, Office365Users.MyProfile().Mail);
Set(CurrentUserID, LookUp(tbl_employee, User_email = CurrentUserEmail, ID));
Patch(
    tbl_eval_content,
    Defaults(tbl_eval_content),
    {
        emp_id: CurrentUserID,
        Punctual: Value(dr1.Selected.Value),
        // Convert text to number
        Biometrics: Value(dr2.Selected.Value),
        // Convert text to number
        LeaveForm: Value(dr3.Selected.Value),
        // Convert text to number
        OTForms: Value(dr4.Selected.Value),
        // Convert text to number
        STER: Value(dr5.Selected.Value),
        // Convert text to number
        TakeBreak: Value(dr6.Selected.Value),
        // Convert text to number
        ProperUniform: Value(dr7.Selected.Value),
        // Convert text to number
        WearingID: Value(dr8.Selected.Value),
        // Convert text to number
        Grooming: Value(dr9.Selected.Value),
        // Convert text to number
        Station: Value(dr10.Selected.Value)
// Convert text to number
    }
)