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 

Host in Canvas PowerApps

Introduction: 

In this Blog we will see how to use Host in Canvas PowerApps

Implementation Steps:

 

In Canvas PowerApps there is an Option Called Host which Contains

• BrowserUserAgent
• OSType
• SessionID
• TenantID

1. BrowserUserAgent : This Will Show the User's Browser Agent

 

 

 

2. OSType : Type of OS 

 

 

3. Session ID: Current Session ID

 

 

 

4. Tenant ID: Tenant id (Environment ID)

             

 

 

That's it 

How to Share Microsoft Flow in Power Platform ?

Introduction:

In this Blog, we will see how to share Microsoft flow in Power Platform

Implementation Steps:

 

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

 

2. Click My Flows at the Left Side

 

3. Select the Flow which you want to Share 

 

 

4. Now Click On Share

 

5. Input the Name

 

 

6. Once User Added then Select weather the User Can be Co-Owner or not

 

7. If Co-Owner Select the Check Box at the Right Side Form

 

8. Now Click Share 

 

That's it 

How to Share Canvas PowerApps in Power Platform ?

Introduction:

In this Blog, we will see how to share Canvas PowerApps in Power Platform.

Implementation Steps:

 

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

 

2. Click Apps at the Left Side

 

3. Select the Apps which you want to Share 

 

 

4. Now Click On Share

 

5. Input the Name

 

 

6. Once User Added then Select weather the User Can be Co-Owner or not

 

7. If Co-Owner Select the Check Box at the Right Side Form

 

8. Now Click Share 

 

 

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 III Microsoft Flow)

Introduction:

In this blog we will see how to Configure Microsoft flows 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://make.powerautomate.com

 

2. Select New --> Select Instant Cloud Flow

 

3. Add Step --> Initialize Variable

 

 

Add Value as ASK FROM POWERAPPS

4. Add Another Variable

 

 

replace(variables('Data'),'data:audio/webm;base64,','')

 

5. Add Compose to Convert to JSON

 

 

json(variables('ReplaceValues'))

 

6. Now Add Parse JSON and Pass input from COMPSE

 

 

 

{
    "type": "object",
    "properties": {
        "Url": {
            "type": "string"
        }
    }
}

 

7. Get the Value from JSON and Pass value as URL

 

 

8. Trigger a HTTP Request to Function app (URL : Function APP URL)

 

 

9. Trigger HTTP Request for Cognitive Service with KEY and Content Type

 

 

Here the URL will be Your Cognitive URL and Key as Cognitive Key

 

10. Parse JSON and the Input from Point 9

 

 

 

{
    "type": "object",
    "properties": {
        "RecognitionStatus": {
            "type": "string"
        },
        "Offset": {
            "type": "integer"
        },
        "Duration": {
            "type": "integer"
        },
        "NBest": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "Confidence": {
                        "type": "number"
                    },
                    "Lexical": {
                        "type": "string"
                    },
                    "ITN": {
                        "type": "string"
                    },
                    "MaskedITN": {
                        "type": "string"
                    },
                    "Display": {
                        "type": "string"
                    }
                },
                "required": [
                    "Confidence",
                    "Lexical",
                    "ITN",
                    "MaskedITN",
                    "Display"
                ]
            }
        },
        "DisplayText": {
            "type": "string"
        }
    }
}

 

10. At last Respond to PowerApps

 

 

 

That's it