❤Dataflow❤ with Power Apps: bulk update for CDS records
Nov12

❤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...

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
Dataflow for Power Apps: query CDS (improved)
Oct26

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:

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
Import solution to CDS. Missing Connection references error…
Oct12

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...

Read More
❤ Dataflow for Power Apps: query CDS via Web API❤
Oct06

❤ 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 ❤...

Read More
Connection references : Power Automate
Sep16

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...

Read More
Field Service Installation: are we there yet?
Sep15

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...

Read More
Field Service upgrade: where is my button?! 🤔
Sep14

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...

Read More
Power Apps Portal: deactivating records from a portal via Web API
Sep13

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...

Read More
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…
Sep13

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....

Read More
Dynamics 365 CE: Investigating the conflicting business rules issue
Sep08

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...

Read More
Power Apps portals: my Edit button doesn’t show on a grid (Déjà vu)
Sep08

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...

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
Making Canvas App responsive- Part 2
Sep05

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...

Read More
Xrm.WebApi. “The query parameter $select is not supported” error.
Aug21

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...

Read More
Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?
Aug17

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...

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
Power Automate: Group/Ungroup in Advanced Condition
Aug15

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...

Read More
Making Canvas Apps responsive – Part 1
Aug09

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...

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
Work on multiple sessions at a time using Customer Service Workspace
Aug07

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...

Read More
D365 FO/LOGIC APPS: REST SERVICE FOR ACCEPTING JSON & INSERTING RECORDS INTO A TABLE
Jul30

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...

Read More
Power Apps Portal: deactivate account, no workflow please, thank you
Jul30

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…...

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
Power Automate: watch your (white)space!
Jul28

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...

Read More
Monitoring Model Driven App
Jul21

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...

Read More
Power Apps Portals: where do I find my portal current version?!
Jul21

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...

Read More
What is Delegation in Canvas Apps?
Jul19

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...

Read More
Dynamics 365 CE/model-driven app: the form script unexpected discovery
Jul17

Dynamics 365 CE/model-driven app: the form script unexpected discovery

Something I won’t expect to discover. Yet, here I am! It’s all started with a very “simple” requirement to populate a read-only form field on change of another form field, Method. The fancy way it set up is when you select the field to change it pops up the window asking you if it was a client decision or not to change the field. If you answer Yes it sets the MethodSetBy field to a “Client”…...

Read More
Column comparison using FetchXml/Web API is now possible in Common Data Service
Jul16

Column comparison using FetchXml/Web API is now possible in Common Data Service

Recently , Microsoft added column comparison feature to common data service. It allows us to compare two different columns from the same entity using FetchXml , Web API and SDK API in . Using FetchXml: At the time of writing this blog, this feature is not available yet in advanced find. So tried using “FetchXml … Continue reading “Column comparison using FetchXml/Web API is now possible in… Continue Reading...

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
Control who can create environments in the Power Platform admin center
Jul15

Control who can create environments in the Power Platform admin center

Before going to who can create environment part , let’s understand what is an environment ? An environment is a space to store, manage, and share your organization’s business data, apps, and flows. It also serves as a container to separate apps that may have different roles, security requirements, or target audiences. Power Apps automatically … Continue reading “Control who can create… Continue Reading...

Read More
2020 release wave 2 timeline and release notes for Dynamics 365 and Power Platform
Jul15

2020 release wave 2 timeline and release notes for Dynamics 365 and Power Platform

Recently , Microsoft announced the key dates for the second release wave of updates planned for 2020 Starting October 2020. Customers and partners can reference these dates to plan and prepare for the upcoming release wave with confidence. Key Dates : July 8, 2020: Release plans available https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/… Continue Reading Nagaraja Emmadisetty’s Article on their blog 2020...

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
Power Automate: PARSE JSON action with value or null
Jul06

Power Automate: PARSE JSON action with value or null

Power automate is endless fun! Today we are going to explore a very “simple” issue which are 2 issues actually: how to define “allow null” in a schema to avoid annoying errorshow to get away with the 1. without the painful consequences Let’s start from the beginning! PARSE JSON is a very useful action and we use it a lot in Power Automate.In my case I parse the response from a… Continue Reading...

Read More
Power Apps Portal Maintenance: The curious incident of the naughty user.
Jun28

Power Apps Portal Maintenance: The curious incident of the naughty user.

In the last article here I proposed the design for the custom Maintenance functionality: Power Apps Portal: Summon the Custom Error Page to test a custom layout There is an article in Microsoft docs on how to set up the Custom Error page for the Power Apps portal. You can read about enabling here: https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/view-portal-error-log#enable-custom-error And about setting up your custom...

Read More
Power Apps Portal: Summon the Custom Error Page to test a custom layout
Jun20

Power Apps Portal: Summon the Custom Error Page to test a custom layout

There is an article in Microsoft docs on how to set up the Custom Error page for the Power Apps portal. You can read about enabling here: Viewing portal error logs and storing them in Azure Blob storage – Power Apps As a portal administrator or developer, you can use Power Apps portals to create a website for your customers. One common task for a developer is to debug issues while developing the portal. To help debug, you can...

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
Power Automate for CDS: “what was it before we run the update?” or “bye,bye, no-code!”
Jun18

Power Automate for CDS: “what was it before we run the update?” or “bye,bye, no-code!”

The requirement: for Account(Property in our case) if related Contact(Tenant) is “un-linked”, create a Note. No-code solution: none. Why? These are triggers available for CDS(current environment): CDS current environment triggers We choose Update trigger for Contact filtering by parentcustomerid … and this is it. This is where our no-code journey ends. When Update… Continue Reading Olena Grischenko’s...

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
Power Portal: a custom maintenance page
Jun15

Power Portal: a custom maintenance page

Well, there is one: https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/enable-maintenance-mode If OOB one works for you don’t bother reading any further. Didn’t work for us because we wanted some flexibility for the dev team and testers to be able to login, check, clear cache etc So the requirement was to display a maintenance page to portal users and make the whole portal look… Continue Reading Olena...

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
Sync Master Data on Dynamics NAV / Dynamics 365 BC
Jun05

Sync Master Data on Dynamics NAV / Dynamics 365 BC

As a Business Consultant, you might have received a business requirement to sync Master Data between different fiscal companies. It is common when we are implementing an ERP on a Group of companies. If the ERP to implement is Dynamics NAV / Dynamics 365 BC it is frequent as a first approach, to follow one of the three options: • Create a customization to enable this automation (Extension on D 365 BC) • Adopt an ISV solution that...

Read More
Copy & Apply Site Template to a SharePoint site using Power Automate
Jun02

Copy & Apply Site Template to a SharePoint site using Power Automate

If you have a requirement to copy a site template (Site Pages including images & webpart, site column, site content type, navigation etc) from an existing SharePoint site & apply it to a recently created SharePoint site, this blog post would be helpful. Pre-requisites: SharePoint site collection administratorSharePoint site with a custom list associated to a FlowAccess to Premium… Continue Reading ashiqf’s Article...

Read More

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.