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...
Import solution to CDS. Missing Connection references error…
In the morning i tried to bring back some stuff from UAT. When I tried to import my solution back to DEV I was getting errors. My solution contained Flows. I went the classic interface to import the solution. I’ve got some connection references missing. I went back to the source environment to add the missing components. Make sure you added all you need. Because I… Continue Reading Olena Grischenko’s Article on their...
❤ Dataflow for Power Apps: query CDS via Web API❤
In my Dataflow you would like to query CDS data. This is how I you it. Click on New dataflow and enter the name. On the next screen on the tab Other select Web API. Go to your model-driven app Advanced Settings. Select Customizations -> Developer Resources. Copy Instance Web API Service Root URL. Paste the URL to Web API URL Connection settings. Select… Continue Reading Olena Grischenko’s Article on their blog ❤...
Connection references : Power Automate
Microsoft announced eagerly awaited feature yesterday i.e “Connection references” . Let us understand what it is. Problem Statement: Adding Multiples Power Automate/Flows in a solution package and importing them into higher environment is a great feature. It solved the problem to deploy each power automate individually to higher environments. However, there is still an issue … Continue reading… Continue Reading...
Field Service Installation: are we there yet?
When you clicked on the magic button which you found here how do you monitor the progress? In the Power Platform admin center go to Environments. In the list of environments click on the environment you are upgrading Field Service on: https://admin.powerplatform.microsoft.com/environments From Resources click on Dynamics 365 apps … Enjoy the progress! Continue Reading Olena Grischenko’s Article on their blog Field Service...
Field Service upgrade: where is my button?! 🤔
With the new Power Apps admin portal if you want to upgrade the Field Service solution you have to do the following: Go to Power Platform Admin center: Power Platform admin center No Description 2. From the left navigation Resources -> Dynamics 365 apps: 3. Select Dynamics 365 Field Service. 4.Click on … then click on Install. It looks scary so I didn’t want to click until… Continue Reading Olena...
Power Apps Portal: deactivating records from a portal via Web API
All the amazing docs, which help you to start are available here: Perform portals Web API operations – Power Apps This article is pre-release documentation and is subject to change.] You can perform the available Web API operations in portals. Web API operations consist of HTTP requests and responses. This article shows sample operations, methods, URI, and the sample JSON you can use in the HTTP request. Use the Web API for...
Power Apps portal Web API: (ERROR)An undeclared property … which only has property annotations in the payload but no property value was found in the payload…
Looking at Web API for portals this weekend. For the scenarios we currently workaround, with the API it’s all easy. There is a very documentation available which will help you to start: Perform portals Web API operations – Power Apps This article is pre-release documentation and is subject to change.] You can perform the available Web API operations in portals. Web API operations consist of HTTP requests and responses....
Dynamics 365 CE: Investigating the conflicting business rules issue
Recently, we run into the weird issue which we initially assessed as the upgrade to V9 related. The issue was that some form fields were aren’t marked as required based on the Account type based on the business logic. We use the unhealthy mix of scripts and business rules for the form logic. Also, we inherited most of the code from previous vendors. Luckily for me, I was reviewing and… Continue Reading Olena...
Power Apps portals: my Edit button doesn’t show on a grid (Déjà vu)
I’ve been working with portal for so many years that every time something like this is happening I feel like dying of emberrasement. For my demo entity list, I couldn’t get the Edit button to appear and I knew, I knew it was about Entity permissions. You need to make sure you set up your permissions correctly and add these permissions to your user role. And clear cache. This is the… Continue Reading Olena...
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...
Making Canvas App responsive- Part 2
The first step towards making canvas app responsive is to change the settings of the app. The previous article explained how we can do that. Once that is done, we have to make changes to screens and controls on them so that they respond to different screen dimensions. Making screens responsive: Let’s start with screens … Continue reading “Making Canvas App responsive- Part 2” The post Making… Continue...
Xrm.WebApi. “The query parameter $select is not supported” error.
Don’t be like me! This is the JavaScript: var uriClientLegacy = “?$select = cca_legacyservicefee, defaultpricelevelid & $filter=accountid eq ” + clientLookupId; Xrm.WebApi.retrieveMultipleRecords(“account”, uriClientLegacy).then( function success(result) { … }, function (error) { console.log(error.message); // handle error conditions alert(error.message); }); And this is the… Continue...
Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?
The requirement is to summarize 4 number field values to determine if the total is greater than 0. What could possibly go wrong? You think it should be somewhere in the Expression under Math functions. Think again. The add only allows to summarise 2(!?) numbers. Not 3, not 4. It let me to add extra fields and passed the validation then it failed on a run. The solution is to use… Continue Reading Olena Grischenko’s Article...
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...
Power Automate: Group/Ungroup in Advanced Condition
It’s not even a post … Just saying I was wondering how simple is to group or ungroup conditions in the Condition action block. Very simple! From Scratch For existing – Group For existing – Ungroup It seams pretty obvious but I wasn’t sure it exists in a user-friendly manner. It does! Continue Reading Olena Grischenko’s Article on their blog Power Automate: Group/Ungroup in Advanced Condition...
Making Canvas Apps responsive – Part 1
With the growing demand of Power Platform, user’s requirements are also becoming more interesting and challenging. Responsiveness is something that has been available to users on apps built on other technologies. This post is on the same – making canvas apps responsive. Unlike other technology apps where we have separate CSS and HTML files to … Continue reading “Making Canvas Apps responsive… Continue Reading...
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...
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...
Work on multiple sessions at a time using Customer Service Workspace
Customer Service workspace is a model driven app module which increases agent productivity for core customer service with the ability to work on multiple sessions at a time in a single workspace experience. Managing cases and activities in the Customer Service workspace app module works the same way as Customer Service Hub and Omnichannel for … Continue reading “Work on multiple sessions at a… Continue Reading...
D365 FO/LOGIC APPS: REST SERVICE FOR ACCEPTING JSON & INSERTING RECORDS INTO A TABLE
MANAGEMENT, LOGIC APPS, ODATA-OPEN DATA PROTOCOL, TIPS & TRICKS D365 FO/LOGIC APPS: REST SERVICE FOR ACCEPTING JSON & INSERTING RECORDS INTO A TABLE D365 FO/Logic Apps: REST Service For Accepting JSON & Inserting Records Into A Table – All About Microsoft Dynamics D365 Finance and Operations and LOGIC APPS, REST SERVICE FOR ACCEPTING JSON & INSERTING RECORDS INTO A TABLE, Logic Apps HTTP...
Power Apps Portal: deactivate account, no workflow please, thank you
The real-life scenario: a portal user (agency) indicates that they don’t manage a particular property anymore. The action is performed via self-service portal. From a user experience perspective, the property has to “disappear” from the list of active properties immediately after “no manage” action is performed. If we choose to use Deactivate as an action we’ve got two documented choices…...
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...
Power Automate: watch your (white)space!
Well, as per the title. Watch your whitespace. For example, I was getting this error on the checker and tried to figure out what is wrong with the reference name. Flow Checker error When you use expressions you have to type things in. This is where you have to extra careful. Typing in expressions may cause errors It seams to look OK but in reality it’s a bit not OK, we just… Continue Reading Olena Grischenko’s...
Monitoring Model Driven App
Until now , there is no easy way to monitor model driven app flow,network events and performance other than using fiddler or browser developer tools. For Canvas Apps , we have Monitor tool to debug or identify performance issues. Fortunately, Microsoft has recently announced that Monitor now supports model-driven apps. It provides a way to … Continue reading “Monitoring Model Driven App” The… Continue Reading...
Power Apps Portals: where do I find my portal current version?!
It’s a very simple question indeed. If you think you can just go to the Admin portal and check… If you think you can find it in the portal Overview or settings … It’s a very simple thing, indeed. So why it’s so not easy to find this information?! As you probably know we are getting Web API available for the portals which enables lots of new possibilities and options for developers and… Continue...
What is Delegation in Canvas Apps?
In order to minimize the data movement over the network, Power Apps uses the concept of delegation in canvas apps to delegate the job of data processing to data source rather than bringing the data to the app and processing locally. If your data source has less than 500 records, you can use any data … Continue reading “What is Delegation in Canvas Apps?” The post What is Delegation in Canvas… Continue Reading...