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.

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

 

 

 

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

 

4. Click Edit 

 

 

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

 

 

6. Enable Administration Model and Enable Background Operations

 

That's it 

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

 

 

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 

 

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
   
   

    

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

    

   
   
   
3. Select Resource à Dynamics 365 apps
   
   

    

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

    

5. Search for Dataverse Accelerator App and Click Get It now
   

    

   
   
   
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
   

    

   
   
   
8. Click Install. That’s it
   
   
9. Now Navigate to https://make.powerapps.com
   
   
   10. Now you will see Dataverse Accelerator App Installed
   
   

    

    
   
   
   That's it :)

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.

 

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.

 

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

 

6. Now Select the Excel from your Saved Location

 

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

 

 

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

 

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

 

12. For Arabic

 

How to Make a Text Bold in Canvas App?

Introduction:

In this Article we will see how to make Text Bold in Canvas App

Steps:

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

2. Click Apps

3. Create a New App with Blank Template

4. One the Page gets Loaded Click Insert and Add HTML TEXT

 

5. Now Add below text in HTML Text

 

"Sample text <b>Bold Here</b>"

 

Explanation:

Sample text --> Sample text Value

<b> --> Bold Opening 

Bold Here --> Text to Bold

</b> --> Bold Closing

 

Final Image:

 

 

Conclusion:

Based on above steps you can convert text to BOLD from Canvas PowerApps