Limited coloured label option for count MS planner task

[Alois]

Hi all,

I created a flow to count the number of tasks under each bucket from MS planner using filter array (it works btw). However, the filter array only shows a default selection of colours as shown:

How can I include colours not shown up here in my flow?

Regards,
Alois

PS. If we look at the advanced edit section of selecting colour, we can see that each colour has a category number. For instance, purple will be category 6. I have tried to include the colours not shown in the filter array selection list by changing the category number to the respective colour rankings. It doesn't work.

[DamoBird365 · Accepted solution]

Hi @Alois 

I gave this a go, and can see that for instance, cranberry is

        "appliedCategories": {

            "category13": true

        }

In the history of my list tasks.

I guess this is default behaviour.  You have two options:

1. construct an expression for these values which would mean the following for cranberry:

body('Filter_array')?[0]?['appliedCategories']?['category13']

This demonstrates me retrieving the first element of the array by using [0]

My compose is retrieving the first task category 13 just to demonstrate it without an apply to each.  The 2nd action apply to each will look at each category13 per planner task retrieved.

2. use the parse json action with a sample output (insert into payload of parse JSON) from list tasks that includes ALL of the different categories.  You will then be able to select the colours by category name (not colour) dynamically.

I suppose if you wanted to be really clever, you could then use the select action to build a bespoke array with the colours as the key names after the parse.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here