Power Platform Community Forum Thread Details

Hello there!

I wonder if anyone knows the workflow to obtain the "Checklist" info from a specific bucket in Microsoft Planner and upload it in an Excel that feeds a Power BI Dashboard. Any help would be appreciated.

Explanation:

1. I have 191 Microsoft Teams channels as tasks showing the state of progress of each of them in a Power BI Dashboard:

2. The problem is that chart information is not correct as Power Automate is taking the "Start date" and "Due date" from the description task bucket in Planner:

3. What I need instead is that the state of progress of each task must be obtained from the Checklist of that description bucket been previously selected by the task responsible person:

4. And finally upload the info in the Excel that feeds the charts in the Dashboard:

Thank you in advance,

Categories:

Power Automate Desktop

I'm working with Pelayo in the same project. After a Get task details action I'm using a Add a row into a table action (both within a Apply to each loop, given that there are many different tasks) to dump the data into the Excel file.

I'm trying to access the checklist items (if they're checked or not) with these expressions:

outputs('Obtener_detalles_de_tarea')?['body/checklist'][0]['value/isChecked']
outputs('Obtener_detalles_de_tarea')?['body/checklist'][1]['value/isChecked']
outputs('Obtener_detalles_de_tarea')?['body/checklist'][2]['value/isChecked']
outputs('Obtener_detalles_de_tarea')?['body/checklist'][3]['value/isChecked']

I'm assuming the checklist is an array with four positions, indexed from 0 to 3 (Python, not R, style), and it seems to work, I'm getting boolean information in my Excel file... but in a random way.

I'm doing some tests with the same Planner task; for instance:

If I check 25-50, 50-75 and 75-100 within Planner, I get TRUE in Excel for 0-25, 50-75 and 75-100.

If 75-100, then 0-25.

If 0-25, then 25-50.

If 0-25 and 25-50, then 25-50 and 75-100.

The only accurate match happens when I check all 4 items; then I get 4 TRUE values in Excel.

Weird behaviour... any hint?