Thursday, July 28, 2022

How to Enable Spell Check in Canvas PowerApps?

Introduction:


In this Blog, we will see how to Enable Spell Check in Canvas PowerApps.


Implementation Steps:

 

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

 

2. Click Apps --> Select New Apps --> Select Canvas

 

rampprakash_0-1659005545549.png

 

3. Once Selected it will Pop-Up Screen then Input Name and Click Create

 

rampprakash_1-1659005612754.png

 

4. Once Page Loaded --> Click Insert --> Select Text Input 

 

rampprakash_2-1659005690530.png

 

5. Then Run the Application and Input value as "Spel Check"

 

rampprakash_3-1659005821207.png

 

6. After Inputting the values you wont receive Spell Check Error in Text Box.

 

7. Lets See how we can Enable Spell Check for Showing Errors

 

8. Close the Run Mode and then Select the Text Field 

 

9. Then Select Enable Spell Check and Change it to True

 

rampprakash_4-1659006137555.png

 

 

10. Once Done Run the App and Click on the Field

 

rampprakash_5-1659006186545.png

 

11. Now you can see the Error Message Occurred.

 

rampprakash_6-1659006379598.png

 

 

That's it :slightly_smiling_face:

Tuesday, July 19, 2022

Get User from SharePoint Group using Power Automate

Introduction:


In this blog we will see how to get User from SharePoint Group.


Implementation Steps:

 

Create SharePoint Group:

 

1. Navigate to your SharePoint Website

 

2. Click Settings icon at the Top Right 

 

3. Then Select Site Permission

 

rampprakash_0-1658150063051.png

 

4. Then select Advanced Permission Settings

 

rampprakash_1-1658150127776.png

 

5. Click Create New Group

rampprakash_2-1658150162713.png

 

6. Provide Name for SharePoint Group and Choose the Control

 

rampprakash_3-1658150233322.png

 

 

7. Once Done Open the Group and Copy the MemberShipGroupID

 

rampprakash_4-1658150350337.png

 

 

in my case the ID is 10

 

Power Automate:

 

1. Now Navigate to https://flow.microsoft.com

 

2. Click My Flows --> Select New Flows --> For Now am selecting Instant Cloud Flows

 

rampprakash_0-1658226666373.png

 

3. Enter the Flow Name and Select PowerApps

 

rampprakash_1-1658226728281.png

 

 

4. Once page is Loaded then Select New Steps and Search for http (then select Send an HTTP request to SharePoint)

 

rampprakash_2-1658226838010.png

 

 

5. Once Selected Provide the URL and Method as GET and URI

 

rampprakash_3-1658227193746.png

 

URI : /_api/web/sitegroups/getbyid(SHAREPOINTGROUPID)/users

 

6. Save it and Test the Flow

 

7. Once Saved then Click Test and Run the Flow

 

8. Once Flow ran Success you can able to see the Output values

 

rampprakash_4-1658227343817.png

 

 

9. Now Copy the Output body and Provide in PARSE JSON

 

10. Now Add Parse JSON 

 

rampprakash_5-1658227631653.png

 

 

11. Input the Details

 

rampprakash_6-1658227675997.png

 

 

12. Then Click Generate from Sample then Paste the OUTPUT Copied from HTTP REQUEST

 

13. Now Initialize Variable as get User Principal Name

 

14. Then Set Variable and Select User Principal Name in the Set Variable

 

Note:

 

While Parsing if you face an Error try changing User Principal Values to String and null as well

 

rampprakash_7-1658228014422.png

 

 

Friday, July 8, 2022

Revoke Permission for Users to Edit in Dataverse tab

Introduction: 


In this Blog, we will see how to Revoke Permission for Users to Edit in Dataverse Tab.


Implementation Steps:

 

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

 

2. Click Dataverse --> Click Tables

 

rampprakash_0-1657275370571.png

 

3. After selecting tables you will have permission to Edit or Add new Tables or Customize it.

 

Let's see how we can avoid user to Customize here.

 

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

 

2. Click Gear Icon at the Top

 

3. Select Advance Settings --> Select Settings --> Security

 

4. Create a New Security Role or Open an Existing Security Role --> Navigate to Customization Tab and Remove Permission for the Values

 

rampprakash_2-1657275585414.png

 

 

5. Once Done Click Save and Close

 

6. Now Assign this Security Role to User (Make Sure there is no Other Security Roles having More Permissions)

 

7. Now Try Clicking the Dataverse you will get below error.

 

rampprakash_3-1657275675146.png

 

That's it :slightly_smiling_face:

Thursday, July 7, 2022

Download Images from Dataverse Image Column in PowerApps

Introduction:


In this Blog, we will see how to Download Image from Image Field from Dataverse using PowerApps


Implementation Steps:

 

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

 

2. Click Dataverse --> Select Tables

 

rampprakash_0-1657188061210.png

 

3. If you have table Already available Search that Table else create a Table and Open it

 

4. Now Click On Columns then Add a New Table Column with Type as Images

 

rampprakash_1-1657188160095.png

 

 

5. Click Save and add the Images into Respective Form(Click Forms --> Select Main Forms --> Open it --> Click Columns at the Left Side--> Search for the Created Column --> Add it to the form)

 

rampprakash_2-1657188357443.png

 

 

6. Now Open a Record and Store the Images

 

rampprakash_3-1657188427524.png

 

 

PowerApps:

 

Now Lets see how we can download this Images from Canvas PowerAppps

 

1. Copy the Logical Name of Table : In my case it is account (Logical name)

 

2. Copy the Image Field Name : In my case it is crc2a_image (Logical name should be in Lower Case)

 

rampprakash_5-1657188531980.png

 

3. Copy the Account Guid : In my case it is 8baca6c3-6deb-ec11-bb3d-000d3ac9b922 (you can pass dynamically as well)

 

4. Now Click on Apps then Click New Select Canvas and Provide Name and Select the mode as Phone or Tablet

 

rampprakash_6-1657188635106.png

 

 

5. Add a Button into Form and Write below Code

 

Download("https://org*****.crm8.dynamics.com/Image/download.aspx?Entity=account&Attribute=crc2a_image&Id=8baca6c3-6deb-ec11-bb3d-000d3ac9b922")

 

rampprakash_7-1657188813975.png

 

 

6. Change org*** to your Organization URL

 

7. Now Click on Download --> It will Open up a page with Image Loaded

 

rampprakash_8-1657188914562.png

 

 

That's it :slightly_smiling_face:

Wednesday, July 6, 2022

Encode and Decode String Using Microsoft Flow

Introduction:


In this Blog, we will see how to encode and Decode String using Microsoft flow


Implementation Steps:

 

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

 

2. Click My Flows --> Select New Flows and Select Instant Cloud Flows

 

rampprakash_0-1657090966404.png

 

 

3. Once Selected it will Open a Popup --> Input the Flow Name and Select PowerApps and Click Create

 

rampprakash_4-1657091097818.png

 

 

4. Now Click Add New Step

rampprakash_2-1657090966112.png

 

5. Search for Variable and Select Initialize Variable

 

rampprakash_5-1657091146734.png

 

6. Once Selected --> Input Name for that Variable --> Then Select Value and Select Expressions and input the value as 

 

 

encodeUriComponent('https://microsoftcrmtecie.blogspot.com')

 

 

rampprakash_6-1657091316561.png

 

encodeuriComponent --> Will help you the encode the string 

 

7. Lets Decode the Encoded String

 

8. Add a New Step --> Search for Variables --> Select Initialize Variable

 

9. Add a Name as Decoded Value and Select Value and Write Below Expression

 

rampprakash_7-1657091580394.png

 

10. Now Click Save --> Click Test --> Select Manually --> Click Test and Run Flow

 

rampprakash_8-1657091613041.png

 

11. Now the Flow Ran Successfully

 

rampprakash_9-1657091656877.png

 

 

12. Lets Expand and see the Values(In the Below Screen you can see first Variable is encoded one and Second is Decoded one )

 

rampprakash_10-1657091686364.png

 

That's it :slightly_smiling_face:

 

this is how we need to Encode and Decode String using Microsoft flow.

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