Format Date Bucket Name and Assigned to fields

[trishmalloy]

Hi Folks,

Is there a way to format the date w/out the time and get the Bucket name, not ID and Display Name instead of the ID?

[Expiscornovus · Accepted solution]

Hi @trishmalloy,

For the first part you can use a formatdateTime: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#f...

You can for instance apply a short date pattern, which is 'd'. Btw, in my example I am only formatting the first item from my list tasks action. 

formatdateTime(outputs('List_tasks')?['body/value'][0]['startDateTime'], 'd')

 

For the second part you will have to add some logic to retrieve the bucket names from your plan and to filter the list of buckets to the correct bucket and the corresponding name value you want to present.

1. Add a List buckets action

2. Add a Filter Array action. Use the list buckets value as input in the from field. Use your bucketid value in the first field of the filter.

3. Add for example a compose and add the following expression to it. Of course, you can use this expression in other actions. For instance in the create HTML table action you used.

body('Filter_Array')[0]['name']

[trishmalloy]

@Expiscornovus 

I tried your solution for formatting the date but I don't notice any difference. What am I missing? I don't want anything past the date.

[Expiscornovus]

Hi @trishmalloy,

The example of the expression I shared was only formatting the date of the first record of a List of tasks, that's why it has the [0] index in the expression. I thought you only needed to format one row, because you only showed one row in your first screenshot, my bad.

An example of such an expression in for instance an apply to each could like similar like this:

formatdateTime(items('Apply_to_each_2')?['startDateTime'], 'd')

[trishmalloy]

Sorry to be a numbskull. I've tried adding the "apply to each" in various parts of the Send a digest email of all outstanding Planner tasks template and it's still using the long datetime. I'd love some more help!

[trishmalloy]

Also, I tried adding the Filter Array for to get the Bucket Name below the Filter array that comes with the template, no luck there either.

[Expiscornovus]

Hi @trishmalloy,

Can you share a couple of new screenshots?

Ideally one screenshot of the whole flow and one screenshot of the configuration of that specific email action (in edit mode).