Tuesday, June 25, 2024

How to Call Action from WebResource using Web Api

Introduction:


In this blog we will see how to call action from WebResource using WebApi in MSCRM or Dataverse


Implementation Steps:

 

1. Create a Action ( find my blog here on how to create Action)

 

2. I have Created an action without any input Parameters

 

rampprakash_4-1719317688631.png

 

 

3. Once the Action is Created, Navigate to Settings --> Customization --> Customize the System --> Click Web Resource

 

rampprakash_3-1719316587746.png

4. Click New and Create a New Web Resource with Below Code

 

 

var req = {};
req.getMetadata = function () {
    return {
        boundParameter: null,
        operationType: 0,
        operationName: "new_AccountAction"
    };
};
 
Xrm.WebApi.online.execute(req).then( 
    function (data) { 
        var e = data; 
        debugger; 
    }, 
    function (error) { 
        debugger; 
        var errMsg = error.message; 
    }
);

 

5. That's it.

 

Now Call this function from OnLoad Or OnSave or OnChange from Account Level.

Wednesday, June 12, 2024

Importing solution error : Default OptionSet value has to be one of the option values. InnerException: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.Parameter name: Default picklist value has to be one of the option values.

 While trying to import solution with OptionSet Value am getting below error


Default OptionSet value has to be one of the option values. InnerException: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.Parameter name: Default picklist value has to be one of the option values.

How i Over Come this and what are the Options i cross checked here to fix this Issue

 

Steps i Crosschecked :

 

1. Make sure the Publisher is same

2. Make Sure the Optionset Text and Value Same

3. Make Sure the Option Set Data type is same

If all are good and Still getting an error?

 

I directly deleted from the destination Environment and imported the solution to make it work.

Thursday, May 23, 2024

Is your Asynchronous plugin or Workflow not running in Dataverse?

Introduction:


In this blog we will see how to enable Asynchronous Operation in MSCRM or Dataverse Environments.


Implementation Steps:

 

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

 

2. Click on Environments

 

rampprakash_0-1716464005067.png

 

 

3. Open the Environment where you want to run your plugins or workflows

 

4. Click Edit 

 

rampprakash_1-1716464055515.png

 

5. It will prompt a PopUp --> Scroll to the Last

rampprakash_2-1716464166239.png

 

 

6. Enable Administration Model and Enable Background Operations

 

That's it :slightly_smiling_face:

Friday, May 3, 2024

How to Run Microsoft Flow for Every one Month

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

 

rampprakash_0-1714736875580.png

 

3. Click New Flows and Select Scheduled Cloud Flows

 

rampprakash_1-1714736970375.png

 

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

rampprakash_2-1714737550885.png

 

That's it :slightly_smiling_face:

 

Thursday, May 2, 2024

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

 Introduction:


In this blog we will see how to Install Microsoft Dataverse Accelerator in Dataverse Environment.

 

Implementation Steps:

 

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

    rampprakash_0-1714652325244.png

     



  2. Select Environment at the Left Side and Open the Environments

    rampprakash_1-1714652325261.png

     



  3. Select Resource à Dynamics 365 apps

    rampprakash_2-1714652325263.png

     



  4. And make sure Dataverse accelerator app is installed if not click Open App Source

    rampprakash_3-1714652325264.png

     

  5. Search for Dataverse Accelerator App and Click Get It now
    rampprakash_4-1714652325265.png

     



  6. It will show a Pop Up Enter the Mandatory Details and Click Submit

  7. It will Again prompt a page to Select the Environment
    rampprakash_5-1714652325272.png

     



  8. Click Install. That’s it

  9. Now Navigate to https://make.powerapps.com
    rampprakash_6-1714652325275.png

    10. Now you will see Dataverse Accelerator App Installed

    rampprakash_7-1714652325283.png

     

     
    rampprakash_0-1714652453586.png

    That's it :)

Wednesday, April 10, 2024

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:

 

1. Created 2 tables

 

2. Created Look Up (Related between 2 tables)

 

3. Export Excel from Advance Find


4. Update the Sheet and Update the Another Sheet based on the Look which you created from Point 2.




 


Tuesday, March 19, 2024

How to Use Multilingual Language in Canvas PowerApps

Introduction:


In this Blog, we will see how to use multilingual language in Canvas PowerApps


Implementation Steps:


1. Open an Excel and Create Data Like Below and Save the Excel.

rampprakash_0-1710853889768.png

 



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

3. Click Apps


4. Click New Apps --> Page Design


5. Click Data Source at the Left Side and Search for IMPORT FROM EXCEL

rampprakash_1-1710853908211.png

 



6. Now Select the Excel from your Saved Location

rampprakash_3-1710853971926.png

 


7. Once After Selected the Excel you will see the Data Gets added Successfully in the PowerApps

rampprakash_4-1710853976602.png

 

 



8. Now in On Start of App write Below Code to get the Lanaguage of User (based on Broswer)

rampprakash_5-1710853981574.png

 



Set(
getCurrentLanguageofLoggedinUserBrowser,
Coalesce(
Lower(
Left(
Language(),
2
)
),
"en"
)
)


9. Now Add 3 labels (Click Insert and Click Labels)
Write Below Code
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Approved Leave").Text
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Pending Leave").Text
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Rejected Leave").Text


10. That' it . Now will run the PowerApps

11. For English

rampprakash_6-1710853989163.png

 



12. For Arabic

 

rampprakash_7-1710853994297.png

Day 11 - Customizing Option Sets Dropdown Fields with JavaScript

  In this Blog, we will see how to Customizing Option Sets Dropdown Fields with JavaScript label1 = formContext.getAttribute( "bosch_op...