How to Create Record in Dataverse - Excel Import

Introduction: 

In this Blog we will see how to import record in Dataverse using Excel.

Implementation Steps:

 

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

 

2. Choose the Table where you want to Import the Record, in my case am Choosing Account Table

 

3. Now click Gear Icon at the Top then Select Advance Settings (For Legacy)

        Else Select Table --> Open Account --> Click Export

 

4. In my Case Am Taking Legacy Mode and Select Advance Find then Select Account Table and Click Result

 

 

5. Once the Page Loaded Select Export Accounts and Select Static WorkSheet

 

6. Once the Excel Downloaded --> Open the Excel and Remove the Rows which is available and Add a New Record which you want to create in Dataverse Account Table

 

7. Now once the Record added in a Row then Save the Excel as CSV format

 

 

 

8. Once Saved Go the Point 2 Again and Select Data Management and Select Imports

 

 

9. Click Import Data at the Top of the Ribbon

 

10. Now Choose the File (Saved .csv format)

 

 

 

11. Click Next and Select Next again and Select Default(Automatic Mapping)

 

 

 

12. Select Account as an Entity and Click Next

 

 

 

13. Now the Field will get mapped successfully if it is not mapped then Map the correct fields and Click Next

 

14. Select the Owner and Select weather you want to allow duplicates or not and Click finish

 

 

15. Once done you can able to see the Status of the Record

 

 

16. Once the Status Reason is Completed you can able to see the Records in your Dataverse Environment 

 

 

That's it 

How to Change Label Text in Form using JavaScript in Model Driven Apps

Introduction:

In this Blog we will see how to Change Label Text in Form Using JavaScript in Model Driven Apps.

Implementation Steps:

 

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

 

2. Click More --> Select Tables

 

3. Open the Table where you want to change the Form Text

 

In my Scenario I need to Change the Text Based on Boolean Field.

 

4. Boolean Field

• Name : Change Text
  • Yes --> If yes then Change Text to Selected Yes
  • No --> If No then Change Text to Selected No

5. Now Create a Web Resource then Upload Below Code

 

function onChangeBooleanField(executionContext) {
    var formContext = executionContext.getFormContext();
    if (formContext.getAttribute("crd20_changetext").getValue()) {
        formContext.getControl('name').setLabel('Selected Yes');
    } else {
        formContext.getControl('name').setLabel('Selected No');
    }
}

 

// crd20_changetext --> Boolean Field Logical Name

//name --> Label to be Changed

 

6. I have Written function in OnChange of Boolean Field

 

7. Once Code Written Refresh the Account Form

 

 

As i said written Code in On Change

 

Now if i change Value to Yes then You will see Selected Yes as Label

 

 

 

Now if i change to No then You will see Selected No as Label

 

 

 

That's it 

 

Using Change label in JavaScript we can change the Label Text.

How to Convert Speech to Text from Canvas PowerApps (Part II Azure)

Introduction:

In this blog we will see how to Configure Microsoft Azure for Converting Speech to Text

Lets see this in 3 Different Blogs, Here we start with Microsoft Azure

 

Pre-Requisites :

 

• Canvas PowerApps
• Microsoft Azure
• Microsoft Flow

 

1. Navigate to https://portal.azure.com

 

2. Click Search and Search for Resource Group

 

 

3. Input the Resource Group name and Click Review and Create

 

4. Once the Resource Group is Created then Click On Search at the Top and Search for FUNCTION APP

 

5. Now Create a New Function App like below Image

 

 

6. Now Click Review and Create

 

7. Once Function App Created Open the Function App and Search for Functions --> Select Create --> Select HTTP Trigger --> Select New Function and Click Create

 

 

8. Once the Function App is Created, In the Function App Search Search for Advance Tools  and Click GO

 

9. It will Open a POP-UP Click DEBUG and Select CMD

 

10. Once Page Loaded Click Site Folder --> wwwroot

 

  

 

11. Once the WWWROOT Loaded Select NEW and Select New Folder

 

 

 

12. Name it as "webm-to-wave"

 

13. Now go this Link and Select Windows and Download the File

 

14. Once the File is Downloaded Extract the File and GO to BIN and You can see Below Three Files

 

 

15. Drag and Drop it to the Folder which we Created

 

16. Once the File is Uploaded Go one Step Back there you can See the AZURE FUNCTION WHICH YOU CREATED

 

17. Open that and Click New and Create a File function.json / readme.md / run.csx

 

18. Here is my GITHUB link you can see the Files which need to be available in function.json/readme.md and run.csx 

 

19. Once Done Click Save.

 

20. Now Again Navigate to https://portal.azure.com

 

21. Search for Speech Services

 

 

 

22. Create a new Speech Services like below and Click Review and Create 

 

23. Once the Speech Service is Created Open it and Select KEYS and ENDPOINT

 

24. Copy the KEY and ENDPOINT

 

 

That's it For Azure 

 

In Next Blog, we will see how to Write Microsoft Flow to Achieve Speech to Text

How to Install Smart Buttons for Ribbon Workbench using XrmToolBox

Introduction:

In this blog we will see how to install Smart Buttons for Ribbon Workbench using XRMToolBox

Implementation Steps:

 

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

 

2. Click Solutions

 

3. Select Import Solutions and import Ribbon Work Bench (Download here)

 

 

4. Once Solution Imported then Click Gear Icon at the Top and Select Advance Settings

 

5. Select Solutions --> You will find Ribbon Work Bench

 

6. Click the Ribbon Work Bench it will open PopUp like below

 

 

7. At the Left side you can see the Smart Button but it does not contain any values

 

Let's see how to show SMART Buttons

 

8. Now Click Below Link

 

https://ribbonworkbench.uservoice.com/knowledgebase/articles/896958

 

9. Once You Opened Link you will find another Link

 

https://github.com/scottdurow/RibbonWorkbench/releases

 

10. Once you clicked on Above Link you will redirect to Github and Download the Highlighted Solution

 

 

11. Now again go to Solutions (Follow Point 1 and 2)

 

12. And Import Solution downloaded from Point 10

 

13. Select the Solution and Click Import

 

 

14. Now again go to Legacy Mode and Click on Solutions and Select Ribbon Work Bench Again

 

15. Once page loaded you can find the Smart Buttons.

 

 

 That's it