Power Platform Community Forum Thread Details

Hello!

I am trying to build a performance management app. Currently I am trying to figure out the logic whenever user login the app, it will retrieve info from a list in SharePoint called Staff Profile. I'm using current login user email for lookup.
I used this formula in OnStart:

ClearCollect(UserProfile, LookUp('Staff Profile', Email=CurrentUserProfile.Email));

//Get KPI Record
Set(CurrentUserID, LookUp('Master KPI', StaffEmail=CurrentUserProfile.Email, ID));

However, there is a condition when retrieving the info, that IF no email is found in the list OR ManagerID (a number column in SP) = 0, it will display a label/message "No submission is needed".

If the staff info is found/matched, it will retrieve record from another SP List, Master KPI based on the user email. But if no record match the email, it will populate the necessaries information retrieved from Staff Profile.

I am having trouble working out the logic/formula and would appreciate guidance for this.
Thank you!

Categories:

Building Power Apps