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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,040)