Send Teams Activity Feed notification from Power Automate using custom Teams Bot
Jun11

Send Teams Activity Feed notification from Power Automate using custom Teams Bot

Activity feed notifications appears in the Teams activity feed panel with link to various locations thus enabling developers to build actionable content. These notifications are sent as push notifications in the Teams client. In this blogpost, let us see how to send Teams activity feed notification using < ol type=”1″>Custom Teams App with a BotPower Automate standard action: Post a feed… Continue Reading Mohamed...

Read More
Call SharePoint REST API in a custom connector (Power Apps/Power Automate)
May29

Call SharePoint REST API in a custom connector (Power Apps/Power Automate)

The Power Automate action Send an HTTP request to SharePoint could come handy in many scenarios to execute SharePoint REST API queries but you will not able to use this action directly in Power Apps. In this blogpost, let us see how to call the SharePoint REST API in a custom connector which can be used either in Power Automate or Power Apps. There are many REST API endpoints available within… Continue Reading Mohamed Ashiq...

Read More
Send Teams channel message aka proactive message using custom Teams bot and Power Automate – Part 2
Mar06

Send Teams channel message aka proactive message using custom Teams bot and Power Automate – Part 2

In the last post, we have seen till the installation of the Teams App with the Bot on a Microsoft Team. Let us now continue to send a proactive message, be it an Adaptive card or a simple Text message on a Teams channel using Bot Framework REST API from a Power Automate Cloud Flow. A proactive message is any message sent by a bot that isn’t in response to a request from a user. Ex: Welcome… Continue Reading Mohamed Ashiq...

Read More
Send Teams channel message aka proactive message using custom Teams bot and Power Automate – Part 1
Feb28

Send Teams channel message aka proactive message using custom Teams bot and Power Automate – Part 1

Microsoft Teams connector in Power Automate has actions which can send a simple text message or Adaptive card as a flow bot in a Teams channel. Messages or cards are posted as the user who’s signed into the connector in the flow or by using the flow bot. Post adaptive card in a chat or channelPost message in a chat or channel Messages can be posted on a Teams channel only if the signed… Continue Reading Mohamed Ashiq...

Read More
Deep Link SharePoint News post in Teams using Adaptive card and Power Automate
Jan30

Deep Link SharePoint News post in Teams using Adaptive card and Power Automate

Microsoft Teams helps us bring together content from different Microsoft 365 services for easier collaboration. In Microsoft Teams connected SharePoint site, SharePoint News connector would help receive news updates from the site. In this post let us see how to create Notifications about new News post with deep link to the post from a communication site in an Adaptive card on a Teams channel… Continue Reading Mohamed Ashiq...

Read More
Share Power Apps with Microsoft Teams Users
Jan30

Share Power Apps with Microsoft Teams Users

You can share an app with Microsoft Teams users since each Microsoft team also creates a Microsoft 365 group in Azure AD. The only pre-requisite is the associated Microsoft 365 group of the Microsoft Team should be securityEnabled. By default, the Microsoft team group is not security enabled. If you are trying to share a Power Apps with a Microsoft team which is not security enabled, you will… Continue Reading Mohamed Ashiq...

Read More
Get deleted SharePoint site details using Microsoft Graph API
Jan09

Get deleted SharePoint site details using Microsoft Graph API

The deleted sites are retained for 93 days and an Admin can restore them. In this blog post let us see how to get the deleted SharePoint site details using Microsoft Graph API application permission. Step 1: Register an application in Azure AD and obtain the client id, client secret & tenant id for the registered application. Add Sites.Read.All Microsoft Graph application permission <img...

Read More
Handling nonexistent, null and multi value type properties in Parse JSON action
Dec31

Handling nonexistent, null and multi value type properties in Parse JSON action

In Power Automate cloud flow, Parse JSON action is used to access properties in JSON content enabling you to select those properties from the dynamic content list on your subsequent actions. Typically the JSON content will be from a response to an API call. The first step after adding the action is to select the source of the JSON content and to add the schema, you can either provide a JSON… Continue Reading Mohamed Ashiq...

Read More
Parse an array without using Parse JSON action in Power Automate cloud flow
Dec31

Parse an array without using Parse JSON action in Power Automate cloud flow

In this blog post let us see how to access the property of an array object without using Parse JSON action. Find below the sample array which has been initialized in an array variable [ { “Name”: “Mohamed Ashiq Faleel”, “Location”: “Stockholm” }, { “Name”: “Megan Bowen”, “Location”: “New York” } ] Add a Apply to each control with...

Read More
Effective Audience Targeting for SharePoint online NEWS Post using Term Store and Power Automate
Dec31

Effective Audience Targeting for SharePoint online NEWS Post using Term Store and Power Automate

In SharePoint Online sites, Audience targeting feature enables you to target relevant content to specific audiences enabling personalization through Microsoft 365 group, Azure AD Security group, Mail Enabled Security group or any combinations of these. The Membership type of the groups can be both Assigned and Dynamic. Target audience(s) can be defined on modern SharePoint pages, News post,… Continue Reading Mohamed Ashiq...

Read More
Conditional Power Automate flow triggers for SharePoint Online Pages and NEWS Post
Dec06

Conditional Power Automate flow triggers for SharePoint Online Pages and NEWS Post

SharePoint Online Pages library is a container for different type of pages (News post, Page, Space, News Link) created in a Communication or Team site. There can be various scenarios to have a Power Automate Flow associated to a SharePoint Site pages library to handle additional processes after a Page or a News post is published. In this blog post, let us see how to Trigger the flow if a… Continue Reading Mohamed Ashiq...

Read More
How to use form-urlencoded content type in Power Automate Custom Connector
Nov07

How to use form-urlencoded content type in Power Automate Custom Connector

Content type x-www-form-urlencoded is used generally to send text data in a query string in the form of name value pairs separated by ampersand. In this blog post, let us see how to use the content-type x-www-form-urlencoded in a Power Automate custom connector. Refer to this post, if you would like to find out how to use it in a HTTP connector. Find below the screenshot from postman… Continue Reading Mohamed Ashiq...

Read More
Create a Power Automate custom connector from Postman V2 Collection
Jul29

Create a Power Automate custom connector from Postman V2 Collection

Postman collections makes the creation of custom connectors in Power Automate easier & quicker. As of time I am writing this article, to create a custom connector using Postman collection in Power Automate the version of Postman collection has to be V1. The current version of collections exported from Postman is V2. There is a NPM package by the name Postman Collection Transformer to rescue… Continue Reading Mohamed Ashiq...

Read More
How to use form-data and form-urlencoded content type in Power Automate or Logic Apps HTTP action
Jul25

How to use form-data and form-urlencoded content type in Power Automate or Logic Apps HTTP action

Content type multipart/form-data is used to send both text and binary data to the server and x-www-form-urlencoded is used more generally used to send text data in a query string in the form of name value pairs separated by ampersand. In this blog post, let us see how to use the content-type multipart/form-datax-www-form-urlencoded in a Power Automate or Logic apps HTTP action to post… Continue Reading Mohamed Ashiq...

Read More
Call a SharePoint REST API as an Application in Power Automate HTTP Connector
Jul18

Call a SharePoint REST API as an Application in Power Automate HTTP Connector

SharePoint connector in Power Automate is very rich with various actions that can make the developers or makers life simple when it comes to interacting with SharePoint data. There might be some actions like Breaking permission to a list itemCreating a siteAdding user to a SharePoint group etc which is not possible through the SharePoint standard connector or MS Graph API as of the time… Continue Reading Mohamed Ashiq...

Read More
Azure Key Vault in Power Automate cloud flow – Could not retrieve values
Jul18

Azure Key Vault in Power Automate cloud flow – Could not retrieve values

Recently I was trying to connect Azure key vault to retrieve certificate details using the action called Get Secret in a cloud flow, as of the time writing this article I am not able to successfully establish the connection. It gave me an error Could no retrieve values as shown below instead of prompting me to enter the credentials to create the connection successfully. To create a… Continue Reading Mohamed Ashiq Faleel’s...

Read More
Call Microsoft Graph API using a certificate in a Power Automate HTTP connector
Jul04

Call Microsoft Graph API using a certificate in a Power Automate HTTP connector

In this blog post, let us see how to call a Microsoft Graph API as an application in a Power Automate HTTP connector using a self-signed certificate instead of a secret from the Azure Active directory application. Find below the list of actions to enable calling the Graph API Creation of Self-Signed certificateApplication Registration in Azure AD PortalCreation of Power Automate cloud flow… Continue Reading Mohamed Ashiq...

Read More
Handle SharePoint site creation response – The site address is unavailable
Jul04

Handle SharePoint site creation response – The site address is unavailable

There is a possibility to change the SharePoint online site address of an existing site by a SharePoint admin or Global admin. There are different options to change the site URL from SharePoint Admin centerSharePoint online management shell I’ve recently faced a scenario recently, after renaming a site URL https://tenant.sharepoint.com/sites/site1 to

Read More
Control your Philips Hue Lights from Microsoft Power Platform and .NET
Jun25

Control your Philips Hue Lights from Microsoft Power Platform and .NET

Philips Hue is a smart lighting solution provider with range of smart lights that can be controlled with your smart devices like your mobile phone, Google Home, Alexa etc through the applications developed by Philips. On top of applications from Philips, the Hue system also enables OAuth 2.0 to allow third party integrations to connect to Hue system resources. In this blog post, let us see how… Continue Reading Mohamed Ashiq...

Read More
Handle HTTP request failures in Power Automate
Jun12

Handle HTTP request failures in Power Automate

If the HTTP request you make in Power Automate gets a 200 OK response, all is good but if the HTTP response has the status codes like 408 – Request Timeout, 429 – Too many requests, 522 – Connection Timeout, 404 – Not found, 400 – Bad request etc there is a problem which needs attention. This post will show you how to handle HTTP request failures using Retry PolicyCustom Retry for requests… Continue...

Read More
How to invite external users to a SharePoint site or Microsoft Team using Power Automate and Graph API
May26

How to invite external users to a SharePoint site or Microsoft Team using Power Automate and Graph API

SharePoint and Microsoft teams services in Microsoft 365 makes it easier to share content or collaborate with external users who is outside your organization. A guest or external user is someone who do not have a school or work account with your organization, they can be your partner, vendor, customer etc. In this article let us see how to build a self-registration experience for external… Continue Reading Mohamed Ashiq...

Read More
Cancel all your running Power Automate flow runs using M365 CLI and REST API
May16

Cancel all your running Power Automate flow runs using M365 CLI and REST API

This blog post is in continuation to my previous one Resubmit your failed Power Automate flow runs automatically using M365 CLI and REST API, in this blog post let us see how to cancel all your running flow runs using CLI for Microsoft 365Power Automate REST API CLI for Microsoft 365: Microsoft 365 CLI helps you manage configuration settings of Microsoft 365 tenant and its various… Continue Reading Mohamed Ashiq Faleel’s...

Read More
Resubmit your failed Power Automate flow runs automatically using M365 CLI and REST API
May09

Resubmit your failed Power Automate flow runs automatically using M365 CLI and REST API

Have you ever been forced to resubmit lot of failed Power Automate flow runs manually, if so this blog post will help you to automatically resubmit the flow runs using CLI for Microsoft 365Power Automate REST API CLI for Microsoft 365: Microsoft 365 CLI helps you manage configuration settings of Microsoft 365 tenant and its various services like SharePoint, Power Automate, Power Apps,… Continue Reading Mohamed Ashiq...

Read More
Everything to know about Power Automate REST API to manage and administer your flows
May09

Everything to know about Power Automate REST API to manage and administer your flows

Power Automate Management connector enables interaction with Power Automate management service to manage your flows with different actions to create, edit and update flows. If you want to do more but you were not able to find an action with this connector for e.g. get details on the Runs the flow has made, as of now there is no action which gets the run details of a flow with the Power… Continue Reading Mohamed Ashiq...

Read More
What is GraphQL and how to consume a GraphQL Query based API in Power Automate
Apr25

What is GraphQL and how to consume a GraphQL Query based API in Power Automate

I had a recent requirement to call a GraphQL based API secured with OAuth2 in Power Automate, this blog post is to share my learnings on GraphQL & how to call them in Power Automate. Let us quickly see some introduction to GraphQL GraphQL is an open-source query language for your APIs with a service-side runtime for executing the queries based on pre-defined schema. It is not tied to any… Continue Reading Mohamed Ashiq...

Read More
Call Microsoft Graph API as a daemon application with application permission from Power Automate using HTTP connector
Mar16

Call Microsoft Graph API as a daemon application with application permission from Power Automate using HTTP connector

With the assumption that you know about Microsoft Graph and its capabilities I will directly jump in with the steps and instructions to call Microsoft graph Endpoints as a daemon app or using Application permissions with the help of HTTP connector. Calling graph from a flow opens a wide range of possibilities which are not available with the prebuilt connectors. As of now you will not be able… Continue Reading Mohamed Ashiq...

Read More
Call Microsoft Graph API as a signed in user with delegated permission in Power Automate or Azure Logic apps using HTTP Connector
Mar16

Call Microsoft Graph API as a signed in user with delegated permission in Power Automate or Azure Logic apps using HTTP Connector

If you have a requirement to access graph endpoint as a signed in user/account on an instant/automated/scheduled flow, this blog post will help you with instructions and steps to access the Microsoft graph API with delegated permissions using the HTTP connectorInvoke an HTTP request connector There are resources (Presence information, Planner etc) in Microsoft graph which is available… Continue Reading Mohamed Ashiq...

Read More
Call Microsoft Graph API in Power Apps and Power Automate using a Custom connector
Mar16

Call Microsoft Graph API in Power Apps and Power Automate using a Custom connector

Microsoft graph is a gateway to data and intelligence in Microsoft 365 which connect multiple services like SharePoint, Teams, Planner etc and devices. Microsoft graph has one common endpoint that is RESTful Web API enabling you to access Microsoft Cloud service resources. With that said if you want to communicate with Microsoft Graph Services or any API services, custom connectors can be used… Continue Reading Mohamed Ashiq...

Read More
How to use Microsoft graph SharePoint Sites.Selected application permission in a Azure AD application for more granular control
Mar15

How to use Microsoft graph SharePoint Sites.Selected application permission in a Azure AD application for more granular control

As per this announcement made on Feb 2021, Microsoft graph now provides option to have granular permissions level using Sites.Selected application permission for the AD application instead of granting permission to the application for all the sites in the tenant. The permission Sites.Selected does not provide access to any SharePoint site collections for the application unless the application… Continue Reading Mohamed Ashiq...

Read More
Send email from a common mailbox in Power Automate using Microsoft Team or Shared Mailbox
Feb28

Send email from a common mailbox in Power Automate using Microsoft Team or Shared Mailbox

Power Automate is widely used to automate many business processes and Email is one of most widely used action to send out notifications. Having said that, there will be definitely request to send the email from a generic address instead of the flow creator email address or the email action’s connection owner email address as shown below: By default, the from Address of the mail… Continue Reading Mohamed Ashiq Faleel’s...

Read More
Azure IoT with Arduino UNO board to turn on/off LED using a .NET core console application connected to Power Apps
Feb28

Azure IoT with Arduino UNO board to turn on/off LED using a .NET core console application connected to Power Apps

This post is in continuation to my journey with IoT leveraging Microsoft cloud services & it’s technology and based out of few questions I have been asked in few of the events I’ve spoken on the Topic Controlling Devices using Power Apps. In this post let us see how to turn on/off a LED connected to an Arduino UNO board by sending a message from Azure IoT hub or Power Apps with the help of a… Continue Reading Mohamed...

Read More
How to create & setup Dynamic Microsoft 365 Group or Distribution list based on the user’s domain for Teams, Yammer and Exchange
Jan24

How to create & setup Dynamic Microsoft 365 Group or Distribution list based on the user’s domain for Teams, Yammer and Exchange

There are many organizations maintaining multiple domains on a single Microsoft 365 or Azure AD tenant, in those cases there might be a need to create dynamic Microsoft 365 groups, security groups & distributions list based on the user’s domain. On this blogpost, let us see how to Create Dynamic Microsoft 365 group based on the user’s domain for Teams & YammerCreate a Dynamic… Continue Reading Mohamed Ashiq...

Read More
Find the Microsoft 365 account license and service details for a user using Microsoft Graph API
Jan21

Find the Microsoft 365 account license and service details for a user using Microsoft Graph API

Is there a need to find the type of Microsoft 365 license and the different services assigned for a user to troubleshoot an issue related to the service they have been assigned? You have come to the right place, this post will help you find the details using the Microsoft Graph API endpoints. In Microsoft 365, licenses from licensing plans also known as SKUs give users access to the Microsoft… Continue Reading Mohamed Ashiq...

Read More
Trigger an Azure Webjob from Power Automate
Jan11

Trigger an Azure Webjob from Power Automate

On this post let us see how to trigger or run a WebJob from Power Automate. WebJob is a powerful service in Azure keeping in mind the supported file types or programs it can run. Before proceeding with the instructions to call a WebJob in Power Automate, let us see some basics of an Azure WebJob. WebJobs is a feature of Azure App Service that enables you to run a program or script in the same… Continue Reading Mohamed Ashiq...

Read More
How to use your MS Teams as an email distribution list
Nov08

How to use your MS Teams as an email distribution list

When you create a Microsoft Team, a Microsoft 365 group is created to manage the team membership like Owners, members, guests. I would rather say the Microsoft 365 group is a backbone of a Team. Through the group you also get an email address for the MS team. Find the other Microsoft 365 services which gets created per this documentation whenever there is a Team provisioned On this… Continue Reading Mohamed Ashiq Faleel’s...

Read More
How to setup custom domain and email address in Microsoft 365 online tenant
Nov08

How to setup custom domain and email address in Microsoft 365 online tenant

On this blogpost let us see how to add a custom domain and configure exchange email address for the added domain in a Microsoft 365 tenant. This will allow you to create M365 identities for the users in the Microsoft 365 tenant like user@domain.com instead of user@domain.onmicrosoft.com. This setup is also required if you have a Hybrid setup with users from Onpremise Active directory. Azure AD… Continue Reading Mohamed Ashiq...

Read More
Teams Presence Light with Raspberry Pi
Nov01

Teams Presence Light with Raspberry Pi

Almost every one of us is working from home these days due to the Corono situation we are in as of the time I am writing this article. I wrote a recent blog post about controlling devices from PowerApps with the help of a Raspberry PI and thought of extending the project by creating a Teams presence light with the help of a Raspberry Pi & couple of LED’s with different colours. This was… Continue Reading Mohamed Ashiq...

Read More
Learn how to control devices from PowerApps using Raspberry Pi
Nov01

Learn how to control devices from PowerApps using Raspberry Pi

I have recently purchased a Raspberry Pi 4 to explore IoT with Microsoft 365 platform. The Raspberry Pi is a low-cost credit-card sized computer which can be connected to a monitor, keyboard, mouse and to Internet via Wi-Fi or ethernet port. In addition, the Raspberry Pi has a 40 pin GPIO (General Purpose I/O) connector for us to connect sensors (Input) and to control devices (Output) through… Continue Reading Mohamed Ashiq...

Read More
Tools to call Microsoft Graph API endpoints as a User and application
Oct25

Tools to call Microsoft Graph API endpoints as a User and application

This blogpost will help you to explore and interact with MS graph API endpoint’s using the following tools Postman clientSigned in as a user/On-behalf-of API call (Delegated permission)Application/daemon API call (Application permissions)Graph Explorer I have used MS graph extensively on different MS cloud services like SharePoint, PowerAutomate, PowerApps, Azure services like Azure… Continue Reading Mohamed Ashiq Faleel’s...

Read More
Collect response from multiple users with Adaptive Card in Teams using Power Automate
Sep07

Collect response from multiple users with Adaptive Card in Teams using Power Automate

This post is in response to a comment in one of the most viewed article from my blogsite to post an Adaptive card to an user in Teams using PowerAutomate. Assume we have a use case for using Adaptive card for collecting response from n number of users based on the data from an Excel, SQL database etc. The response must be unique for users so there has to be separate instance of Adaptive card… Continue Reading Mohamed Ashiq...

Read More
Extending Guest Account capabilities by assigning a license in Microsoft 365
Aug15

Extending Guest Account capabilities by assigning a license in Microsoft 365

If a guest user has to access a PowerApp, they will not able to access it unless they have a license. On this blog post lets see how a M365 license can be assigned to a Guest user on your tenant. Before getting there, lets see some information about guest accounts. Microsoft 365 allows guest access which lets you to add users outside your organization for B2B collaboration on your… Continue Reading Mohamed Ashiq Faleel’s...

Read More
How to find the Operating System and stack of an existing Azure website
Aug08

How to find the Operating System and stack of an existing Azure website

Azure websites also known as app service can be easily created through multiple interfaces like Azure Power shell, CLI, Azure portal etc. While creating the website or App Service you will have to select the operating system, default choice is Windows. OS selection also depends on the runtime version you select (.NET framework, .Net core, Java etc). If you have an existing website connected to… Continue Reading Mohamed Ashiq...

Read More
Hosting static HTML content in SharePoint Online site & Azure
Aug08

Hosting static HTML content in SharePoint Online site & Azure

The SharePoint Online experience which you get by default for all the sites you create in the tenant is modern by default. The site pages you create in the modern experience are fast, easy to author and support rich multimedia content. The pages look great on any experience i.e. mobiles, browser, SharePoint App. If you wanted to host static HTML content with JavaScript, CSS, BootStrap on a… Continue Reading Mohamed Ashiq...

Read More
How to use a sample PCF component in your Power Apps
Jul28

How to use a sample PCF component in your Power Apps

If you are PowerApps developer and wanted to extend the capabilities by bringing in third party or community driven PCF (Power Apps Component Framework) components, you can find lot of samples from the Power Apps community website PCF.gallery, Power Apps Community and from Microsoft for Model driven and Canvas apps. Sample components from Microsoft If you are new to component… Continue Reading Mohamed Ashiq Faleel’s...

Read More
SharePoint Online & MS Graph API Metadata service document
Jul15

SharePoint Online & MS Graph API Metadata service document

I have recently received a request from a customer to break the inherited permissions of a SharePoint document library folder, as of now there is no Power Automate action to break the permission of a folder but with the action Send an HTTP request to SharePoint you can call any SP REST API endpoint. Then I started exploring the Rest API endpoint to break the permission, have found the API… Continue Reading Mohamed Ashiq...

Read More
Create Tile view card for custom List item image attachments using PowerAutomate & JSON row view formatting
Jul13

Create Tile view card for custom List item image attachments using PowerAutomate & JSON row view formatting

In Modern SharePoint lists you can display list item content in a more modern way using the Tiles view layout. If you have very big list with multiple columns along with picture columns you get a horizontal scroll bar on the list view, the Tiles view can solve this issue since the content will be displayed on the tile card where you can design the layout of the tile card to display the… Continue Reading Mohamed Ashiq...

Read More
Convert Outlook Email with embedded images to PDF using PowerAutomate
Jun19

Convert Outlook Email with embedded images to PDF using PowerAutomate

Recently I’ve came across a business case with need to automate the conversion of Outlook email messages with embedded images to PDF document. This could be done manually on Outlook client using Microsoft Print to PDF or browser Print if opened using Outlook on the Web. This process can be automated with the help of PowerAutomate trigger When a new email arrives and actions Export Email,… Continue Reading ashiqf’s Article...

Read More
Batch SharePoint requests [GET, POST, PATCH, DELETE] in PowerAutomate and MS Graph
Jun16

Batch SharePoint requests [GET, POST, PATCH, DELETE] in PowerAutomate and MS Graph

Batching helps you in optimizing the performance of your application by combining multiple requests into a single request. SharePoint Online & MS Graph APIs supports the OData batch query option. Batch requests MUST be submitted as a single HTTP POST request to the batch endpoint of a service as below for SharePoint REST API: POST https://domain.sharepoint.com/sites/sitename/… Continue Reading ashiqf’s Article on their...

Read More
Create/Delete a SharePoint custom theme using PowerAutomate
Jun15

Create/Delete a SharePoint custom theme using PowerAutomate

In a modern SharePoint site you can create custom themes using PowerShell, REST API & CSOM. In this blogpost I will show you how to create themes using PowerAutomate. The following REST endpoints are available http://<site url>/_api/thememanager/AddTenantThemehttp://<site url>/_api/thememanager/DeleteTenantThemehttp://<site url>/_api/thememanager/GetTenantThemingOptionshttp://<site… Continue Reading...

Read More
Multiple ways to access your On-premise data in Microsoft 365 and Azure
Jun08

Multiple ways to access your On-premise data in Microsoft 365 and Azure

If your organization is using a hybrid cloud environment, this post will shed some light to integrate on-premise resources with Microsoft 365 & Azure services. Hybrid integration platforms allows enterprises to better integrate services and applications in hybrid environments (on-premise and cloud). In this blog post, I will write about the different services & tools available with in… Continue Reading ashiqf’s...

Read More