Showing posts with label Canvas. Show all posts
Showing posts with label Canvas. Show all posts

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, 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

Thursday, August 31, 2023

How to Use Delete Operations in Microsoft Dataverse or MSCRM

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

Friday, August 11, 2023

How to Use Update Operations in Microsoft Dataverse or MSCRM

Introduction:


In this Blog, we will see how to use Update 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 Update Operation in Dataverse

 

Copy and Paste the below Code for Update Operations

 

Entity updateAccount = new Entity("account");
updateAccount.Id = new Guid("e0385c7b-8b32-ee11-bdf4-002248d5d764");
updateAccount["name"]= "Updated from Console Application";
service.Update(updateAccount);

 

"account" --> Entity Logical Name

"e0385c7b-8b32-ee11-bdf4-002248d5d764" --> GUID of the Record to Update

"name" --> Field Name to Update

"Updated from Console Application" --> Values to be Updated

Wednesday, May 31, 2023

Host in Canvas PowerApps

Introduction: 


In this Blog we will see how to use Host in Canvas PowerApps


Implementation Steps:

 

In Canvas PowerApps there is an Option Called Host which Contains

  • BrowserUserAgent
  • OSType
  • SessionID
  • TenantID

1. BrowserUserAgent : This Will Show the User's Browser Agent

 

rampprakash_0-1685529895877.png

 

 

2. OSType : Type of OS 

 

rampprakash_1-1685529933795.png

 

3. Session ID: Current Session ID

 

rampprakash_2-1685529960681.png

 

 

4. Tenant ID: Tenant id (Environment ID)

             

rampprakash_3-1685530007019.png

 

 

That's it :slightly_smiling_face:

Wednesday, April 26, 2023

How to Share Canvas PowerApps in Power Platform ?

Introduction:


In this Blog, we will see how to share Canvas PowerApps in Power Platform.


Implementation Steps:

 

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

 

2. Click Apps at the Left Side

 

3. Select the Apps which you want to Share 

 

rampprakash_0-1682505817438.png

 

4. Now Click On Share

 

5. Input the Name

 

rampprakash_1-1682505873632.png

 

6. Once User Added then Select weather the User Can be Co-Owner or not

 

7. If Co-Owner Select the Check Box at the Right Side Form

 

8. Now Click Share :slightly_smiling_face:

 

 

That's it :slightly_smiling_face:

Wednesday, March 1, 2023

How to Convert Speech to Text from Canvas PowerApps (Part II Azure)

Introduction:


In this blog we will see how to Configure Microsoft Azure for Converting Speech to Text


Lets see this in 3 Different Blogs, Here we start with Microsoft Azure

 

Pre-Requisites :

 

 

1. Navigate to https://portal.azure.com

 

2. Click Search and Search for Resource Group

 

rampprakash_0-1677647304786.png

 

3. Input the Resource Group name and Click Review and Create

 

4. Once the Resource Group is Created then Click On Search at the Top and Search for FUNCTION APP

 

5. Now Create a New Function App like below Image

 

rampprakash_1-1677647435677.png

 

6. Now Click Review and Create

 

7. Once Function App Created Open the Function App and Search for Functions --> Select Create --> Select HTTP Trigger --> Select New Function and Click Create

 

rampprakash_2-1677647551701.png

 

8. Once the Function App is Created, In the Function App Search Search for Advance Tools  and Click GO

 

9. It will Open a POP-UP Click DEBUG and Select CMD

rampprakash_3-1677647847326.png

 

10. Once Page Loaded Click Site Folder --> wwwroot

 

rampprakash_4-1677647895087.pngrampprakash_5-1677647928265.png  

 

11. Once the WWWROOT Loaded Select NEW and Select New Folder

 

rampprakash_6-1677647985501.png

 

 

12. Name it as "webm-to-wave"

 

13. Now go this Link and Select Windows and Download the File

 

14. Once the File is Downloaded Extract the File and GO to BIN and You can see Below Three Files

 

rampprakash_7-1677648188133.png

 

15. Drag and Drop it to the Folder which we Created

 

16. Once the File is Uploaded Go one Step Back there you can See the AZURE FUNCTION WHICH YOU CREATED

rampprakash_8-1677648247202.png

 

17. Open that and Click New and Create a File function.json / readme.md / run.csx

 

18. Here is my GITHUB link you can see the Files which need to be available in function.json/readme.md and run.csx 

 

19. Once Done Click Save.

 

20. Now Again Navigate to https://portal.azure.com

 

21. Search for Speech Services

 

rampprakash_9-1677648439244.png

 

 

22. Create a new Speech Services like below and Click Review and Create 

 

rampprakash_10-1677648499694.png

23. Once the Speech Service is Created Open it and Select KEYS and ENDPOINT

 

24. Copy the KEY and ENDPOINT

 

rampprakash_11-1677648613872.png

 

That's it For Azure :slightly_smiling_face:

 

In Next Blog, we will see how to Write Microsoft Flow to Achieve Speech to Text

Thursday, October 6, 2022

How to Increase File Column Size in Dataverse

Introduction:

In this Blog, we will see how we can increase size of File Column in Dataverse/MSCRM Environment.

 

Implementation Steps:

 

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


2. Select the Respective Environment


3. Click Solutions if you have any else click Dataverse and Select Tables


rampprakash_3-1665051411936.png

 

 

4. Click on Respective Table and Open it.


5. Click New --> Select Columns


rampprakash_2-1665051383311.png

 

 

6. Once Selected New Column it will open a Popup in that Select Data Type as File and Select File as an Option


rampprakash_1-1665051354400.png

 

7. On Selected Click Advance Settings to Increase file Size

      Default Size will be 32768


rampprakash_4-1665051436843.png

 

8. If we want to Increase the Default File Size you can increase the same in Maximum File Size Column.

 

9. Once Done Click On Save

 

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