Updating tasks in SharePoint List using Power Automate

English Forum Ask the Community
1

Hello.
I am trying to update my teams tasks in a SharePoint list using Power Automate. The idea is that Power Automate will run an update every hour, querying the tasks. The issue I am running into is that I don’t see any option to allow me to query all the tasks in Asana. The only option I see in Power Automate is “Get task by ID (V2)”, which only allows me to leverage specific tasks.

Has anyone else tried to do something like this or is there maybe some connectors I may be missing in Power Automate to Asana?

Thanks in advanced.

2

Hi @JosephB,
I’m not sure, but you need to use the API with an HTTP request in PowerAutomate. See the following link:

3

A user in this related thread confirmed she got this working using the Asana connector for triggers and the HTTP connector + Asana API for reading tasks and custom fields. So the approach @Tetsuo_Kawakami suggested works. The specific endpoint you’d want is GET /projects/{project_gid}/tasks (pulled from this Asana doc). Hope that helps!

4

Thanks for this information Tetsuo.
I have been reading through the documentation to learn more on the API piece. So far I was just working with the built in connectors in Power Automate.

5

Awesome. Thank you for helping me confirm this works and the additional information. Using the API’s is a bit new for me so I will keep diving into this and learning the process. I hope to have an update on my progress soon.

6

@JosephB
I’m glad that the post helped you.
I guess you can use “when a task is created” trigger in PowerAutomate instead of querying tasks.

7

So I have it set up both ways. I started with the “when a task is created” but that only gets me the new tasks, which was a good start. Then I realized that I need it to pull in the current tasks, which has led me to the question about “getting all tasks.” I think with the help I have gotten so far, I am closer to pulling the current list of tasks. Working through some minor errors in Power Automate as I go. To be 100% honest, I am learning Power Automate as I go, so both Asana and PA are fairly new to me.