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...
Power Apps Portal: “Table permission changes for forms and lists on new portals” So what?
In case you missed it… We’ve got a portal page with the form which is available for anonymous users. It’s a valid scenario. And the way we set it up previously was like this: Advanced form No authentication is required. Advanced form – no authentication is required. Advanced Form Step – Enable Table Permission option is not set. “Enable Table Permission” option wasn’t… Continue...
Dataflows for PowerApps: loading data from CSV file without copying it to OneDrive in advance. ???
I would like to share my recent experience with loading a CSV file via Dataflow to Dataverse with you. Today, I downloaded the list of leads from the conference we sponsored last week. There is no better way to load it to my sales app on Dataverse – it’s a Dataflow way! At least for me . I needed to transform columns to combine all extra information available into a big Description column…. Continue Reading Olena...
Child Flow: the ‘runAfter’ condition is not satisfied.
When you tired, it’s 9PM on Monday … It’s Monday. I’m too tired to slap you. Could you please bash your face against my palm? Respond to PowerApp or flow action Respond to PowerApp or flow action doesn’t get triggered. I wonder why… Respond to PowerApp or flow action doesn’t get triggered ActionConditionFailed I’ve got two actions leading to Respond to a PowerApp or flow is…...
Power App Portal Web API – fighting lookups
We will start with the 100% helpful Microsoft docs articles: Portals Web API – Power Apps The portals Web API enables building a richer user experience inside Power Apps portals pages. You can use the Web API to perform create, update, and delete operations across all Microsoft Dataverse tables from your portal pages. Portals operations using the Web API – Power Apps You can perform available Web API operations in portals....
Dataflows for Power Apps: run import from the app
As you know I am a very big fan of Dataflows. The biggest ask from me was always the ability to trigger the Dataflow refresh on demand from a Power App. Initially, Dataflows you could only run from the maker portal. You need all sort of “powerful” security roles and permissions to do so. Dataflows on a maker portal As a user I want an ability to trigger a bulk import with Dataflows… Continue Reading Olena Grischenko...
Save Dataverse Notes to Azure Blob Storage and Display on PowerApps Portals
Last month I posted the article describing our exercise with the Azure Blob for the portal notes. The Part 1 is here: https://msolenacrm.blog/2021/07/20/azure-storage-integration-for-power-apps-portals/ This is the second part I advertised created by Mira and all implementation credits go to her as well : “I have been Exploring with Olena (https://msolenacrm.blog/) how to enable the… Continue Reading Olena Grischenko...
Simple Azure Invoice OCR Tutorial
We are exploring OCR capabilities for invoice processing. This is the article which may help you to understand how it work if you want to train a custom model to use it then with Power Automate. Do you want your own OCR which costs less than a coffee? All credits go to Nick Grischenko. Continue Reading Olena Grischenko (she/her)’s Article on their blog Simple Azure Invoice OCR Tutorial We are exploring OCR capabilities for...
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...
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...
Azure Storage integration for Power Apps portals
To answer the question Why? I say we run into some limitations with SharePoint integration. And now we are trying to explore other options. Let’s get started! Enable Azure Storage This is a great blog post here: Want to leverage Azure storage for your documents in PowerApps/ Dynamics 365 portals instead of Notes? Check this out – Debajit’s Power Apps & Dynamics 365 Blog It’s got… Continue Reading Olena...
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...
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...
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...
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
Power Automate with Dataverse: Saving API calls to Dataverse. Expand or Link-Entity?
Within Power Automate I am trying to make SINGLE(paginated) call to Dataverse to get the list of Work Orders with the particular status linked to Account but not directly but via extra layer. Also, I can retrieve extra lookup tables which are required by logic. All in a single call because making extra API calls is expensive and evil! The FetchXML query looks like one below: Query WO… Continue Reading Olena Grischenko...
Power Automate with Dataverse: “Apply to each” current item/previous item
Recently I was working on the solution and in the middle of the development discovered that I desperately need to refer to the previous item in the loop. Let’s say, I iterate through the list of items I received via List Rows (Dataverse). I check a condition in the next iteration and based on the condition I need to do something with the item from the previous step. I know it sounds crazy…. Continue Reading Olena...
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...
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...
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...
How do I pass executionContext as a parameter into my Promise to fit in Promise.all()?
To be honest, this post should be a bit longer with more details but I like it this way. This is a sample below. It looks cool. And I building one of my own. But I need it to work with my onSave form validation. const promise1 = Promise.resolve(3); const promise2 = 42; const promise3 = new Promise((resolve, reject) => { setTimeout(resolve, 100, ‘foo’); }); Promise.all([promise1,… Continue Reading Olena...
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...
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...
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...
Where is my Tenant ID? (not Azure portal)
In the casual conversation with Microsoft I was asked about my customer Tenant ID. As a person who use to superpower and admin privileges I went straight to Azure portal: Microsoft Azure No Description Unfortunately, I don’t have the same level of power in my customer organisation as I have in my own. I simple didn’t have access to… Continue Reading Olena Grischenko (she/her)’s Article on their blog Where is my...
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...
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...
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...
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...
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...
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...
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...
Dynamics 365 Sales Pro Trial Setup
Go to: https://trials.dynamics.com/ Let’s create your Sales Pro trial in these easy steps (below). Go to trial page to set up trial Scroll down to the highlighted option. Choose for dev purpose option No, continue signing up Create a new account instead Tell us About yourself section. Add details. Enter your phone. Use Verification code. Create your business… Continue Reading Olena Grischenko’s Article on their blog...
Getting data from a function in an on-prem SQL server via Gateway in Power Automate
Dataflow magic in Power Automate. SQL with Power Query in Power Automate. Did you know you can do this? CloudMinded Blog “We are screwed!” me at the moment of technology induced panic That was the feeling when I saw the below error messages. The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow… Continue Reading Olena Grischenko’s Article on...
Dataflows for Power Apps: calling a table-valued SQL function with Power Query
It’s very easy to query SQL table-valued function to retrieve the result with Dataflows. This is how we do this. Let’s connect to a database. It will work via gateway as well. Select your function. Pass the parameter if required. Now you can use this table to merge with other tables or map and load to Dataverse. Super easy! Continue Reading Olena Grischenko’s Article on their blog...
![❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables](https://i0.wp.com/365community.online/wp-content/uploads/2021/01/Dataflows-for-Power-Apps-The-column-‘Column_name-of-the.png?resize=240%2C240&ssl=1)
❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables
There is an option to load data to multiple table in one go in Dataflows. These tables can be related. Dataflow engine calculates the dependencies and determines the correct order for loading. It’s a very cool functionality, however, you have to be aware of some potential issues as well as available workarounds. Problem: I am trying to load bills and meter data in to Dataverse tables. The… Continue Reading Olena...
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...
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...
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...
Azure Functions in Power Platform multiple environments
Working with real customer’s deployment requires managing multiple environments – at least Test and Production or additionally a Dev environment. One of the common patterns we use in the solutions is to use Azure Functions as an effective, serverless extension of the point-and-click Power Automate flows. This pattern utilises a Custom Connector created to embed the function call and… Continue...
Dataflows for Power Apps: transform fixed-width text files
What is a fixed width text file? Data in a fixed–width text file is arranged in rows and columns, with one entry per row. Each column has a fixed width, specified in characters, which determines the maximum amount of data it can contain. No delimiters are used to separate the fields in the file. Could we load data from a fixed-width file with dataflow? Absolutely! This file below is… Continue Reading Olena...
Dataflows for Power Apps: cyclic reference error with multiple data sources when you start with empty query
As simple as this: if you don’t believe in solutions with Dataflow and just copy queries across most likely you are going to get the following error: I had multiple data sources: Dataverse and CSV file. Because I didn’t go through the normal order for steps but just started with an empty query and just copied queries across I started getting this error immediately after adding a… Continue Reading Olena...
Dataflow for Power Apps: “section Section1;…” error on create
This error for me occured when I was copying scripts and using blank queries. This is not my image, not my database, so don’t try to access it, please I found it in Internet to illustrate the point. section Section1; error This message is a little bit a lot not helping. If you deploy something to PROD at night it is also very stressful. So what do we do? We start here:
❤Dataflow❤ with Power Apps: bulk update for CDS records
This article is using a test data because using customer data is wrong. The rest is very practical stuff. If you don’t use Dataflow for Power Apps still I think you should. I am trying to solve a typical problem. We’ve got a Choice column Business Type for Account (for example). We need to remove one of the choice items “Re-seller” from the Choice but first we need update all related… Continue Reading...
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...
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...
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...
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...
Dataflow for Power Apps: query CDS (improved)
Recently I posted about the same issue. Yesterday I discovered a new way. It looks like OData connector is more friendly than the Web API one. Use FetchXmlBuilder to help you to build the query. Start creating you Dataflow: For the data source on the tab Other pick up the OData connector. For the Connection String URL will be like:
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...