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

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 Pages Copilot – YouTube
Aug07

Power Pages Copilot – YouTube

Overview of AI-powered and Copilot features in Power Pages (preview) Learn how design Power Pages sites using AI-powered and Copilot features. Explore new UI features for co-pilot with Power Pages....

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
5 reasons to love Power Pages – Sydney Microsoft BizApps Women  November 2022 – YouTube
Nov27

5 reasons to love Power Pages – Sydney Microsoft BizApps Women November 2022 – YouTube

Answering Why Power Pages? Why new and Why care? questions, talking about a new licensing model with a hint of demo 😉 source

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
BizApps Women August event  Meeting Recording – Re-start Your Career w Power Platform – YouTube
Sep23
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
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
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
Power App Portal Web API – fighting lookups
Aug08

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

Read More
Dataflows for Power Apps: run import from the app
Aug06

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

Read More
Save Dataverse Notes to Azure Blob Storage and Display on PowerApps Portals
Aug05

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

Read More
Simple Azure Invoice OCR Tutorial
Aug05

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

Read More
Azure Storage integration for Power Apps portals
Jul20

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

Read More
Power Automate with Dataverse: Saving API calls to Dataverse. Expand or Link-Entity?
Jul02

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

Read More
Power Automate with Dataverse: “Apply to each” current item/previous item
Jul01

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

Read More
How do I pass executionContext as a parameter into my Promise to fit in Promise.all()?
May26

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

Read More
Where is my Tenant ID? (not Azure portal)
May09

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

Read More
COATBRIDGE   Olena and Andrew Grischenko   Go Beyond Limits with Power Platform – YouTube
Mar03

COATBRIDGE Olena and Andrew Grischenko Go Beyond Limits with Power Platform – YouTube

Applying new technology into practical context comes with challenges of facing varying limitations – licensing, performance, security to name a few. In this talk, we will give you several examples of these problems and how to solve it using hybrid code/no-code solutions on Power Platform and Azure. You’ll know how to speed up your flow processing in certain use cases to the orders of magnitude; how to work with...

Read More
Dynamics 365 Sales Pro Trial Setup
Feb08

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

Read More
Getting data from a function in an on-prem SQL server via Gateway in Power Automate
Feb02

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

Read More
Dataflows for Power Apps: calling a table-valued  SQL function with Power Query
Feb02

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

Read More
❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables
Jan31

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

Read More
Azure Functions in Power Platform multiple environments
Jan06

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

Read More
Dataflows for Power Apps: transform fixed-width text files
Jan04

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

Read More
Dataflows for Power Apps: cyclic reference error with multiple data sources when you start with empty query
Dec06

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

Read More
Dataflow for Power Apps: “section Section1;…” error on create
Dec04

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:

Read More
❤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
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
The Journey of Low Code to Pro Code Developer and the other way round – YouTube
Oct22

The Journey of Low Code to Pro Code Developer and the other way round – YouTube

Salman is working as a functional consultant but his heart is more towards the Dev side. He always tries to present design documents and concepts that are more developer-friendly which are easier to understand and build. Linn started his career as a developer and he is passionate about coding. But lately, he has been embracing low-code development platforms so that he can spend more time on the things that matter. Join us to listen to...

Read More