You’re offline. This is a read only version of the page.
i have sharepoint list
username(people choice )coloumn, Date, choice colounn , working days columns.
in powerapps
i created vertical blank gallery with Distinct(username.Email) in Item.
then inserted label : which will display username.
and in blank vertical gallery i inserted hortizontal blank gallery and in item properties mentioned as Sequence(12) it will display months in Inserted Label.
now i want to insert one more label it will count percentage of choice coloumn ( sum of its numbers ) based on dates of month with First value of working days coloumn First(ABC).WorkingDays.
Here below code is not working showing delagation. how to fix it
If(
CountRows(
Filter(
ABC,
Month(Date) = ThisItem.Value
)
) > 0,
Text(
Sum(
Filter(ABC,
User().Email=username.Email),
'choice'.Value=1
)
) / First(ABC).WorkingDays*100
""
)
You will not get that Delegable using Month(Date). CountRows() is also not Delegable although there is a workaround for that. You are going to need to store the month in another field.
Hi @venky232 ,
I cannot see your data and am guessing a bit here, but it this what you are trying to do ?
Share
Report
All responses (
Answers (
If(
CountRows(
Filter(
ABC,
Month(Date) = ThisItem.Value
)
) > 0,
Text(
Sum(
Filter(
ABC,
User().Email = username.Email) &&
'choice'.Value = "1"
)
) / WorkingDays * 100,
"000"
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
i have sharepoint list
username(people choice )coloumn, Date, choice colounn , working days columns.
in powerapps
i created vertical blank gallery with Distinct(username.Email) in Item.
then inserted label : which will display username.
and in blank vertical gallery i inserted hortizontal blank gallery and in item properties mentioned as Sequence(12) it will display months in Inserted Label.
now i want to insert one more label it will count percentage of choice coloumn ( sum of its numbers ) based on dates of month with First value of working days coloumn First(ABC).WorkingDays.
Here below code is not working showing delagation. how to fix it
If(
CountRows(
Filter(
ABC,
Month(Date) = ThisItem.Value
)
) > 0,
Text(
Sum(
Filter(ABC,
User().Email=username.Email),
'choice'.Value=1
)
) / First(RTW).WorkingDays*100
""
)
i have sharepoint list
username(people choice )coloumn, Date, choice colounn , working days columns.
in powerapps
i created vertical blank gallery with Distinct(username.Email) in Item.
then inserted label : which will display username.
and in blank vertical gallery i inserted hortizontal blank gallery and in item properties mentioned as Sequence(12) it will display months in Inserted Label.
now i want to insert one more label it will count percentage of choice coloumn ( sum of its numbers ) based on dates of month with First value of working days coloumn First(ABC).WorkingDays.
Here below code is not working showing delagation. how to fix it
If(
CountRows(
Filter(
ABC,
Month(Date) = ThisItem.Value
)
) > 0,
Text(
Sum(
Filter(ABC,
User().Email=username.Email),
'choice'.Value=1
)
) / First(RTW).WorkingDays*100
""
)
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
