Hi @faruk1
This may not be a total solution - you have three non-Delegable elements in your Filter - Sum(), Year() and Month(). If the number of Resource_Allocations in your list are less than your Delegation limit, then this should work:
With(
{
_Company:
Filter(
Resource_Allocations,
Mission_ID.'Mission ID' = DataCardValue16_2.Text
)
},
Sum(
Filter(
_Company,
DateValue(Plan_Start_Date) <= Today() &&
DateValue(Plan_End_Date) >= Today() &&
Year(Today()) = Year(DateValue(Plan_Start_Date)) &&
Year(Today()) = Year(DateValue(Plan_End_Date)) &&
Month(Today()) >= Month(DateValue(Plan_Start_Date)) &&
Month(Today()) <= Month(DateValue(Plan_End_Date))
),
'Resource FTE'
)
)
Source: https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-warning-on-Month-and-Year-Formula-in-gallery-label/m-p/2330011
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
