• Automation

    How to attach a file to HubSpot contact through APIs, in Power Automate

    With this article, the issues and solutions I am trying to address are: On a high level, below is the list of API tasks we have to do to achieve this. We have to make requests to three calls (one less if you have Customer ID already). High level Power Automate flow See below the high level flow I have created to demonstrate: Prerequisites Detailed Flow In this example, I am using a HTTP Request Trigger, which starts when we POST a file and a email-id (I used it to represent a customer in HubSpot contact form). I am doing…

  • Automation

    Power Automate: POST a file to trigger a HTTP flow and upload to SharePoint

    My use case here was to store the resumes uploaded by candidate in a website directly in a SharePoint list. Below is the high level flow the process, created in Power Automate (same you can do in Azure Logic Apps as well with similar steps) Here is the output, i.e., data and file uploaded to SharePoint/Office 365 The HTTP call is expected to be made from the external application such as a web page but for the purpose of testing, here is the Postman screen used: Detailed flow Let us start with an HTTP Request Trigger. You will get a…

  • Automation

    Automating Bayzat leave calendar to post daily list in Microsoft Teams group

    I was wondering if I can have a feature to post who-are-all-on-planned-leave list daily in the HR/leaders group in Microsoft Teams. Searched for a plugin in the marketplace, and tried to find a API also. Finally, contacted the Bayzat support and found they don’t have a developer API available at the moment. Then I went though the normal HTTP calling methods and found it worked well. Sharing with you, hoping someone will find this useful in future. Here is the Adaptive Card output you get in Teams: This is the high level view of the Power Automate App Flow Details:…

  • Automation

    Power Automate: Send daily bugs report in Microsoft Teams from Azure DevOps Boards

    You can simply change same to send a mail notification too, instead of Teams. Sample output on Teams: Development Steps: Step 01 – Create query in Azure DevOps board for Bugs I would start with a Recurrence Trigger (schedule). Check always the Time zone of the trigger will happen on GMT. Step 01 – Schedule I would start with a Recurrence Trigger (schedule). Check always the Time zone of the trigger will happen on GMT. Step 02 – Initialize Azure DevOps URL (optional) I am using this url for hyper linking in the output, which can be considered optional. Step…

  • Automation - Technology

    Power Automate: Send daily status post in Microsoft Teams from a SharePoint List

    Assuming you have a “List” in SharePoint and you want to post a summary/or list as-it-is to a chat group in Microsoft Teams. You can simply change same to send a mail notification too, instead of Teams. Output in Teams: Development Steps: Step 01 – Schedule I would start with a Recurrence Trigger (schedule). Check always the Time zone of the trigger will happen on GMT. Step 02 – Get list items from SharePoint Choose the site address and list name Step 03 – HTML’ize I wanted to format the SharePoint List content as a table and, MS Teams message…