Hello All - I have a situation with my power app gallery filtering.
I have a SP list that captures data based on input from my users. Based on the input, there are a couple of calculated columns that calculate the month & year (MMM YY) and another column calculates Start of the Month (MM/DD/YYYY) as a calculated field. These columns are used for reporting in my power BI.
I understand that calculated fields are not delegable while filtering in SP List. Below is my formula. I am seeing a delegation for the last part of my formula. Is there a work around as I see that the SP list will go beyond 2000 records in a few months.
SortByColumns(
Filter(
'SP List',
(StartsWith(
'Employee Name',
SearchEmployeeID_Name.Text
) || StartsWith(
'Employee ID',
SearchAssociateID_Name.Text
)) && (('Name of SLT'.Value = DrpDwnNameofSLT.Selected.Value) || (DrpDwnNameofSLT.Selected.Value = Blank())) && (('Award Name'.Value = DrpAwardName.Selected.Value) || DrpAwardName.Selected.Value = Blank()) && (('Name Of Manager' = DrpDwnNameofManager.Selected.Value) || (DrpDwnNameofManager.Selected.Value = Blank())) && (('Fiscal Year'.Value = DrpFY.Selected.Value) || (DrpFY.Selected.Value = Blank())) && (('Award Month' = DrpAwardMonth.Selected.Value) || (DrpAwardMonth.Selected.Value = Blank()) && (Month(Created) <> Month(Today()) || Day(Today()) >= 24 && Day(Today()) <= 31))
),
"Created",
SortOrder.Descending
)
Award Month is the Calculated Column that gets the month in MMM YY format which I would like to filter without any delegation. Also one more need is that the users see the data only after 24t of the month based on when the item was created. I see that Month(created) is also non delegable. Any work around on that would help.
