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
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
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
Brisbane Power Apps & Power Automate UG – Generating a starship inspection list with Power Platform – YouTube
Sep11

Brisbane Power Apps & Power Automate UG – Generating a starship inspection list with Power Platform – YouTube

Generating a starship inspection list with Power Platform Thursday, Sep 10, 2020, 5:15 PM Online event , 34 PowerAddicts Went IMPORTANT – THIS IS AN ONLINE ONLY EVENT Please do not show up at Hudson’s office for this event. There will be no access. We will stream the presentation using Microsoft Teams Meeting. For the best experience, you will want to install MS Teams desktop (Windows and Mac) app or a mobile (Android and iOS)...

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
Choosing who to get embed with  PCF control or Canvas app – YouTube
Aug27

Choosing who to get embed with PCF control or Canvas app – YouTube

Join Tae and Lachlan as they discuss the pros and cons, strengths and weaknesses of the current Power Apps UI extensions: PCF controls and embedded Canvas apps. In this session, we will explore which UI extensions to use when and why. Do PCF controls compete for the same space as Canvas Apps and vice versa? What do they do well? What do they do badly? We will cover these points and much more in this exciting presentation!...

Read More
PowerLabs-NoTimeToSPy – YouTube
Aug22

PowerLabs-NoTimeToSPy – YouTube

Learn how to build a Power Apps game. Use the script and images from GitHub project: alena-grischenko/spy_powerapps_game Contribute to alena-grischenko/spy_powerapps_game development by creating an account on GitHub....

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
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
2 Code or 2 No-code – that is the question – YouTube
Jul31

2 Code or 2 No-code – that is the question – YouTube

Whether ‘tis nobler to suffer the slings and arrows of outrageous configuration Or to take arms against a sea of exceptions, and, by coding, end them. Join Olena Grischenko and Leon Tribe as they address the eternal dilemma of when to configure and when to code. Coming from both ends of the coding spectrum, Leon will talk about when he has abandoned configuration and resorted to code, and Olena will talk about when configuration was a...

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
Microsoft 365 Pro Low No Code Developers Meetup  Quokka vs Spider  Epic battle – YouTube
Jul29

Microsoft 365 Pro Low No Code Developers Meetup Quokka vs Spider Epic battle – YouTube

Australia is filled with many weird and wonderful creatures, so how do you know if what you’re looking at is something cute, like a Quokka, or something more dangerous, like a redback spider 😱. Join us for the battle of the bots, comparing code and no-code bot options interacting with the Custom Vision APIs to help detect whether you’re dealing with one of Australia’s loveable creatures or something more sinister....

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
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
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
PowerLabs – AI Dog – Face API – YouTube
Jul12

PowerLabs – AI Dog – Face API – YouTube

Learn how to set up Azure Cognitive Services – Face API for your Azure subscription. Learn about a test API console and discover something new about Thanos. source

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
PowerLabs – AI Dog – Demo – YouTube
Jun20

PowerLabs – AI Dog – Demo – YouTube

Demo of the AI Dog emotion recognition app with the app set up, Power Automate set up and links to GitHub to explore code: https://github.com/alena-grischenko/ai_dog_emotions source

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
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
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
PowerLabs – AI Dog – Intro – YouTube
May31

PowerLabs – AI Dog – Intro – YouTube

Build a Power App with AI dog recognising your emotions and reacting accordingly with Power Automate and Azure Cognitive Services Face API. source

Read More
CDS current connector: Filter expression. My Flow doesn’t trigger!”
May29

CDS current connector: Filter expression. My Flow doesn’t trigger!”

I thought you will love this one. It’s that type of “Help! My Flow hasn’t get triggered” thing which we all love. How to reproduce For the CDS entity which has some existing records then a new optionset field has got created. As a result some records may not have this field populated. If you use Filter expression “[your_attribute] ne [some_value]” it won’t trigger for records where…...

Read More
PowerLabs – Bulls and Cows 6. The result Flow – YouTube
May24

PowerLabs – Bulls and Cows 6. The result Flow – YouTube

The last video of the series. The result Flow overview and GitHub source code for you to check. source

Read More
CDS current environment connector : “The following filtering attributes are not valid:…”
May20

CDS current environment connector : “The following filtering attributes are not valid:…”

Life is pain… “The following filtering attributes are not valid:…” {  “error”: {    “code”: “0x80040203”,    “message”: “The following filtering attributes are not valid:  lastname”  }} Fix the trigger …error Remove the white space between the comma and the next attribute! A white space between filtering attributes causing the error. No white...

Read More