Answered

Email Task List using Bucket Name instead of BucketID sorted by Bucket Name

(0) Share

Report

Posted on by timr

I have been looking at other solutions provided before combined with my own testing and have come to a standstill.

My goal is to produce a list of tasks with the bucket ID replaced by Bucket Name, sorted by Bucket Name, and then emailed out. My core flow is as follows:

The output received via email currently is:

Obviously the BucketID is useless for a human to read, so fixing that is first and foremost. Something like a vLookup in excel would do the trick if it existed. Then after that is replaced I would like to sort by Bucket Name, which I haven't found a way to do that either. Any assistance is appreciated as this is driving me nuts!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @timr,

You could try the following methods to achieve your needs:

1. Use List tasks action and List buckets action to get all the tasks and buckets, and initialize the array variable to hold TaskList.

2. Use Apply to each to traverse the value of List buckets output, nesting a layer of Apply to each to traverse the contents of List tasks output.

3. Use Condition to determine whether the bucket id of the current task is equal to the bucket id output by the List buckets action currently traversed.

4. If equal, the output from them is appended to the array as an object.

5. Finally, the array is used as the content of Html table.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
timr 12 on at

Like (0)

Report
Copy link

Link copied!

This is great and working so far! Any idea on how to sort the array?

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @timr,

Sort array? What do you mean?

The same BucketName in the table is already displayed continuously.

This is just the Html table. All that can be done here is to display the contents of the relevant fields in a table without filtering or sorting.

Regards,

Was this reply helpful? Yes No
timr 12 on at

Like (0)

Report
Copy link

Link copied!

You are correct, they are grouped by bucket name, but they are not sorted so bucket names beginning with "A" are displayed mid-list. It is simpler for the teams and myself to find their area when sorted alphabetically. Was hoping to find a sort function or something. Any ideas?

Was this reply helpful? Yes No