Monday, January 29, 2024

How to use Retrieve and Retrieve Multiple using PowerShell

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 :)

Friday, January 5, 2024

How to Use Dataverse Accelerator -Low Code Automated Plugin

Introduction:


In this Blog, we will see how to use Dataverse Accelerator - Low Code Automated Plugin


Implementation Steps:

 

1. Navigate to https://admin.powerplatform.microsoft.com

 

2. Open the Sales Environment

 

3. Click On Dynamics 365 Apps

 

rampprakash_0-1704438158015.png

 

4. Then Select the Dataverse Accelerator

 

rampprakash_1-1704438212462.png

 

5. Make sure its Installed

 

6. Now Navigate to https://make.powerapps.com

 

7. Click Apps at the Left Side then Select and Play Dataverse Accelerator App

 

rampprakash_2-1704438341829.png

 

8. Once the Page is Opened Click New Plug-in

 

9.  You can see 2 Options one is Instant and Another One is Automated.

 

rampprakash_3-1704438398000.png

 

10. For Today's demo we will see Automated Plugin

 

rampprakash_4-1704438487918.png

 

 

Now Fill the Details like highlighted above.

 

Now Save 

 

11. Now Open Account Entity and Create a Record 

 

12. Once the Record gets created you can see the Description Field Updated as DEMO

 

rampprakash_5-1704438593696.png

 

 

That's it :slightly_smiling_face:

How to Import Data from Excel to Multiple tables in PowerApps

Introduction:   I have created a view on how to import data from excel to multiple tables in Canvas PowerApps   Implemented Steps: ...