Reordering Buckets From MS Planner in Email Output

[JasonM73]

Hello

I am using the stock template from MS - 'Create a daily summary of Planner Tasks by Bucket' to generate an email of various tasks I have in various buckets. This all works fine and dandy but the flow is placing the bucket list from last to first in the email content and I not exactly sure where it is being ordered and would like to change it. Could someone help me out and show me where to look please.

Thank you

J

[v-chenzhi]

Hi @JasonM73 ,

Do you want the bucket to displayr in the email in the order it is in the planner?

I have test on my side, please try the following workaround.

Here are the expression:

length(variables('TT'))

length(outputs('List_buckets')?['body/value'])

take(outputs('List_buckets')?['body/value'],sub(length(outputs('List_buckets')?['body/value']),length(variables('TT'))))

last(outputs('Compose_2'))

It shows like this.

Best Regards,

Zhi Chen

[JasonM73]

Zhi

Thanks for the reply - that is exactly what I am looking to achieve. I have followed your guide above but I get a Flow Checker error

All set correctly as shown below

Did I miss something?

Thanks

J

[v-chenzhi · Accepted solution]

Hi @JasonM73 ,

Please modify the expression.

Best Regards,

Zhi Chen

[JasonM73]

Zhi

Thanks that solved the issue and many thanks for taking the effort to detail the steps involved.

Thank you 

J

[JasonM73]

Sorry to be a pain but I am trying to add in the Description (notes) field from the task into my email, the only reference I see is if 'description is true' not the actual contents. Any tips or pointers please?