cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JasonM73
Helper I
Helper I

Reordering Buckets From MS Planner in Email Output

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-chenzhi
Community Support
Community Support

Hi @JasonM73 ,

 

Please modify the expression.

vchenzhi_0-1639471121987.png

 

 

Best Regards,

Zhi Chen

 

View solution in original post

5 REPLIES 5
v-chenzhi
Community Support
Community Support

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.

vchenzhi_0-1639462854898.png

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'))

vchenzhi_1-1639462891337.png

It shows like this.

vchenzhi_3-1639463170085.png

 

vchenzhi_2-1639463152841.png

 

 

Best Regards,

Zhi Chen

 

 

JasonM73
Helper I
Helper I

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

JasonM73_0-1639470688902.png

All set correctly as shown below

JasonM73_1-1639470771264.png

Did I miss something?

 

Thanks

 

J

 

v-chenzhi
Community Support
Community Support

Hi @JasonM73 ,

 

Please modify the expression.

vchenzhi_0-1639471121987.png

 

 

Best Regards,

Zhi Chen

 

JasonM73
Helper I
Helper I

Zhi

 

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

 

Thank you 

 

J

 

JasonM73
Helper I
Helper I

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?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,958)