Show the Total number of completed items / total number of items under certain parent item

(0) Share

Report

Posted on by johnjohn123

3,514

I have 2 SharePoint lists:-

1) Project Master

2) Activities

The Activities list has a lookup field to the Project Master, as follow:-

now inside the Projects Gallery we want to show the:-

Total number of Project's completed Activities / Total number of Project's Activities .

in other words we need to show the percentage of the tasks completion under certain Project. to do so >> i added a label inside the Project's Gallery and i define the following formula :-

but we received a delegation warning.. so how we can fix this?

Thanks

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123 Use "ShowColumns" function Within the filter to get rid of delegation warning.
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bilakanti can you advice more on this ? how i can use "ShowColumns"?
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!
@johnjohn123 ,
ShowColumns( IceCreamSales, "Flavor" )
Filter(ShowColumns(<Datasource>,"Column1","Column2","Column3"), Your filter condition))
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bilakanti and can i use CountRows then?
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123 CountRows will return the number of rows within a table.
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bilakanti but how/why using the ShowColumns will fix the delegation error?
WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123 ,

Another Delegation post from you - is this able to be closed - I believe this was answered on another post.