Category: Dynamics 365

Everything You Need to Know About Embedded Canvas Apps

Hello Readers

Hope you are all well!

It’s been a while since I last wrote, I got super busy with my community events and the new work life.

I will try to be as regular as possible on my posts.

Today, I am sharing everything I know about using an embedded canvas app in Dynamics 365 and Model Driven Apps; this will be more of a guide.

How many apps can I embed on a form?

Three canvas apps at a time, per form on web and one for Phone or Tablet.

Is there a workaround to use more than three apps on the web for?

Yes, use a webresource with your app URL and adjust the height and width. You might need to pass a parameter in your app depending on what the app is for. (Not the best result but a workaround)

What do I need to consider if it’s the first canvas app of my organisation?

If this is your first app, you might want to cross check security roles of users who’re going to use this app within Dynamics 365 as you need to provide additional privileges, assuming you’ve been using Dynamics 365 already. The privilege is called ‘Canvas App’, minimum read privileges will be required.

Is there something specific I would need to communicate to the users on the launch day?

  • Users will see a sign in screen first time and must sign in.
  • Users will need allow access.
  • Session will timeout in case of inactivity and users will be required to sign in again.

How to share an embedded canvas app?

In the maker portal, click the ellipses to share the app. You can share the app to everyone or specific users. The easiest way to share with a group of users (if you don’t have a security group) is export users to excel and transpose to a row with comma separated aliases. This is not the fastest way if you want to share with a small number of users like 3-5 but 50-100.

Special control ModelDrivenFormIntegration and related actions

NameDescriptionExample
ItemAccess the record on which you embed the appModelDrivenFormIntegration.Item.InvoiceID
SaveFormSaves the record on which you embed the appModelDrivenFormIntegration.SaveForm()
OpenQuickCreateFormOpens a quick create form of the table specified (default form in case you have more than one quick createModelDrivenFormIntegration.OpenQuickCreateForm(Contacts)
RefreshFormRefreshes the record on which you embed the appModelDrivenFormIntegration.RefreshForm(true)
ModelDrivenFormIntegration.RefreshForm(false)
**true or false is for the pop up message of unsaved changes on the model driven form
NavigateToViewNavigates user to a view of the specified tableModelDrivenFormIntegration.NavigateToView(Accounts, ‘Active Accounts’)
NavigateToMainFormNavigates user to a form of the specified tableModelDrivenFormIntegration.NavigateToMainForm(Contacts, ‘Unified Interface Contact Form’, ‘GUID’)

**Opening ‘Modal Dialog’ form via ModelDrivenFormIntegration is not possible at this stage.

Enable or Disable an embedded canvas app

On the field properties control tab👇

Why can’t I see my embedded canvas app?

Make sure you’ve the following things in place:

  • You’ve the right license.
  • You’ve the right privilege in your security role.
  • You’ve enabled third party cookies and local data.

I am a system administrator but cannot see my embedded canvas app

It will not appear until you first save the form meaning if the record is not created then you will only see a blank space.

How can I get related data in embedded canvas app?

On most forms in Dynamics 365 and Model Driven apps you will at least have one look up field. And to be able to get data out of it, you cannot use the special control directly i.e. ModelDrivenFormIntegration.Item.PriceLists.Name would not given you any result but error. Instead use, LookUp(Invoices, Invoice = ModelDrivenFormIntegration.Invoice).’PriceList’.’Name’

Quick Tip

Try and use a required field to link/embed the app to. If not, try auto-populating default data via a business rule or JS because if your field is blank then your app will not refresh in context of any data changes on the form where the canvas app is embedded.

That’s all I have to share. I will try and keep adding to the list. If I have missed on something, please comment and I will add it to the list.

Hope it helps!

Dynamics 365 Wave 1 2020 Release|Customer Service

Hi Everyone

Following topics from wave 1 2020 customer service are covered in this video:

Timelines

How to enable wave 1 update?

Customer Service

•Agent productivity enhancements to knowledge capabilities

•Configure case resolution page

•Enhancements in case routing rules

•Enhancements in queue page

•Modern email experience

•New work hour calendar in service scheduling

•Rich text notes and keyword search

•Support for site entity

•Enhancements in SLA

•Automatically create and update records

Download PDF Here from Microsoft

Video here:

Note: 11:55 in the video I missed a queue feature, screenshot below:

Another one I missed, ‘Automatic record creation’- condition builder now allows you to save and open in Power Automate; screenshot below:

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

Dynamics 365 Wave 1 2020 Release|Sales

Hi Everyone

Following topics from wave 1 2020 sales are covered in this video:

Timelines

How to enable wave 1 update?

Forecasting

•Flexible column modeling

•Support different organizational structure

•Benefit from quota management

•Advanced filtering

•Security modeling to meet business needs

•Forecast adjustments

•Responsive forecasts grid

•Edit participating records inline

•Pipeline visualization •Near real time updates

Licensing

•Sales Team Member

•Customer Service Team Member

•Project Resource Hub

Simplified Experiences

•Enhanced experience for adding products

•Easier Selection of email templates

•Manage activities with ease

•Save standardize PDF documents

•Opportunities in Kanban

Download PDF Here from Microsoft

Video here:

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

The Top 5 Most Watched YouTube Videos of DIY D365 in 2019

Hello Readers

christmas

First of all a big thank you for your support in 2019. Please continue supporting.

Following is a list of top 5 videos which you liked and watched the most:

Rank Blog Post Views Hours watched Series
1 The Secrets of Dynamics 365 Wave 2 (preview) 1326 137.8 Previews
2 Episode 5: Easy Power Apps Hacks To Make Your Users Life Easy 2365 123 PowerApps Tutorial
3 TGIF Episode 2: Building Your First Flow (Power Automate) 2293 118 Thank God It’s Flow
4 Episode 6- Embedding Canvas App in Model Driven App 1552 100 PowerApps Tutorial
5 TGIF Episode 3: Most Common ODATA Filter Queries for MS Flow (Power Automate) 2073 100 Thank God It’s Flow

If you’re new here or haven’t watched it yet, click on the link to watch.

A lot of people have reached out to me on the videos asking questions and also how it has helped them; that’s awesome 🙂

Note: No. of views was accurate as at 12/12/2019. Ranking is based on the hours watched on my YT channel.

Thanks for reading!

Subscribe to my channel and follow my blog.

The Top 3 DIY D365 Blogs in 2019

Hello Readers

christmas

First of all a big thank you for your support in 2019. Please continue supporting.

Following is a list of top 3 blog posts which you liked the most:

Rank Blog PostViews
1Every PowerApps Formula You Ever Wanted To Know As A Functional Consultant 3136
2Every Power Automate (MS Flow) Filter Query You Ever Wanted To Know As A Functional Consultant 2317
3Make A Better First Impression With Visitor Sign In App (PowerApps)2173

If you’re new here or haven’t read it yet, click on the link and have a read.

Most views I got were on Home Page/ Archives 13150 but that can’t be classified as a blog so no mention in the ranking table.

Note: No. of views was accurate as at 12/12/2019. Ranking is based on the views I received on my website and powerusers community blog.

Thanks for reading!

Subscribe to my channel and follow my blog.

How to fix the subgrid in Dynamics 365 UI?

Hello Readers

This blog is part of my quick tip series and will be short.

if you’re struggling with the responsive subgrid in Dynamics 365 and want to permanently fix it, regardless of the screen resolution/zoom or device; here’s the solution:

Look at the problem first-

Sub-grid 1-You see a sub-grid like this:

1

Sub-grid 2-And it changes to this when you zoom out or change the resolution:

2.png

So how can you make sub-grid 2 appear all the time?

Step 1:Go to advanced settings

3.png

Step 2:Customisations or solutions depending on the need

Step 3:Entity>>Form

Step 4:Double click the sub-grid on the form

Step 5:Click controls

Step 6: Select ” as a control

Step 7: Select ‘Grid only’ under “Reflow behaviour”

4

Step 8: Save and then publish

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Episode 8: Top Reasons to Use Power Automate (Power Automate vs Dynamics 365 Workflows)

Hi Readers and Viewers

Merry Christmas and a very Happy New Year! Thanks for your support in 2019 🙂

In this video, we will look at the top reasons for you to start using Power Automate. Also, this is the last episode of the series so I thought what’s better than a comparison. If you remember, in my first episode I asked you that have you found your reason to use Power Automate yet? Well, if you haven’t I am giving you the reasons in this episode.

Power Automate FlowDynamics 365 CE Workflow
No Code SMS Integration https://txtsync.com Not OOTB
Social Media IntegrationNot OOTB
Convert to PDF (Multiple ways available)Not OOTB
Copy Salesforce Account/Contacts to D365Not OOTB
Sync email attachements to OneDriveNot OOTB
Gmail to Dynamics 365 and Dynamics 365 to Google calendar Not OOTB
Updating 1 to Many relationship recordsNot OOTB
Update a lookup field from text field
https://diyd365.com/2019/03/12/update-a-lookup-from-a-text-field-no-code-solution/
Not OOTB
Update opportunity/order/quote from opportunity/order/quote close forms
https://diyd365.com/2019/09/13/how-to-update-an-opportunity-from-opportunity-close-and-send-an-email-on-opportunity-close-using-ms-flows-no-code-solution/
Not OOTB

Everything in the list above is in context of Dynamics 365. Out of the box (OOTB) Dynamics 365 workflows can’t do any of the above. You will have to create a custom workflow (#code) or a plugin (#code).

Hope I have given you reasons to start working on Power Automate.

Video here:

Fundraising for Rural Aid Australia- TGIF Shirts, here.

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Episode 7: Using Power Automate (Microsoft Flow) Mobile App To Build A Flow

Hi Readers and Viewers

In this blog & video, we will look at the ease of using ‘Power Automate’ Mobile App.

First half of the blog talks about the app structure and components/features available (Almost everything is available)

Second half of the blog includes a video where I am demonstrating the app and also create a Flow via Power Automate Mobile App.

Download the app from apple store https://apps.apple.com/au/app/power-automate/id1094928825

Download the app from google play store https://play.google.com/store/apps/details?id=com.microsoft.flow&hl=en

First up, what’s available in the mobile app?

  1. Activity
    • Feed
    • Approvals
  2. Browse
  3. Buttons
  4. Flows
  5. Account

Activity Section

Feed tab

  • You can check the sessions of your Flows here.
  • You can check any notifications you received here.

Approvals tab

  • You can check the approvals list here

Browse Section

Browse Templates by Services

  • Browse by services like Excel, OneDrive etc.

Browse Templates by Categories

  • Browse by categories like mobile, featured, collect data etc.

Button Section

  • All your on-demand flows triggering on a button click are here or can be created from here

Flows Section

  • All your flows will be visible here along with the last run status.
  • All your button flows or on-demand flows will be visible here as well
  • You can click on the flow to perform the following actions:
    • Enable/Disable flow
    • Edit/Modify flow
    • Check owners/Share flow
    • Run history of the flow
    • Save as
    • Delete the flow

Account Section

  • This is where all the settings for your Power Automate App/Account are available. Following actions can be performed here:
    • Select/Change Environment
    • Help and Support
      • Learn
      • Contact Support (Support.microsoft.com)
      • Suggest a Feature (Powerusers Power Automate idea page)
    • About
      • Version
      • License Terms
      • Third Party notices
    • Privacy
      • Privacy (privacy.microsoft.com)
      • Send usage data (yes/no)
    • Give feedback
      • How was your experience?
      • Contact Support
        • Visit community
        • Open support ticket

Video on using the app here:

Hope you find it helpful!

Fundraising for Rural Aid Australia- TGIF Shirts, here.

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Episode 2: Building Your First Flow

Hi Readers and Viewers

In this episode, we will deep dive into Power Automate and will create our first flow. We are also going to see different types of flows available within Power Automate. We will look at the following scenario to create our flow:

Scenario: Assign Territory to a customer based on the ‘Address 1: ZIP/Postal Code’ field in CDS/D365. (Address 1: ZIP/Postal Code is a text field)

Out of the box what’s available: Territories are related to ‘postal codes’ as 1: N relationship. Both Territory and Postal Code are available OOTB in CDS/D365. But on Account form, ZIP/Postal Code is a text field so how do we perform this action without any coding efforts.

Solution before Power Automate (MS Flow): If flow wasn’t there, we would have to create a plugin which will trigger post-operation/ record creation and check the value of ‘Address 1: ZIP/Postal Code’ in the data table of Postal Code and then pick up a related territory to update that territory on account form and the efforts required to that plugin would not be less than 4 hours.

Solution after Power Automate: Thank God it’s Flow! with the help of flow you can achieve the results in 5 minutes or less.

Watch the video here:

Fundraising for Rural Aid Australia- TGIF Shirts, here.

Descriptive blog post here.

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

PowerApps & Flow User Group App for Leaders, Hosts, Organisers and Coordinators

Hello Readers and Viewers

As User Group organisers, it becomes difficult for us to track the attendance of participants mostly due to the format of the meeting. In our last week’s UG we were prepared to break the ice and created an app to check in attendees.

Following is what you can do with the app:

  1. Register attendees as members
  2. Update member details
  3. Check In attendees
  4. Draw Raffle (if and when it’s available)

What can you get out of it:

  1. Track the attendance of your members
  2. If members are not regular, send them a survey for what they want to see
  3. Send them a FormsPro survey to get feedback
  4. Keep member details up to date
  5. Instead of drawing raffle the conventional way, use PowerApps

Screens:

Home

IMG_0279

Register Participant

IMG_0281

Update Details and Check In

IMG_0282

Note: Check In form is hidden, so members don’t have to fill in date, UG and their name again

Members List

IMG_0280

Draw Raffle

IMG_0283

Note: Shuffle formula and collection is used for Raffle draw

Data Source: OneDrive (Excel Web)

Tables used: Registered Members and Checked In Members to draw raffle

If you’re a User Group leader and want to use this app; you don’t really have to make any changes except for the connection and start using it. I have uploaded it on github. More instructions on there:

https://github.com/diyd365/UserGroupApp

Watch the youtube demo here:

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!