awork-io / awork

The awork Github repo supports you with awork integration and api questions. Here you can find links to further documentation, a FAQ with the most frequently asked questions and great code examples to get started even faster.
https://www.awork.com
11 stars 0 forks source link

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

Open Jessry59 opened 10 months ago

Jessry59 commented 10 months ago

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 commented 10 months ago

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.

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.

Good luck on your implementation!