ChildFlowUnsupportedForInvokerConnections error while using Child Flows [SOLVED] | Power Automate

Often times, if you are using Child Flows and but you see some unexpected while Saving your parent Flows upon adding a Child Flow, which usually look like the below

Assuming, you are aware of using Child Flows and that they can only be created inside a Solution. (Of course, that’s why you could encounter this issue since you’re able to set a Child Flow already 😊)

Reason Issue

Let’s say this is your Child Flow as shown below in Power Automate. It uses a connection for Approvals. (It could be any other connection in your case.)

Now, open Run only users section as shown below

It’ll show that my Approvals connection is relying on Provided by run-only user in Power Automate. To learn more about Run only Users, refer this post – https://www.serverlessnotes.com/docs/sharing-flows-as-owners-and-run-only-users

Now, I switch to Use this connection (<Connector>)

It’ll ask for a confirmation as per below

Once this is set for all respective connections, you’ll have no issues in adding a Child Flow to your parent Flow and saving your parent Flow!

Here are some more Power Automate / Flow posts you might want to look at –

Hope this quick tip helps!

Excel Importing Notes (Annotation) entity in Dynamics 365 CRM

June 26, 2020June 26, 2020 priyeshwagh777 Dynamics 365 CE annotation entity import in dynamics 365, dynamics crm import, excel import, notes entity

Preparing an Excel Template for Notes entity is a little tricky. Doesn’t work when you just Export directly as a Template from the Templates Wizard and try to include all columns and import as is. Why? Because there’s no Regarding field exported when you export/import that template.

Here’s what you can do as a workaround.

Scenario

Now, let’s assume you want to Export a standard Excel Template for import so that you can re-import into Dynamics for Notes entity for a regarding entity.

Exporting Excel Template

Your Document Templates are where all your Excel Templates can be exported from –

Now, follow the below –

Select Notes entity and Edit Columns you need to Export the Excel with your required columns
Select the columns you need. Observe that you don’t get Regarding column to export
Then Download the file.

Modifying the Excel

Now, since you don’t have the Regarding field in the Excel you exported from Templates, here’s what you need to do –

Add a column yourself, give it a proper name based on what the Notes’ Parent entity should be. In this example, I’m importing Notes for Account. So, I’m adding a column called ‘Account Name’
A new column will be created as below
Now, populate your data based on how the Notes should be imported and tagged to which records.
Now, by default, this template is exported in Microsoft Excel Worksheet (xlsx) format. You’ll need to Save As in CSV format

Re-Importing

Up until above, your Excel is ready to be imported. Let’s begin –

Import the file as a usual Excel Import in Dynamics 365 CRM. Since this is not a direct Template importing as is, but a CSV, you’ll get to map this file manually.
Then, you’ll need to manually select the Note entity from the drop-down and then proceed
Now, whatever is mapped automatically will be mapped. For the newly created Account Name field, you’ll need to expand the Not Mapped dropdown and select Regarding (Lookup)
Now, you’ll need to select the entity you want the Notes to appear under. In my case, this is Accounts, so I have it right there
Since this Regarding fields supports several entities, scroll all the way down to Confirm your selection
Now, your Regarding field is set and you are ready to confirm and Import
Now, my Import here is completed. (You’ll need to take care the Import is successful)

Imported Notes

If you look at the records now, the Notes will be attached to the respective Regarding records

Here are some more posts on D365 CE you might want to look at –

Hope this helps!!

BPF Flow Step as a Trigger in CDS (Current Environment) connector | Power Automate

June 24, 2020 priyeshwagh777 Power Automate bpf stages, business process flow, cds connector, common data service, Power Automate

Here’s an update to the Common Data Service (Current Environment) connector in Power Automate

Remember, this is available only in Common Data Service (Current Environment) connector i.e. you’ll need to create you Flow inside a Solution in Power Automate

Flow Step

Now, you can call your Flow from a Business Process Flow, which existed for some time. But now, it’s available as a trigger in the Common Data Service (Current Environment)

Flow & BPF Setup

Now, my Flow is kept simple to illustrate what has been triggered. The first step simple is run When a flow step is executed.
It starts with a simple Instant Flow like template if you want to have an additional input

And then you can use these in the context further. But I’ll keep it simple assuming you are familiar with trigger inputs.
Then, you get the details that you can use from the trigger.
And I’m simply passing on the values over to an email so that I can read it. You application could be anything. Typically, it could be a complex business process in a Flow to trigger when a Flow Step is triggered.
Now, in my Business Process Flow Step, I’ve added a Flow Step (Preview), mind that this is still in Preview as of writing this post.
And select the Flow I’ve intended for this.

Running the Flow

Now, here’s how it goes –

I’ve called the Flow from the Flow Step
It’ll ask for confirmation of the Flow in a window
Once all the permissions are set, depending on what’s needed in the Flow, you’ll be asked for a confirmation
Once completed, you can check in Flow Runs about what happened to the execution of the Flow

Results

So here are some results I composed from the data of the BPF itself-

And that’s it!

Here are some more Power Automate / Flow posts you might want to look at:

Hope this helps!!

Pass selected rows’ GUIDs to ribbon button in D365 | Ribbon Workbench

June 21, 2020June 21, 2020 priyeshwagh777 Ribbon Workbench custom ribbon button, dynamics 365 javascript, dynamics crm ribbon button, Ribbon Workbench

Whenever your Ribbon button customization involves doing something to selected records, here’s the most common application that you need to take action on the selected record’s GUIDs.

Here’s how –

CRM Parameter

In Ribbon Workbench, let’s say you have a button command which is attached to a button and it calls a method ‘process’ which looks like this (it will be your method in your case)

In Commands, Custom JavaScript Action will have a CRM Parameter called as SelectedControlSelectedItemIds [pretty self explanatory 😊]

And it’ll pass data of the selected GUIDs in my data variable passed to the method.

Read the GUIDs

Here’s my sample code where I intend to read it from the function I used to call when user clicks on the ribbon button

Now, let’s say I select a few records on the Main Sub-grid where I’ve put my button on.
Now, on clicking it, it’ll pass the three selected records’ GUIDs to the method that the button is calling. You can read it from the data parameter
You can further read from this array and use it to perform your operations.

Hope this was easy. Here are some more Ribbon Customization related posts you might want to look at –

Thank you!!

Pause a Flow using Delay and Delay Until | Power Automate

June 17, 2020 priyeshwagh777 Power Automate delay, delay until, microsoft power automate, pause a flow

In some use cases, you want to pause a Flow either by a duration you specify or until the timestamp you specify.

Let’s look at both the ways – Delay and Delay Until in Schedule operation

Delay

In a simple application, you can make a Flow wait for a certain duration by using the Delay Action in Time

And I’m selecting a standard 3 min wait

And it will pause the execution until then

And resume the Flow after the Delay duration has been completed

Delay Until

Now, a variation to pausing a Flow until the timestamp you specify is achieved using Delay Until action the timestamp you specify
In my example, I’m using a Timestamp stored in a Time variable and the value is something like below

So, I can use the Delay until action and it accepts a TimeStamp. It accepts ISO8601 format.

And I’ll set a value, which contains my timestamp

In my case, based on the Timestamp stored in my variable, it’ll wait until the below shown time.

And will be completed when the timestamp is hit

And that’s it.

Here are some more posts that might help you –

Hope this helps!!

Generate Dynamics 365 record link in a Flow using CDS connector | Power Automate

June 13, 2020 priyeshwagh777 Power Automate common data service, Dynamics 365, Microsoft Flow, Power Automate

There are several ways to formulate a Dynamics 365 record URL and make it clickable in a Flow in Power Automate.

Here’s one of the ways I follow for most scenarios – Let’s say I want to open a PSA Time Entry record from my Flow, here’s how I do it

Get record action to retrieve URL

Since this post is focused on CDS connector, I can get the D365 record link in body of Get record action for Common Data Service connector.

Unfortunately, I didn’t see this if the trigger was a CDS action, so I made a separate Get record call.

But, we’ll retrieve the same without having to select/parse body object. So let’s see –

Generating Link

First, I’ve initialized a variable that’ll hold the String format of the end URL

Now, first – I’ve appended https://. This won’t come directly using the uriHost() method

Then, the uriHost() holds the formula ‘uriHost(body(‘Get_record’)?[‘@odata.id’])‘

Meaning, get the uriHost name i.e. Environment name itself.

Then, I’ve appended options for the window to open which are mentioned below in this post.

Finally, I’ve appended the Primary Key of the record itself at the end

Options

Now, let’s talk about the options –

cmdBar = [true | false]
It’ll show the ribbon on the record. If false is chosen, it’ll be hidden
navBar = [off | on]
It’ll show the Navigation Bar on top if on. If off, it’ll be hidden
newWindow=[true | false]
This didn’t affect in my case. It anyway opened in a new tab. This could be different is the link is not opened from Email but is used elsewhere
pagetype=entityrecord
Since we are targeting a Dynamics 365 entity record, the above is used.
etn= [name of the entity]
Name of the entity
id
GUID of the record itself.

Here’s an Email that I composed to show how the URL will end up looking –

Which will result in Email like this

And open the record like this.

As per my settings in the URL I created, I don’t have the Nav Bar or Command Bar visible. It’s up to you to decide your preference

Here are some more Power Automate / Flow content you might want to check –

Hope this helps!!

Text Functions in a Flow | Power Automate

June 9, 2020 priyeshwagh777 Power Automate Microsoft Flow, microsoft power automate, Power Automate, text functions

As I was looking at some String/Text operations in Flow recently, here’s what I discovered.

Looks like there are a lot more to come, so let’s look at some initial ones.

Find text position

A pretty simple feature to find the position the Search Text starts from in a String.

Here, I’m trying to find where does ‘yes’ in string ‘Priyesh’ starts from in the given text. And the answer was 3. [Text Index starting from 0]

If the text doesn’t exist, the result is -1

Substring

Here’s another important Text function called Substring.

This will return the substring with starting index of 3 and the length of the string from the starting character.

In this case, it’ll return the string “yes”

If your Starting Position in Substring is out of the range i.e. exceeding the length of the entire string, you’ll see and error like below stating the issue.
Also, the same error will be displayed if the Length of the Substring chosen falls out of range i.e. the index exceeding end of the string.

Here are some more Power Automate / Flow posts you might want to look at

Restore older version of a Canvas Power App | Power Platform

June 3, 2020 priyeshwagh777 Microsoft PowerApps canvas powerapps, publish canvas powerapp, restore canvas powerapp, restore old version

When you users report of an issue and you need some time to look into it but can’t hold the users, you just want to restore to a previous version for the time being.

Here’s how you can restore/revert to an older version of the Canvas App you’ve deployed.

Current Version

Let’s say my current version had a button called Profile under the label Accounts. But in the new version, I had moved it and now want to restore the previous one for some reason.

This previous version is what I want to restore to.

Restore & Publish

Here’s how you can Restore it.

Navigate to Save, and go to See All Versions
Now, you’ll come to all the versions of the App existing. The current one will have the status of Live. Click on the three ellipses of the old version of App you wish to restore and you’ll see an option to Restore
It’ll ask for a confirmation. Remember, the new version will be 1 version higher that the current Live version. In this case, it’ll be version 18 to be created from version 16 (version 17 is the current Live version)
Once you confirm, a new version will be created. This is not yet in Published stage. This is because you might want to go back and change something and then Publish
Now, let’s say you are ready to Publish, simply select it. And then either from the options in ellipses or on the top ribbon, you can Publish this version

Update on App

Upon opening the App, the user will see a message like this

And when you tap on it, the previous version is restored

Pretty easy!!

Here are some more Canvas Power App posts you might want to check –

Hope this helps!

Implement character length validation in a Canvas Power App | Power Platform

June 1, 2020May 25, 2021 priyeshwagh777 Microsoft PowerApps canvas powerapps, character limit, character validation, text validation

Often times, you want to know the size of text entered in a field and want to indicate a user that they need to restrict the text to your specific size, like Twitter. And make sure the user is restricted within the limits. So, I’ve added a button to show that validation –

And you want to dynamically check the length as you type to see how much is remaining

And maybe also add some validation like disabling the button if the limit is reached

Let’s look at how we can implement this in Canvas Power App!

Setup

Let’s get to building this out!

Let’s say you have a Text Input. I’ve simply called it “Message“
Then, I have the Label field called as “CharLength“. This will be a place holder for our counter of characters in the Message textbox.
And finally, a Submit button which will be disabled if the Text size exceeds the limit.

Setting Properties

Now, let’s get the properties set to these components so as to validate the character limit

Nothing to set on the Text Input ‘Message’ for this example.
Let’s move to the label CharLength itself. Set the Text handler of the CharLength label control to the following (You can have your own limit)

In the above example, I’ve set the length 60 and then I’m subtracting the length of the Text of the Message.Text (Text entered in Message box) so that as we type on, the remaining value will be shown as below –
Now, let’s see the Color property of the text field. It’ll be a visual cue indicating the user that they’ve exceeded the character limit

In the above example, I’ve added a condition to set the color as Red, if the length is exceeded or Black is the length is under the limit and will look something like below –
Finally, we’ll go to the Submit button and set the Display Mode property of it to the below

I’ve added a condition, that if the Length of the Message box’s Text goes above the limit, set the Display Mode to Edit i.e. Active or else, Disable. And it will look like below when disabled

Execution

This is how it will work when you put this in execution

I’ve also created a YouTube video demonstrating the same –

And that’s it. So you can use this validation as you want. In place of the button, you could have something else put up.

Hope this helps!

Here are some posts on Canvas Power Apps you might want to check –

Thanks!!

D365 Demystified

A closer look at Microsoft Dynamics 365.

Month: June 2020

ChildFlowUnsupportedForInvokerConnections error while using Child Flows [SOLVED] | Power Automate

Reason Issue

Excel Importing Notes (Annotation) entity in Dynamics 365 CRM

Scenario

Exporting Excel Template

Modifying the Excel

Re-Importing

Imported Notes

BPF Flow Step as a Trigger in CDS (Current Environment) connector | Power Automate

Flow Step

Flow & BPF Setup

Running the Flow

Results

Pass selected rows’ GUIDs to ribbon button in D365 | Ribbon Workbench

CRM Parameter

Read the GUIDs

Pause a Flow using Delay and Delay Until | Power Automate

Delay

Delay Until

Generate Dynamics 365 record link in a Flow using CDS connector | Power Automate

Get record action to retrieve URL

Generating Link

Options

Text Functions in a Flow | Power Automate

Find text position

Substring

Restore older version of a Canvas Power App | Power Platform

Current Version

Restore & Publish

Update on App

Implement character length validation in a Canvas Power App | Power Platform

Setup

Setting Properties

Execution

Reason Issue

Share this:

Scenario

Exporting Excel Template

Modifying the Excel

Re-Importing

Imported Notes

Share this:

Flow Step

Flow & BPF Setup

Running the Flow

Results

Share this:

CRM Parameter

Read the GUIDs

Share this:

Delay

Delay Until

Share this:

Get record action to retrieve URL

Generating Link

Options

Share this:

Find text position

Substring

Share this:

Current Version

Restore & Publish

Update on App

Share this:

Setup

Setting Properties

Execution

Share this: