I am not 100% sure why I have a delegation problem here but this is the first chunk of code after over a month of trying that works to do what I need (I have an image below to show what I am seeing in PowerApps).
From reviewing documentation on delegation I assume it is because I may have what is determined to be a complex Sort function or is it because I have an If inside of an If?
Is there a suggestion on how I could get rid of my delegation issue on this piece of code? Delegation will become an issue with my app and so far I have been able to work around it.
This code is checking to see if the user is listed in the admin SharePoint list or not and allowing access/data through based on that determination. Then it is loading the SharePoint list Lead_Data, my main SharePoint list, and only displaying on default rows that have the status Not Started or In Progress associated with it (I have tabs that on their OnSelect property allow other status types to display).
Sort(
If(
varAdmin,
Filter(
Lead_Data,
If(
SelectedStatus = "All",Or(Status.Value = "In Progress", Status.Value = "Not Started"),Status.Value = SelectedStatus
)
),
Filter(
Lead_Data,
AssignedTo.Value = varUser || LeadMember1.Value = varUser || LeadMember2.Value = varUser || LeadMember3.Value = varUser || LeadMember4.Value = varUser,
If(
SelectedStatus = "All",Or(Status.Value = "In Progress", Status.Value = "Not Started"),Status.Value = SelectedStatus
)
)
),
Created, Descending)
