I am trying to filter a Person column in a SharePoint List to determine who the approver will be in PowerApps based on several criteria.
Purchase App (get the information from SharePoint List Name: PurchaseTest1)
My idea is that the approver (coming from SharePoint List Name: ApproversTest1) is the list of persons that may approve the purchase request (ApproverPerson Column is a Person column)
So the idea is that if the request is below 5,000 the approver option will be only if the BusinessUnit match. Ex: If amount is 2,500 and BusinessUnit is Unit1, only Alfredo should be an option. If the amount exceed 5,000 only Alejandra Pena should be available for either Business Unit.
At this point i just have the formula for the amount:
Distinct(Filter(ApproversTest1,Limit>=Value(DataCardValue2.Text) && BusinessUnit.Name in DataCardValue12.SelectedItems.Name),ApproverPerson.DisplayName)
Here, Name needs to be replaced with the column which stores the Unit1 and Unit2 values. Also, DataCardValue12 is the name of the combobox control
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!