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

Wednesday, February 28, 2024

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

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:

Tuesday, November 28, 2023

How to Enable Copilot for end users in canvas apps

Introduction:


In this Blog we will see how to Enable COPILOT in Canvas PowerApps


Implementation Steps:

 

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

 

2. Select the Respective Environment where you want to Enable COPILOT

 

3. Open the Environment

 

rampprakash_1-1701149600928.png

 

4. Click Settings on TOP --> Select Product --> Select Feature

 

rampprakash_2-1701149648231.png

 

 

5. You will see an Option Called COPILOT Enable the Option

 

rampprakash_3-1701149671598.png

 

6. Click Save

 

7. Now go to https://make.powerapps.com

 

8. Click Apps at the Left Side

 

9. Select New and Select Blank Canvas APP

 

10. Once the App Opened --> Click Settings from the top and Click Upcoming Features and Turn On COPILOT COMPONENTS

 

 

rampprakash_4-1701149795634.png

 

11. Once Done Click INSERT and You will See the COPILOT OPTION ENABLED

 

rampprakash_5-1701149856263.png

 

 

 

Note:

 

Current its based on the REGION Specific

Wednesday, November 15, 2023

How to Change help URL in Microsoft Dataverse ?

Introduction:


In this blog we will see how to Change Help URL in Microsoft Dataverse.


Implementation Steps:

 

1. Navigate to your CRM or Microsoft Dataverse.

 

2. In the Top Bar you will see a Question Mark (?) if you click on this it will open a URL

 

rampprakash_0-1700047490410.png

 

3. If we need to change the URL for that we need to follow below steps for the same.

 

4. Click Gear Icon at the TOP

 

5. Select Advance Settings

 

6. Select Administration

 

7. Select System Settings

 

rampprakash_1-1700047554094.png

 

8. Once Clicked it will open a POP UP

 

9. In the General Section --> Search for Option GLOBAL CUSTOM HELP URL

 

rampprakash_2-1700047614206.png

 

 

10. Change the URL

 

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