{Step by Step}Passing parameters to Power automate from Canvas App.

deepeshsomani2013 Power Platform

In this blog, we will learn how to pass parameters to Power automate from Canvas App.

Requirement:

While working with Canva App, many times we come across a situation where we need to perform some operations through Power Automate, In this blog, we will learn how to pass the parameters to Power automate from Canvas Apps by calling a Power Automate flow, passing parameters to the flow.

Implementation:

  • Go to https://make.powerapps.com.
  • Sign into power apps.
  • Click on “Apps” from the left navigation panel.
  • Open a Canvas app, if want you can create new one.
  • In Canvas app.
  • Click on “Insert.”
  • Add “Text input‘ and “Button” to screen.
  • Click on the power automate from left panel.
  • Click on “Create new flow.”
  • Create a new flow by clicking on “Create from blank.“
  • Click on the “New Step.”
  • Search for “Initialize variable.”
  • Select “Initialize variable.“
  • Rename step by “Email.”
  • Select “String” in type.
  • In value field add dynamic content by clicking on “Add dynamic content.“
  • Click on “Ask in PowerApps” to get an dynamic content.
  • Select “Email_Value” to get the email address which you will enter
  • Add a new step.
  • Search for “Outlook.”
  • Select “Send an email (V2).”
  • In this step add a dynamic variable content in “To.”
  • Add dynamic content by clicking on “Add dynamic content.“
  • Select “varEmail.”
  • Add text value in “Subject” and “Body.”
  • Save flow and test it.
  • Now go to the Canvas app.
  • Click on the button which you have added before.
  • On the “OnSelect” property on button add this function.[‘Sendemailswithparameters’.Run(TextInput1.Text)]
  • Save and publish your app.
  • Now play your app.
  • Add Mail id and test your flow.

Output:

Hope it helps! 

Power 365ing as usual! 

Any requirements, implementation or consulting work in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual? 

Problem Area – Technical, Functional, Training, Development or consulting? 

Me and my team are here to assist, please fill the following form for your business needs: Click here 

Advertisement

{Step by Step}Share record with a user using Unbound action in Power Automate

deepeshsomani2013 Microsoft Dynamics CRM

Requirement:

In this blog, we will learn how to share records from Microsoft Dataverse to a user with the help of using an Unbound action in Power Automate, In Power Automate, an unbound action is a type of custom action that is not associated with a specific entity or record in a Dynamics 365 environment. It is a standalone action that can be called from any workflow or automation.

Implementation:

  • Go to https://make.powerapps.com.
  • Sign into Power apps.
  • Click on “Flows” from the left navigation panel > “+New flow.”
  • Select “Automated cloud flow.”
  • Give a title to your flow.
  • Search for the Microsoft Dataverse trigger “When a row is added, modified, or deleted.”
  • Select the Microsoft trigger.
  • Click on “Create.”
  • Select “Added” in the Change type.
  • Select an entity, we have selected an “Accounts” entity here.
  • Select “Organization” in the scope field.
  • Click on “+New step” for adding action.
  • Search for “Perform unbound action.”
  • Select Microsoft Dataverse action “Perform an unbound action.”
  • Select “GrantAccess” in the action name field.
  • In the target field enter entitylogicalname-plurarl(recordid) or entitylogicalname-plurarl/recordid.
  • You can add the dynamic id of the entity, we have added a dynamic id.
  • PrincipalAccess includes the user or team to which access will be provided and the Access Mask for the Privilege, in JSON format.
  • Click on “+New step.”

Tips: In this blog, we gave an access to user, for giving an access to team use the code given below.

Principal access for team.

{
"Principal:"
{
"teamid":"",
"@@odata.type":"Microsoft.Dynamics.CRM.team"
},
"AccessMask":"ReadAccess"
}
  • Search for “Initialize variable.”
  • Select “Initialize variable.”
  • Write “At” in the Name field.
  • Select “string” in the type field.
  • Write “@” in the Value field.
  • Click on “+New step.”
  • Search for “Compose.”
  • Select “Compose.”
  • Add PrincipalAccess JSON for sharing user.
  • Use the dynamic id of “At” instead of using “@.”

Hope it helps! 

Power 365ing as usual! 

Any requirements, implementation or consulting work in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual? 

Problem Area – Technical, Functional, Training, Development or consulting? 

Me and my team are here to assist, please fill the following form for your business needs: Click here 

{Step by Step} Send an email on click of Canvas App button using Power automate:

deepeshsomani2013 Power Platform

Requirements:

In this blog, we will learn how to send an email on the trigger of a button in the Canvas app by using Power Automate.

Implementation:

  • Go to https://make.powerapps.com.
  • Click on “Apps” on the left navigation panel.
  • Select “Canvas.”
  • If you do not want to create a new Canvas app, you can use the old one.
  • Give a title to your Canvas app.
  • Select any layout, here we have selected a “Tablet” layout.
  • Click on “Create.”
  • Click on “Insert.”
  • Now add a “Text label” and change the text value to “Send an email.”
  • Place this text label at the top for creating a Header.
  • Add 3 more “Text labels” and place them vertically.
  • And change their names to “To,” “Subject,” and “Body.”
  • Add 3 “Text inputs” and place them parallel to “Text labels.”
  • Rename “Text inputs” and “Text labels” from the tree view on the left pane.
  • And remove the default value from the “Text inputs.”
  • Change the display mode of “Bodyinput” (text input) “single line” to “Multiline.”
  • Click on “Insert.”
  • Select “Button.”
  • Change the button name from the tree view in the left navigation pane.
  • Change the text properties of the button to “Send” from the properties pane on the right.
  • Let’s create a Power automate.
  • Go to https://make.powerapps.com.
  • Sign into power apps.
  • Click on “Flows” in the left navigation panel > “+New flow.”
  • Select “Instant cloud flow.”
  • Give a title to your flow.
  • Select “PowerApps.”
  • Click on “create.”
  • Now, we will trigger the flow from Canvas app.
  • Click on “+ New step.”
  • Search “Send an email” in the new step.
  • Select “Send an email(V2).”
  • Here, we are using office 365 outlook for sending emails.
  • In the next step Click on “To.”
  • And add dynamic content.
  • Click on “Ask in power apps” it will automatically fill dynamic content in the “To” data card.
  • Now click on “Subject” > “See more” > “Ask in power apps.”
  • It will suggest dynamic content for the “subject.”
  • Do follow the same step for “Body.”
  • Your flow will look like this and save your flow by clicking on “Save.”
  • Let’s connect this Canvas app to power automate.
  • Click on the “power automate” on the left navigation panel in Canvas app.
  • Then click on “+Add flow.”
  • Select the flow which we have created.
  • Click on the button, and write this function on the “OnSelect” property of a button.

Sendemail.Run(ToInput.Text,SubjectInput.Text,BodyInput.Text);Reset(BodyInput);Reset(ToInput);Reset(SubjectInput)

  • Save and publish.

Hope it helps!  

Power 365ing as usual!  

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?  

Problem Area – Technical, Functional, Training, Development, or consulting?  

Me and my team are here to assist, please fill the following form for your business needs: Click here  

About the Author: 

{Step by Step} Create a waffle sliding menu panel in the Canvas app

deepeshsomani2013 Microsoft Dynamics CRM

In this blog, we will learn how to create a waffle sliding menu in Canvas app.

Requirement:

Creating a waffle navigation menu for easy accessibility of features and navigating other screens.

Implementation:

  • Sign into Power apps.
  • Create a Canvas app.
  • Go to insert and add a timer.
  • Select the timer and go to “Advanced” in the properties pane, On start switch “false” to “VarTimer”.
  • Change the duration of the timer from “6000” to “150”.
  • Add a “Waffle menu” icon.
  • And “OnSelect” of icon properties. UpdateContext({VarTimer:false});UpdateContext({VarWaffle:!VarWaffle,VarTimer:true})
  • This will start and stop the timer with the waffle menu.
  • Let’s create a flyout panel.
  • Add a rectangle and place it on the waffle menu.
  • On the “X” properties of waffle menu=If(VarWaffle,-115,-115+115*(WaffleTimer.Value/WaffleTimer.Duration))
  • Here we can see that the panel is on the left side of the screen.
  • Add one more waffle and on the “OnSelect”= UpdateContext({VarTimer:false});UpdateContext({VarWaffle:!VarWaffle,VarTimer:true})
  • And on the “X” property of the waffle menu paste the same value of the flyout rectangle’s “x” value.
  • Add buttons or icons in the flyout rectangle with the same “X” value as the flyout rectangle.
    • If(VarWaffle,-115,-115+115*(WaffleTimer.Value/WaffleTimer.Duration))
  • Save and publish.

Output:

Hope it helps! 

Power 365ing as usual! 

Any requirements, implementation or consulting work in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual? 

Problem Area – Technical, Functional, Training, Development or consulting? 

Me and my team are here to assist, please fill the following form for your business needs: Click here 

{Step by step}Searchable drop-down in Canvas app

deepeshsomani2013 Microsoft Dynamics CRM

In this blog, we will learn about “Combo box” feature in Canvas app.

Requirement: Creating a search option with the drop-down, for searching items in the list easily just by typing and searching rather than scrolling.

Link to Microsoft docs: shorturl.at/epvNW

Solution:

  • Open Canvas app.
  • Click on insert and select the combo box.
  • Click on combo box and go to the “Advanced” option in the properties pane.
  • Search “ IsSearchable” and switch it to “ true”.
  • Here we are using default data of “Combo box”.
  • Search “SelectMultiple” and switch it to “false”.
  • Search “InputTextPlaceholder” and define what you want to display in the drop-down.
  • Save and publish.

Outcome:

Hope it helps!  

Power 365ing as usual!  

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?  

Problem Area – Technical, Functional, Training, Development, or consulting?  

Me and my team are here to assist, please fill the following form for your business needs: Click here  

{Step by Step} Apply Power-FX Preview Formula Feature 

deepeshsomani2013 Microsoft Dynamics CRM

In this blog, we will learn about a new Power FX preview feature.   

Business requirement: To find difference between two dates by using “Formula” Data type. 

Follow this link to see “Formula” option as a data type.  

Link. (https://make.preview.powerapps.com/) 

After using this link, select the table where the “formula” data type is to be used. 

Here, we have created a table named as “Custom Table”. 

Now, we will add new column named as “Total Days” inside the table and select the data type as “Formula.” 

Also, we must already have created two date time columns “start date” & “end date.” 

  • Formula for Date Difference: 

DateDiff(new_startdate,new_enddate) 

Now, we must add this formula in “Total Days” field inside Formula section.

After that, we must Add columns to main form. And click on save to publish the outcome. 

Let us see what will happen! 

Hope it helps!  

Power 365ing as usual!  

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?  

Problem Area – Technical, Functional, Training, Development, or consulting?  

Me and my team are here to assist, please fill the following form for your business needs: Click here  

About the Author:  

{Quick Tip}Enabling custom plugin error messages to the PowerApps Portal page in D365

deepeshsomani2013 Microsoft Dynamics CRM

In this blog, we will learn about How to throw a custom error message in the PowerApps Portal page in D365.  

Sometimes when we are working on the PowerApps Portal, and we want to show some custom error message by using a Plugin based on some business logic, we will get a generic error message which is not useful to the end user that will say “An unknown failure has occurred. Error ID …” as shown in the fig. Given below : 

So, we will display the custom error message error with the help of the site setting in PowerApps portal. The steps are as follows: 

  • Firstly, Go to Apps > Portal Management  
  • Go to Site settings > New 

So, let us see what will do. 

Name - Site/EnableCustomPluginError 
Website – Whatever you have like Partner Portal, Customer Self-Service, etc… 
Value – true 

  • Then, Save & close.  

And go to portal > Sync Configuration and click on Browse Website. 

Let us see what happens! 

So, you will see the custom error message on the screen. 

Hope it helps!   

Power 365ing as usual!   

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner, or an individual?   

Problem Area – Technical, Functional, Training, Development, or consulting?   

I and my team are here to assist, please fill out the following form for your business needs: Click here   

About the Author:   

{Step by Step} Apply Patch Function from command using Power FX via new command editor

deepeshsomani2013 Microsoft Dynamics CRM

In continuation of my previous articles where we were exploring how to use the new Command designer, today we will learn how to apply a more complicated Patch function via Power Fx Command.

You can refer the previous parts as listed below:

Part 1: How to create a button:

{Step by Step}Create Command button in Power Apps using command designer

Part 2: How to apply a Power FX command using Command

{Step by Step}Add Power Fx Commands on a command button using command designer

Part 3:Apply Show Hide rules using Power FX command

{Step by Step} Add Show/Hide visibility rule using Power Fx to a Command button using new Command designer

In this blog, we will learn about the Patch function of Power FX in PowerApps, and we will use it in button click using the brand-new command editor!

Today’s requirement is that the account name should be updated at the click of a button.

To implement this requirement, first we need create a command button for which you should refer to Part 1 mentioned above.

We have created a button named as “Patch.”

And, we have used this formula to implement our requirements and added the formula for the notification:

Patch(Accounts, Self.Selected.Item, {‘Account Name’: “Patched: ” & Self.Selected.Item.’Account Name’});Notify(“Acount name is Upadated successfully”)

Let us test this button now! 

As you can see the account name is updated on the click of the Patch button.

Hope it helps! 

Power 365ing as usual! 

Any requirements, implementation or consulting work in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual? 

Problem Area – Technical, Functional, Training, Development or consulting? 

Me and my team are here to assist, please fill the following form for your business needs: Click here 

About the Author: 

{Step by Step} Add Show/Hide visibility rule using Power Fx to a Command button using new Command designer

deepeshsomani2013 Microsoft Dynamics CRM

In continuation of my previous articles where we were exploring how to use the new Command designer, today we will learn how to apply show and hide rule using Power Fx in the new command designer.

Part 1: How to create a button:

{Step by Step}Create Command button in Power Apps using command designer

Part 2: How to apply a Power FX command using Command designer: https://dynamicsofdynamicscrm.com/2022/08/04/step-by-stepadd-power-fx-commands-on-a-command-button-using-command-designer/

In last article we had already created a button named as “Entity Details.”

Now let us apply show and hide rule to the button!

Formula

Select the button “Entity Details”, click On Visible property and apply below formulae:          If(CountRows(Self.Selected.AllItems) > 0,true , false)

Based on this formulae, if at least one row of data is selected, button will be visible. Else, it will be invisible.

Please refer screenshot below:

As seen in below screenshot, command button is visible only when at least one contact is selected:

Tip: Sometimes the change on button does not reflect instantaneously, so you might need to refresh the page two to three times!

Now let us see the button visibility when no contact is selected:

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

About the Author:

{Step by Step}Add Power Fx Commands on a command button using command designer

deepeshsomani2013 Microsoft Dynamics CRM

In the last post we learnt how to add a command button using command designer: https://dynamicsofdynamicscrm.com/2022/07/27/step-by-stepcreate-command-button-in-power-apps-using-command-designer/

In this post, we will explore various Power FX commands we can add using new command designer:

We will cover the formulas “Navigate”,” URL” and “Notify”.

First go to the site map for Account table and click in the three dots ,click on edit command bar. Thereafter select the Main grid.

Three buttons are created as per reference in my last blog.

On click of “Navigate Active Record” button, we will navigate to “My Active Accounts” view

  • Formula for Navigate.

Navigate(‘Accounts (Views)’.’My Active Accounts’)

  • Result:

Now let us try to click on Navigate Active Records on Inactive Accounts view:

You can see that on click of the button we have navigated to “My Active Accounts” view:

Formula for URL:

Launch(“https://dynamicsofdynamicscrm.com/”);

Formula for Notify:

On click of Notification command button, we will try out Notify command:

Notify(“YouSelected”&Self.Selected.Item.’AccountName’,If(CountRows(Self.Selected.AllItems) > 0,true,false))

  • Outcome:

There is a show hide formulae also applied on this button(about which we will learn in my next article). The button will only be visible on selection of particular record:

On selecting a single account named “A.Datum dd” and clicking on the “Notification” button, you can see above that the name of the record is showing in the notification section.

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

About the Author: