How to get the percentage of completion thanks to checklist of a task in Planner

(0) Share

Report

Posted on by NicolasSer

I need to retrieve information on the number of validated checklists out of the total number to get an accurate percentage of progress, so that I can reuse it.
However I can't find this information in the power automaton, do you have a solution?
Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @NicolasSer,

You could use a filter array after a task details action to check how many checklist items are checked in the Checklist collection. You can compare that to the total amount of checklist items in that same collection and calculate the percentage with functions like div, mul and float.

Below is an example of that approach.

mul(div(float(length(body('Filter_array'))),float(length(outputs('Get_task_details')?['body/checklist']))), 100)

Was this reply helpful? Yes No