Hi all!
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)