Word template with time table

(1) Share

Report

Posted on by TH-02102138-0

I have created a kind of daily schedule in a Dynamics table:

- Column 1: The time ‘from’
- Column 2: The time ‘to’
- Column 3: what happens in this from-to time window

The template works great, even the variable rows are added according to the data source table.

However, when exporting the daily schedule as a Word file, the daily schedule, which is sorted in ascending order according to the ‘from’ time in the Dynamics table, is mixed up.

In my opinion, this is due to the time when I added which data record row. Does anyone have any idea how I can still sort the table in the Word template in ascending order according to the ‘from’ time?

All responses (2)

Answers (1)

TH-02102138-0 13 on at

Like (0)

Report

Word template with time table

Thank you very much for your quick reply!

Since I need an export template as described above, I need to find a way to export the table with all the times in the correct order.

Does anyone have any idea how a power flow or something similar could look and work?

In Dynamics, all the times are in the correct order until I make some changes so the ‘created’ date changes.
Maybe after a change to one or more items in the table, a flow should update all the ‘created’ dates/times in the correct order as the times are in the first column, right?

Unfortunately, there is another challenge:
The daily schedule works in such a way that, for example, times after midnight must also be evaluated as the end of the day, i.e. they must be in the last rows of the table. For example, venues are left at 01:00 after a concert. Logically, this only happens at the end of the day.

It could work so that all times are sorted from 3:01 AM - 3:00 AM.

I look forward to any help with my problem :-)
Verified answer

Amit Katariya007 8,785 Super User 2024 Season 1 on at

Like (2)

Report

Word template with time table

It is sorted as per the created on date and it is a OOB behaviour.

https://community.dynamics.com/forums/thread/details/?threadid=840f478d-4d75-4867-bba1-580bf216a062