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
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
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
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
Pass “reference” data from a parent Flow to a child Flow
May18

Pass “reference” data from a parent Flow to a child Flow

If you ever wonder how to do this is the exact time to figure it out together. These are types of user inputs you can pass to a child flow: Child Flow user input types: Text, Yes/No, File, Number, Date. What I was doing previously is passing a record ID as a Text input parameter then I was querying data using this ID. Like this: Query record in a child Flow to workaround a pass… Continue Reading Olena Grischenko’s Article...

Read More
PowerLabs – Bulls and Cows – 5. Generate a secret Code with Power Automate, – YouTube
May16

PowerLabs – Bulls and Cows – 5. Generate a secret Code with Power Automate, – YouTube

We need to generate a 4-digit code for the game. With a twist. All digits in the code have to be unique. Let’s do it with Power Automate! Learning: variables, do-until loop, length(…), rand(…), contains(…) functions. source

Read More
Populating Word template with the CDS image field content via Flow (Power Automate)
May12

Populating Word template with the CDS image field content via Flow (Power Automate)

This is a great video which helped me on a way: https://www.youtube.com/watch?v=-1jsBllmr-w However, in this video it takes image from OneDrive but I want to populate it from CDS image field. Add image control to a Word template. Watch video I referred above showing how to add controls step by step then come back for the image adding part. Image control inside Word template. 2…. Continue Reading Olena Grischenko’s Article...

Read More
CDS current environment connector: Filtering attributes for the record created
May11

CDS current environment connector: Filtering attributes for the record created

Let’s say I want trigger some logic when the particular field has been modified on a record. In this example, I modify a contact Email field and create a Note when it’s been modified. I picked up a trigger for Create or Update because you can enter Email for a new record or you can just update. It’s obvious if you’ve ever created any plug-in in your previous life that Filtering… Continue Reading Olena...

Read More
PowerLabs – Bulls and Cows – 4. Post Adaptive Card to Microsoft Teams – YouTube
May09

PowerLabs – Bulls and Cows – 4. Post Adaptive Card to Microsoft Teams – YouTube

Learn with us how to create a new Microsoft Teams channel then build Power Automate to create Adaptive Card and post it to a Microsoft Teams channel. Capture user information with the card then send back a response with the details captured. source

Read More
Braintree payments PCF component (Power Apps)
May01

Braintree payments PCF component (Power Apps)

(The below has been described and tested for Canvas Power Apps. This has not yet been tested and adapted for Model-driven apps. As for the Power App Portal app, another integration pattern is appropriate, to be discussed later) This package for import in your CDS environment and source code of the control are packaged here: https://github.com/andrew-grischenko/BraintreePaymentsPCF This is a… Continue Reading Olena...

Read More
Setting up Office 365 E3 trial (video)
May01

Setting up Office 365 E3 trial (video)

I started my YouTube channel last week. This particular video I am going to leave here. If you want to explore new features, test how things work or just do training setting up your playground environment would be a very good idea. If you don’t know where to start, watch this video: Continue Reading Olena Grischenko’s Article on their blog Setting up Office 365 E3 trial (video) I started my YouTube channel last week. This...

Read More
PowerLabs  – Bulls and Cows – 3 Set up Office 365 E3 Trial – YouTube
May01

PowerLabs – Bulls and Cows – 3 Set up Office 365 E3 Trial – YouTube

This video to help you to set up your Office 365 E3 trial for the learning and training purposes. Also, it show how to integrate Microsoft Flow with Power Automate. source

Read More
PowerLabs – Bulls and Cows – 2 – YouTube
Apr28

PowerLabs – Bulls and Cows – 2 – YouTube

This is the second video of the “Bulls and Cows” series. In the video you will watch a teaser for the complete game and how it runs withing Microsoft Teams. source

Read More
Renaming Child Flow: the magic didn’t happen
Apr28

Renaming Child Flow: the magic didn’t happen

Oops, I did it again! I renamed my child Flow action from “Run Child Flow” into “Generate Code”. I was counting on the intelligence of the engine to figure things out for me. Wouldn’t it expect me to re-add all my references to the Flow? Or would it? I was pleasantly surprised seeing the “Generate_Code” reference instead of “Run_Child_Flow” but it was too soon. After the first run...

Read More
PowerLabs – Bulls and Cows – Intro – YouTube
Apr27

PowerLabs – Bulls and Cows – Intro – YouTube

This the first video in the series of PowerLabs “Bulls and Cows” game tutorials. Building is the best way to learn. Watch the whole series to learn more about Microsoft Teams, Adaptive Cards and Power Automate. source

Read More
Locking Out setting for Power Apps Portal for confused developers
Apr24

Locking Out setting for Power Apps Portal for confused developers

It came back to me from PROD saying it didn’t pass some last minute tests. After 5 attempts to login to the system user account was locked as it was expected but remained locked for much longer which was an unpleasant surprise to me. I remember setting login attempts to 1000 on the request from business on UAT and accidentally moving it to PROD like this. Our portal isn’t live yet so I… Continue Reading Olena...

Read More
“Stripe” payments PCF component (Power Apps)
Mar31

“Stripe” payments PCF component (Power Apps)

There is an article my partner published on our company website. We’ve spent some time working with custom connectors and experimenting with different types of integrations with Dynamics 365, CDS and Power Platform. If you are interested to learn more about PCF controls and how to combine all above together in a working solution it will be a good reading for you. (The below has been… Continue Reading Olena...

Read More