I'm trying to do a Lookup from Powerapps to sharepoint list and used it to a Label so that I can update the Visibility of "Approve" Button. From my sharepointlist, Requisition Permission (App)" I have Person or Group type Column and Title. I have 5 Approvers created from the Sharepoint list and whenever I use the same email to atleast 2 approvers out of 5 approvers, the visibility doesn't show properly and If all 5 approvers are all different, The Approve button is visible to its respective approver. I'm pretty sure the problem is with the Label I created which I named as "Mgpost". Formula I created in Text from this label is "LookUp('Requisition Permission (App)', Name_App.DisplayName=UserFullname.Text).Title" and I get a yellow triangle warning and there is a Blue underline in "App.DisplayName". Please see screenshot. Help me figure out why if I add 2 same emails from the sharepoint list, the visibility doesn't show properly.
Note: I also have done the TS below :
On the File tab, select App settings.
Under Experimental features, change the Data row limit for non-delegable queries setting from 1 to 2000. (Maxed to 2000)
Visible formula for the approve button is UpdateStatVisible &&(MgPost.Text = "ProcStaff"). MGPost is a label the looks up to a sharepoint list wherein this sharepoint list has 5 approvers (Reviewer,Manager,Approver,FinalApprover,and ProcStaff) please see screenshot. Formula for the MGPost label is LookUp('Requisition Permission (App)', Name_App.DisplayName=UserFullname.Text).Title. ProcStaff value is set to this formula Set(ProcStaffEmaillVar, LookUp( 'Requisition Permission (App)', Title =
"ProcStaff").Name_App.Email). Sharepoint List is named asRequisition Permission (App). If I set for example my name to the Reviewer and Procstaff via the sharepoint list, the only visible Approve or Mark as complete button is for the Procstaff and not for the Reviewer. So basically, there are Five approve buttons example is for reviewer, the visible formula will be "UpdateStatVisible &&(MgPost.Text = "Reviewer") . I have attachedApprover1 for ReviewerandApprover2 for ProcStaff. I have assigned my own name to the sharepoint list as the Reviewer and the Procstaff and you will notice that the only visible Approve button is for the ProcStaff.