How to get SubGird Record Count with Webresource in Dynamics CRM

Introduction:

In this Blog, we will see how to Get SubGrid Record Count in MSCRM or Model Driven App using WebResource.

Implementation Steps:

 

1. Navigate to https://make.powerapps.com

 

2. Create or Open any Existing Solution

 

3. Open the Table/Entity where you want to get count of SubGrid in my case am taking Account Table

 

 

4. As per the ScreenShot there is 4 Records available so i need to show as a popup with Count as 4

 

5. So First Step i will take the Sub Grid Name

 

6. Open the Form where your SubGrid Exists 

 

 

 

7. Based on the Above ScreenShot the Name of the SubGrid is Contacts

 

8. Now Lets Start Writing the JavaScript

 

9. Open Your Visual Studio or VS Code and Write the Below Function

 

function getsubgridcount(executionContext) {
    setTimeout(function () {
        var formContext = executionContext.getFormContext();
        if (formContext !== null && formContext != "undefined") {
            var accountgridname = "Contacts";
            var count = formContext.getControl(accountgridname).getGrid().getTotalRecordCount();
            alert(count);
        }
    }, 15000);
}

 

10. Now Create a JavaScript (Web Resource) in CRM 

 

 

11. Click Save and Publish

 

12. Now Open the Same Account Form and Add the JavaScript Library in the Form

 

 

13. Now Add Function in the OnLoad Operation

 

 

14. Once Done Click Save and Publish

 

15. Now Open the Account Table and Open a Record you will see the alert message over there 

 

 

 

That's it 

How to Create Model Driven Apps With Security Role Restriction

Introduction: 

In this Blog we will see how to Create Model Driven Apps with Security Role Restriction.

Implementation Steps:

 

1. Navigate to https://make.powerapps.com

 

2. Click Apps

 

3. Now Click on New App and Select Model Driven App

 

 

4. Then Input the Name for the Model Driven App and click Create

 

 

 

5. Once Done Click Add Page and Select the Page which you want to display, for demo am selecting Dataverse table and click Next

 

6. Now select Existing table and select the table and Click Add

 

 

7. Once Done click Save and Publish

 

 

8. Once the App Gets Created now Click Play it will open a Popup with the App Which we have created.

 

9. Now Click on Settings and Select Advance Settings

 

 

10. Once Page Opened Select the Setttings and Click Apps

 

 

 

11. You can see the App which you have created now Select the three dots and select Manage Roles

 

 

12. Once Selected it will Open the Roles --> select the Roles and Click Save

 

 

13. Once Save done.

 

The Respective Model Driven App will Load if the Logged in user contains that Specific Security Role which we have selected in Step 12.

That's it 

Generate Word Document Template Using Power Automate

 Introduction:

In this Blog am explaining how to Generate Word Template using Power Automate with Back End as SharePoint.

And am Covering how to add Repeating Controller and Plain Text Content Controller in Word Document.

 

Implementation Steps:

 

1. Navigate to your SharePoint Site and Create SharePoint List

2. In my case i have created 2 SharePoint List One is Employee and another Student

 

3. Add Records to Employee List and Student List

 

4. Now Open Microsoft Word Document 

 

5. Once Microsoft Word Opened Click on Developer in Ribbon Tool Bar 

 

 

6. If the Developer is not available then Click File --> Select Options --> Click Customize Ribbon and Select Developer --> and Click OK

 

 

7. Once Done Click Insert and Select Table

 

 

 

8. Now Input the Name in the First Column

 

 

9. Now Select the ID  then Click On Developer Ribbon Tab at the TOP then Select Add Plain Text Content Controller

 

 

10. Now Once Done Select the ID Column then Click Properties

 

 

 

11. After Clicking Properties it will Open Popup Enter Title and Tag

 

 

 

12. Once done, do the same for other Column as Well

 

 

 

13. Once Done, Now we are ready to Add Repeating Content Controller For the Table so that it will display All the Values from the List

 

 

 

14. Now Click On Properties and Provide the Tag and Title For Relating Table

 

 

 

15. The Same Way Create a New Table For Student and Add the ID and Title 

 

 

16. Now am Adding a Single Line of Text  Value as Well--> Simply add a Single Line of Text

 

 

17. Once Done Save the File in Your SharePoint Site

 

 

Once after Record Gets Created navigate to https://flow.powerautomate.com

 

18 . Click Apps --> Select New Flow --> Select Instant Cloud Flow and Input the Name as (Generate Word Template Using Power Automate) and Click Create.

 

 

19. Now Click Add Step and Select SharePoint and Search for Get Items and Add the SharePoint Site and Select List Name

 

 

20. Now Add Get Items Again and Get the Student List

 

 

 

21.Once Done Click Add Step and Search For SELECT

 

 

 

22. Now Select the Respective Values then Please make sure the EMPID and EMPTITLE As like as Properties which we have created in Point 11

 

23. Now Select Add Steps --> Search for Word then Select POPULATE A MICROSOFT WORD TEMPALTE then Select the Locations

 

 

 

24. Now for Populating REPEATING TABLE click the HIGHLIGHED BUTTON and Select the OUTPUT Values form Point 21.

 

25. Now Add Some Custom Values in Single Line of Text.

 

26. Now Send an Email 

 

 

That's it 

 

Now are are good to start the Process

 

 

 

Now the Flow Created Successfully. Now am Opening My Email and Downloading the file

 

 

 

Open the Downloaded File 

 

 

That's it 

 

I have mentioned Step by Step behaviors for How to Generate Word Document Template Using Power Automate 

How to get Quarters from Date in Canvas PowerApps

Introduction

In this Blog we will see how to get Quarters from Date in Canvas PowerApps

Implementation Steps:

 

1. Navigate to https://make.powerapps.com

 

 

2. Select Apps --> Select New App --> Select Canvas

 

3. Once Page Opened Input the name and Select Tablet or Phone depends on your requirement, from my end am selecting Tablet Mode

 

 

4. Once Page Get Opened  --> Add a Label by Selecting (Insert --> Label) and Add a Button as Well

 

 

5. Now Select the Button and go to OnSelect and Write below code Logic

 

 

Code For Converting Date to Quarter

If(
    Month(Now())<=3,
        Set(getQuarterFromDate,"1"),
    Month(Now())>=04 && Month(Now())<=06,
        Set(getQuarterFromDate,"2"),
    Month(Now())>=07 && Month(Now())<=09,
        Set(getQuarterFromDate,"3"),
    Month(Now())>=10,
        Set(getQuarterFromDate,"4")
)

6. Now Set the Default Value to getQuarterFromDate

 

7. Now Click on the Button

 

 

You will see the Current Quarter Value there.

 

That's it