Introduction:
In this Blog we will see how to Run Microsoft Flow for Every one Month.
Implementation Steps:
1. Navigate to https://make.powerautomate.com
2. Click My Flows at the Left Side
3. Click New Flows and Select Scheduled Cloud Flows
4. Once Selected it will prompt a page there enter the Name of the Flow and Select the Date on when to trigger and Select the Repeat every 1 MONTH
That's it 
Introduction:
In this Blog we will see how to use Retrieve and Retrieve Multiple using Power Shell with Dataverse or MSCRM
1.
Retrieve:
Retrieve Used to Retrieve Single
Record at a Time
CMDLETS:
Get-CrmRecord
Sample :
Get-CrmRecord -conn $conn
-EntityLogicalName account -Id be02caab-6c16-e511-80d6-c4346bc43dc0 -Fields
name,accountnumber
account - Entity Logical Name
be02caab-6c16-e511-80d6-c4346bc43dc0
- GUID of record to Retrieve
name,accountnumber - Field from
Account Table
2. Retrieve Multiple :
Retrieve Multiple Used to Retrieve
Multiple Records at a Time
CMDLETS:
Get-CrmRecordsByFetch
Sample :
$accountFetch = @"
<fetch version="1.0" output-format="xml-platform"
mapping="logical" distinct="false">
<entity name="account">
<attribute name="name" />
</entity>
</fetch>
"@
$multipleRecord =
(Get-CrmRecordsByFetch -conn $conn -Fetch $accountFetch).CrmRecords
That's it :)
Introduction:
In this Blog we will see how to use Delete operations in Microsoft Dataverse or MSCRM
Implementation Steps:
As I mentioned in my Previous Blog you can able to follow how to use Dataverse Connection with Console Application.
In this Blog we will see how to use Delete Operation in Dataverse
Copy and Paste the below Code for Delete Operations
CrmServiceClient service = new CrmServiceClient(connectionString);
service.Delete("account", new Guid("a4cea450-cb0c-ea11-a813-000d3a1b1223"));
"account" --> Entity Logical Name
"a4cea450-cb0c-ea11-a813-000d3a1b1223" --> GUID of the Record to Delete
Introduction:
In this Blog we will see how to Connect Dataverse with Console Application.
Implementation Steps:
1. Open Visual Studio
2. Search for .Net Framework
3. Select Next
4. Input your Name and Click Create
5. It will Create a Console Application Project
6. Once Created Input the Below Code
try
{
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
CrmServiceClient conn = CrmServiceClient(ConfigurationManager.ConnectionStrings["Xrm"].ConnectionString.Decrypt());
conn = new CrmServiceClient("AuthType=Office365;Url=https://URL.crm4.dynamics.com/;Username=USERNAME;Password=PASSWORD;RequireNewInstance=True");
if (conn.IsReady)
{
// Connection Established
}
else{
// Connection Not Established
}
return conn;
}
catch (Exception ex)
{
throw;
}
7. Once you pasted above code you will get error like below (ITS because of Missing Assembly)
8. Right Click on the error CRMServiceClient you will get Quick Actions Select and Select Install Package Microsoft.CrmSdk.XrmTooling.CoreAssembly
9. Once Done it will automatically install all the Respective Assembly
That's it 
Once done you are good to go with the CRM Connection and process.
Note:
We can use Client ID and Client Secret as well to establish Connection
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
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.
Introduction:
In this blog we will see how to use Switch Statement using Power Automate
Implementation Steps:
1. Navigate to https://make.powerautomate.com
2. Click Flows
3. Click My Flows --> Click New Flows --> Click Build Your Own
4. Select PowerApps
5. And Select Power Apps Trigger and Click Next --> Select Switch Statement and Click OK
6. It will open a Popup
FOR DEMO AM USING A VARIABLE to SWITCH STATEMENT
7. Once Opened Click + (New Step) and Select Initialize Variable and Select Type as Integer and provide Value as 1
8. Now Add another Variable to Set the Value in Switch Statement
9. Now in the Switch Statement Select On as the Variable which we declared in Step 7
10. Now in the Case input Value as 1 and set the Value
11. Now Click + Button for adding another Case and Add a value like below
12. If you have any default value Input the Value in Default
13. Now Save the Flow and Click Test and Trigger manually Now as we have Value Hardcoded as 1 now the Switch Case will Navigate to Case 1
That's it 
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 
