Anonymous

My feedback

  1. 40 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Public » Planner  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anonymous commented  · 

    Not the best solution, but the best I can come up with currently. I have created a Microsoft Flow which is triggered whenever a planner task is created. On task creation it then triggers "Update Task" and updates the Title to the task title with a custom ID appended.

    Expression used to generate a custom {T00000};
    concat('{T',string(int(div(sub(ticks(utcNow()),ticks('2020-01-01')), 60000000))),'}')

    With the number being number of tenths of a minute (6seconds) since 01/01/2020. 60000000 being the conversion from 100 nanoseconds to tenth of a minute. Downside is 2 tickets created within 6 seconds of each other would receive the same ID. the "from" date could be changed to reduce the initial numbers. Not tested what would happen if title character limit is already reached.

    For my needs this seems to work (also assigning the ticket creator to the ticket on creation, could do other things in this step if wanted...)

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

    bump

Feedback and Knowledge Base