Text-to-Speech and Audio Playback in Power Apps using Azure and Power Automate
Feb29

Text-to-Speech and Audio Playback in Power Apps using Azure and Power Automate

Capabilities like text-to-speech (TTS) and audio playback can take your applications to new heights of user engagement and accessibility. In this blog post, we’ll look at integrating text-to-speech and audio playback functionalities into Power Apps using Power Automate and Azure Speech Services. Whether you’re looking to provide dynamic narration, streamline communication, or enhance… Continue Reading Mohamed Ashiq...

Read More
Will It Break? Non-business Dataverse connector + AI Builder with a DLP policy for the Default environment
Feb09

Will It Break? Non-business Dataverse connector + AI Builder with a DLP policy for the Default environment

The case As a Power Platform admin I want to remediate the Default environment to deploy a DLP policy so I could get to the Power Platform maturity level 200 for the Admin and Governance. Olena We notified users with non-compliant assets to back up or move their apps and automation, as they are going to break during the remediation. Some of the users got back to me, and we had some… Continue Reading Olena Grischenko...

Read More
Automate the assignment of Capacity Add-ons in Power Platform Environment using Power Automate Flow
Jan31

Automate the assignment of Capacity Add-ons in Power Platform Environment using Power Automate Flow

In Power Platform, capacity add-ons such as AI Builder Credits, Per-App plan, Power Pages Capacity, Power Automate Per Flow, Power Automate Process, Copilot Studio messages are allocated at an environment level and are not tied to individual users, unlike the Power Apps/Power Automate Premium plan. These add-ons are assigned to an environment through the Power Platform Admin Center. However,… Continue Reading Mohamed Ashiq...

Read More
Power Automate: contains(), array, AI and bananas.
Jan25

Power Automate: contains(), array, AI and bananas.

Issue I was modifying my custom environment creation automation today. For the security group creation action, I needed to add a System Admin to the security group owners to simplify a user management. The action takes the array like below: [ … Continue Reading Olena Grischenko (she/her)’s Article on their blog Power Automate: contains(), array, AI and bananas. Issue I was modifying my custom environment creation...

Read More
How to improve Stripe payments in Power Pages (CloudMinded)
Jan09

How to improve Stripe payments in Power Pages (CloudMinded)

How to improve Stripe payments in Power Pages Continue Reading Olena Grischenko (she/her)’s Article on their blog How to improve Stripe payments in Power Pages (CloudMinded) Visit the post for more. Blog Syndicated with Olena Grischenko (she/her)’s...

Read More
For Dummies: creating an internal Microsoft Power Platform hub (from the template)
Jan04

For Dummies: creating an internal Microsoft Power Platform hub (from the template)

In my world being an expert in something and being a dummy in something else is pretty normal. No one knows everything. I am an expert in the Power Platform and Business Applications, but even that area is too big for me, so I continue learning every day. When I tried to deploy the Power Platform communication site template for my organisation, I encountered multiple issues. They look like… Continue Reading Olena Grischenko...

Read More
Streamlining Integration: Using Azure Managed identities in Power Apps and Power Automate to access Microsoft Graph API – Part 3
Jan02

Streamlining Integration: Using Azure Managed identities in Power Apps and Power Automate to access Microsoft Graph API – Part 3

In both Part 1  and Part 2 of the blog series, I’ve covered the utilization of Managed Identities in Power Apps and Power Automate for secure access to Microsoft Graph API. This included a deep dive into setting up and configuring the Azure API Management service with the Microsoft Graph permissions for the managed identity. In Part 2, I’ve explored the process of exporting the API as a… Continue Reading Mohamed Ashiq...

Read More
Streamlining Integration: Using Azure Managed identities in Power Apps and Power Automate to access Microsoft Graph API – Part 2
Jan01

Streamlining Integration: Using Azure Managed identities in Power Apps and Power Automate to access Microsoft Graph API – Part 2

In Part 1 of the blog series on using Managed identities in Power Apps and Power Automate to access Microsoft Graph API securely, I have delved into the setup and configuration of the Azure API management service with the necessary Microsoft Graph permissions for the managed identity. Building upon that foundation, Part 2 aims to take it further your integration journey in making the API’s… Continue Reading Mohamed Ashiq...

Read More
Streamlining Integration: Using Azure Managed identities in Power Apps and Power Automate to access Microsoft Graph API – Part 1
Dec31

Streamlining Integration: Using Azure Managed identities in Power Apps and Power Automate to access Microsoft Graph API – Part 1

Using Microsoft Graph in Power Apps and Power Automate offers several advantages for streamlining integration with various Microsoft 365 services and applications. Additionally, securing these integrations with Azure Managed Identities significantly enhances the overall security of the solution. Azure Managed Identities enable applications and services to authenticate with Azure services… Continue Reading Mohamed Ashiq...

Read More
Santa’s “Ho Ho Ho” message to welcome  good 😀 Makers (Managed Environments)
Dec18

Santa’s “Ho Ho Ho” message to welcome good 😀 Makers (Managed Environments)

Extending a warm welcome to the Makers starting on the environment is a wonderful idea, especially as Christmas is approaching. We won’t miss the opportunity to send them some heartfelt greetings. It’s very easy to do for Managed Environments. If you are not familiar with the concept, this is the idea: Managed Environments is a suite of premium capabilities that allows admins to manage… Continue Reading Olena...

Read More
CoE Starter Kit: Efficient Testing Strategy for Inactivity Processes – Admin Simulations for Maker Clean-Up Approvals
Dec11

CoE Starter Kit: Efficient Testing Strategy for Inactivity Processes – Admin Simulations for Maker Clean-Up Approvals

As a Power Platform Admin, I would like to efficiently test the CoE Starter Kit Inactivity Processes, so I understand how it works and confirm it meets my requirements without spamming users and makers. Olena Introduction During our initial setup of the CoE Starter Kit, we encountered difficulties in finding a way to disable notifications and automatic emails. Despite configuring some… Continue Reading Olena Grischenko...

Read More
Power Pages payments with Stripe (ft. CloudMinded)
Dec06

Power Pages payments with Stripe (ft. CloudMinded)

Anatomy of the Stripe payments in Power Pages Continue Reading Olena Grischenko (she/her)’s Article on their blog Power Pages payments with Stripe (ft. CloudMinded) Visit the post for more. Blog Syndicated with Olena Grischenko (she/her)’s...

Read More
Modify Microsoft Entra ID Connector (Standard) to meet your security requirements
Nov21

Modify Microsoft Entra ID Connector (Standard) to meet your security requirements

Some time ago I wrote the post: https://wordpress.com/post/msolenacrm.blog/4767 In the post, I was talking about the standard Microsoft connector not meeting my client’s security requirements. Pretty much, I was blocked and searching for a solution. The only “security appropriate” solution was a custom connector but I didn’t know where to start. I asked my partner to investigate the… Continue Reading...

Read More
Streamlining Integration: Leveraging Service Principal Authentication for SQL Connector in Power Apps and Power Automate
Nov05

Streamlining Integration: Leveraging Service Principal Authentication for SQL Connector in Power Apps and Power Automate

In the ever-evolving landscape of business processes and data management, efficient integration is the key to success. Securing and managing connections in Power Apps and Power Automate is a critical aspect of integration. This blog post delves into how to use Service Principal authentication to create a connection for Azure SQL Server database with the SQL Server connector in Power Apps and… Continue Reading Mohamed Ashiq...

Read More
Streamlining Integration: Using Service Principal authentication on Custom connectors with Microsoft Graph Application Permissions
Oct28

Streamlining Integration: Using Service Principal authentication on Custom connectors with Microsoft Graph Application Permissions

Microsoft recently announced a long awaited feature: support for Service Principals in Custom connectors which is currently in Public Preview. This empowers you to authenticate as a service principal instead of relying on user accounts. It’s a game-changer that paves the way for a multitude of scenarios, especially those requiring seamless, uninterrupted access for automated processes, free… Continue Reading Mohamed Ashiq...

Read More

As a System Administrator, I would like to create a DLP policy for my environment(s) so I can help protect data in my organization

If you are a Power Platform admin, you can find the relevant information in the following Microsoft article: https://learn.microsoft.com/en-us/power-platform/admin/create-dlp-policy Unfortunately, it’s not clear from the article how to create a DLP policy as a System Administrator managing just one or multiple environments and not having a Power Platform admin role and superpowers. This… Continue Reading Olena Grischenko...

Read More
Microsoft Entra ID connector – least privilege
Oct05

Microsoft Entra ID connector – least privilege

The solution described in the article is not fully working to the level it satisfies the author. It’s a continuous effort to come up with the best solution that meets both dev and ops requirements. Me The problem I am trying to create a security group using Power Automate using the Microsoft Entra ID connector. Microsoft Entra ID – Connectors Microsoft Entra ID is an Identity and Access Management cloud solution that...

Read More
Cancelling Dataverse via DLP policy on the Default environment
Oct03

Cancelling Dataverse via DLP policy on the Default environment

Let’s chat about how we got there first. In my client’s organisation the decision was made to limit Power Platform usage to just Office 365 connectors due to the complexity of the service ownership, time-consuming licensing discussions – it’s complicated! So Power Platform is only allowed as a part of the Office 365 subscription, all users in the organisation are covered by their Office… Continue Reading...

Read More
Canvas App: Office365Users.Search UserV2 not working, but V1 does
Aug10

Canvas App: Office365Users.Search UserV2 not working, but V1 does

Scenario: Currently, I am working on the New Environment Request app. As a part of the solution, we add the environment business Owner which as we know is different from the Owner field populated by default with the name of the user who physically spins the environment. Therefore, on the form, we allow a user to pick an Owner from the list of users. Solution: We will use Office… Continue Reading Olena Grischenko...

Read More
Co-pilot with Power Pages: new features to generate UI
Aug07

Co-pilot with Power Pages: new features to generate UI

Co-pilot with Power Pages Learn to generate Power Pages page ideas with the pre-defined layout, described color scheme, and purpose. Continue Reading Olena Grischenko (she/her)’s Article on their blog Co-pilot with Power Pages: new features to generate UI https://youtu.be/M7HbJ8QNAcU Co-pilot with Power Pages Learn to generate Power Pages page ideas with the pre-defined layout, described color scheme, and purpose. Blog...

Read More
Power Automate: Send approval email to external customer
Jul19

Power Automate: Send approval email to external customer

To remind myself for the future discussions. Thank you very much, Mira! MG #Power automate #Approvals #External Guests Approvals in power automate are very nice interactive feature to process requests and documents! They can be integrated with CDS, SharePoint online and Onedrive. Here is a link to creation of Approvals walk-though when an item is created in a sharepoint… Continue Reading Olena Grischenko (she/her)’s...

Read More
Power Platform DLP Policy: blocking HTTP connectors won’t impact child Flows
Jul18

Power Platform DLP Policy: blocking HTTP connectors won’t impact child Flows

Previously known issue Call Child Flows – Power Automate Flows can now call other flows and pass parameters to them. “If you block the HTTP Request connector via data loss prevention (DLP), child flows are also blocked because child flows are implemented using the HTTP connector. Work is underway to separate DLP enforcement for child flows so that they are treated like other cloud flows.” <h2… Continue Reading Olena...

Read More
Power Platform environment. Definition of inactivity.
Apr09

Power Platform environment. Definition of inactivity.

Our Power Platform Admin team recently discussed the possibility of the automatic cleanup of inactive environments. For the Sandbox and Production environments, we tried to come up with a definition of what we believe is an “inactive environment”. The definition we could think of would combine two main components: a user activity in the environment, at minimum, login, and/or automation… Continue Reading Olena...

Read More
“Do DLP policies apply to Developer environments?”
Apr06

“Do DLP policies apply to Developer environments?”

< blockquote class=”wp-block-quote”> The simplest way to get access to a Power Platform environment is to sign up for the Power Apps Developer plan. You can explore Power Platform at full potential for learning at no cost. To fully use it as a developer, you’ll need an Azure account and a work account. This article will guide you through the process for creating a Power Platform environment and a test...

Read More
Set up ALM accelerator for Microsoft Power Platform. Power Platform Admin requirements considerations.
Apr01

Set up ALM accelerator for Microsoft Power Platform. Power Platform Admin requirements considerations.

The issue My client’s ops team got a request from developers to support the ALM accelerator setup and configuration.They follow the steps from the article below:https://learn.microsoft.com/en-us/power-platform/guidance/coe/setup-almacceleratorpowerplatform-preview#give-power-app-management-permission-to-your-app App registration is a part of the setup. The Power App Management… Continue Reading Olena Grischenko (she/her)’s...

Read More
Convert Speech to Text using OpenAI Whisper in Power Apps
Mar19

Convert Speech to Text using OpenAI Whisper in Power Apps

OpenAI has released a new neural network called Whisper, which is an open-source model that can convert speech to text with impressive accuracy. This model is specifically designed to transcribe spoken language into text with high precision and speed, making it an ideal tool for a variety of applications, such as virtual assistants and video captioning. Whisper relies on advanced machine… Continue Reading Mohamed Ashiq...

Read More
How to copy an existing DLP Policy in Power Platform
Mar19

How to copy an existing DLP Policy in Power Platform

DLP policies are essential in ensuring that data is managed uniformly across an organization, thereby preventing critical business data from being accidentally published to social media or other connectors. These policies can be created at both the tenant and environment levels, with management handled through the Power Platform admin center. However, it is currently not possible to copy an… Continue Reading Mohamed Ashiq...

Read More
Uploading Files Made Easy: A Guide to Using the Attachment Control in Power Apps
Mar19

Uploading Files Made Easy: A Guide to Using the Attachment Control in Power Apps

The Attachment control in Power Apps is a useful feature that allows users to upload and delete files, but it can only be used with data sources such as SharePoint List or Dataverse table. However, if you need to upload and delete files without using these data sources, you can create a custom component using the Attachment control or you can directly use this control in the app. I have… Continue Reading Mohamed Ashiq...

Read More

Changing Connections in Connection References on a Managed Solution

A connection reference is a component in a solution that holds information about a connector. It can be used by both a Canvas app and Power Automate flows. When importing a managed solution to an environment, the user is asked to either select an existing connection or create a new one. However, once a managed solution is imported, it cannot be edited as shown below The solution to this… Continue Reading Mohamed Ashiq...

Read More
How to send an Adaptive card to a Microsoft Teams Private channel using Power Automate flow
Dec31

How to send an Adaptive card to a Microsoft Teams Private channel using Power Automate flow

Within Microsoft Teams, private channels create focused spaces for collaboration where only the owners or members of the private channel can access the channel. The Microsoft Teams connector in Power Automate has an action to Post an Adaptive card in a chat or channel, which posts an adaptive card as a flow bot to a specific Teams channel. The following error will appear if this action is used… Continue Reading Mohamed Ashiq...

Read More
Generating simple and complex documents with just Power Platform, no add-ons.
Nov20

Generating simple and complex documents with just Power Platform, no add-ons.

In the consulting world, we get the document generation requirements for most medium to large-size projects. Traditionally, for Dynamics 365 projects we used document generation add-ons, like Document Core Pack or Xpertdoc to generate documents. However, it’s unnecessary in the world of Power Platform where all requirements could be addressed with just Power Platform.

Read More
Power Automate w Word Online: generate document updates
Sep28

Power Automate w Word Online: generate document updates

Scenario: My client generate a summary document for the application lodged online. The generated summary could be manually edited by an officer. At the final stage of the application processing, it’s required to include additional information to the generated summary document regarding the outcome of the application. This information must be dynamically generated. This is a process… Continue Reading Olena Grischenko...

Read More
5 reasons why (you believe) you can’t be Microsoft MVP and why you should rethink it
Jul06

5 reasons why (you believe) you can’t be Microsoft MVP and why you should rethink it

Today is “that day of the year”, the MVP renewal day. You could see lots of posts on Twitter and LinkedIn about the event. MVPs are posting about being renewed for another year. It means more community work, opportunities, more tech knowledge shared, and more questions answered. It means more fun! I’ve been a part of the Microsoft MVP Award program for some time. People reach out to ask me… Continue Reading...

Read More
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
Top 5 features of Power Pages from  Power Apps Portal UI/UX pro
May25

Top 5 features of Power Pages from Power Apps Portal UI/UX pro

I am very excited to share my initial thoughts about Power Pages and a new portal designer. It was a big announcement at MS Build today, if you missed it you can read the article here and then set up a trial to start playing with Power Pages. I’ve been working as a Dynamics 365 portal and Power Apps portal for many years. Recently, I made UI/UX for Power Apps portals one of my business… Continue Reading Olena Grischenko...

Read More
Where’s my old app designer?!
May20

Where’s my old app designer?!

Changes to UI are always fun. From the user experience perspective, they are challenging and somehow scary. I love a new app designer! It’s easy to use, it’s smart, and very user-friendly. However, today I need a new designer to make sure I’ve got all forms required added to my app. In the old designer you can check it. And in a new one – I’m not sure it’s even possible. In my old… Continue...

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
Power Apps Portal: “Table permission changes for forms and lists on new portals” So what?
Sep06

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

Read More
Dataflows for PowerApps: loading data from CSV file without copying it to OneDrive in advance. ???
Aug17

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

Read More
Child Flow: the ‘runAfter’ condition is not satisfied.
Aug09

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

Read More