[Question]: How to connect Power Automate with awork?

[Jessry59]

What is your question?

Hello, I would like to connect awork with Power Automate. The goal is to create an automation using Power Automate so that I receive an email notification when the planned time expenditure of 50% is reached in awork for a project. Unfortunately, this is currently not possible with the automations in awork itself.
My first idea was to create a custom connector for awork in Power Automate using the API. But which API do I use for this? How should it be structured? A client secret has already been created for this. The Automatisation should work for all our projects.
Many thanks in advance!

Do you have a trace id of the call?

No response

[vdurante]

Hey @Jessry59! How are you?

Awesome automation idea, I will add it as a feature request internally!

Regarding your custom integration, let’s see if I can help you!

There are several nuances in the implementation, but I would probably try something like this:

1. Trigger Power Automate job every day in the morning
2. Get all projects that don’t contain the tag notified-50
3. For each project
   1. If project has reached 50% of planned expenditure calculated by trackedDuration / plannedDuration > 0.5
      1. Add comment to project warning the project has reached 50% of expenditure, indirectly notifying project members
      2. Add notified-50 tag to project, flagging the project to show it was notified already

This is just an idea. Alternatively, you could notify the users through e-mail or other ways using 3rd party providers through Power Automate. You could also keep a database or shared excel file to store the project ids that have being notified already, so you don't have to use a tag.

I will point you to a few links to help you guide through the implementation.

• Here you can find how to authenticate to our API: https://developers.awork.com/authentication
• Here you can find all our API endpoints: https://openapi.awork.com/
• Detect if the planned expenditure of a project has reached 50% - I suppose you want to calculate this by dividing the tracked times in a project by the planned duration of a project. This information is available in our Project models and endpoints. They go by the name of trackedDuration and plannedDuration.
  To fetch multiple projects you can use: https://openapi.awork.com/#/Projects/get_projects
  To fetch a single project you can use: https://openapi.awork.com/#/Projects/get_projects__projectId_
  How to apply a filter on a request: https://developers.awork.com/filtering
• Notify other users - unfortunately we don’t have a way of directly sending a notification to other users through awork API. You could use some other 3rd party solution through Power Automate to notify the users. You could also maybe add a comment on the project so the project members are notified indirectly?
  To comment on a project: https://openapi.awork.com/#/Comments/post__entityName___entityId__comments
• Add tag on the project - just call /projects/id/addtags like here: https://openapi.awork.com/#/Tags/post_users__entityId__addtags

Unfortunately, we are not experienced on Power Automate, but I will try to send you a few URLs that may help you build your implementation.

• I would likely use a Scheduled Trigger to run this automation every day at morning
  Run scheduled tasks - https://learn.microsoft.com/en-us/power-automate/run-scheduled-tasks?tabs=classic-designer
• I would likely use an HTTP connector to make the request to awork API
  Overview of HTTP connectors in Power Automate - https://learn.microsoft.com/en-us/training/modules/http-connectors/

Good luck on your implementation!