Answered

Asana - creating custom id

(0) Share

Report

Posted on by MKE-Asana-User

Hello,

I would like Asana to generate a new sequential job ticket # every time a new task is created. Unfortunately, this is not a standard feature in Asana, so Asana recommended creating a Microsoft Flow. I'm new to this, but the instructions they provided at the link below are very confusing (missing words, typos, etc.). I followed every step and nothing works. Is there some key information missing from the instructions?

https://paper.dropbox.com/doc/microsoft-Custom-IDs-using-Microsoft-Flow-FsajE38C2BpaloyJBsXra

Thank you!

All responses (2)

Answers (1)

MKE-Asana-User 2 on at

Like (0)

Report

Re: Asana - creating custom id

Oh -- I guess I'd have to be a computer programmer to figure this out. None of that makes sense to me. It's too bad Asana can't provide this common feature in their software.
Verified answer

v-litu-msft on at

Like (0)

Report

Re: Asana - creating custom id

Hi @MKE-Asana-User,

Since there is no global variable in PowerAutomate, so the increased job ticket ID for Asana is not simple. The only way could do is get all tasks, then use Apply to each action to loop them and find the max ID:

1. Create trigger - When a task is created

2. List all tasks of Asana by using API:

API call to get all tasks (with task details) for a particular project - Developers & API - Asana Community Forum

3. Cause Asana doesn't support Order By, so we should use Apply to each action to loop them and find the max ID;

Asana API order by - Stack Overflow

python - How to find the maximum number in a list using a loop? - Stack Overflow

4. Then update the task details via the link you provided with an ID that sub 1 based on the max ID in step 3.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.