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

 

 

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

 

 

 

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.

 

 

That's it 

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

 

 

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

 

 

 

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)

 

 

 

6. Now Open a Record and Store the Images

 

 

 

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)

 

 

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

 

 

 

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")

 

 

 

6. Change org*** to your Organization URL

 

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

 

 

 

That's it 

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

 

 

 

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

 

 

 

4. Now Click Add New Step

 

5. Search for Variable and Select Initialize Variable

 

 

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

 

 

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

 

 

 

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

 

 

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

 

 

11. Now the Flow Ran Successfully

 

 

 

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

 

 

That's it 

 

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

Convert UTC to IST time zone Using Microsoft Power Automate

Introduction:

In this Blog, we will see how to convert UTC to IST Time Zone Using Microsoft Flow

Implementation Steps:

 

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

 

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

 

 

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

 

 

4. Now Click Add New Step

 

5. Search for Compose

 

6. Now Select the Data Operation (Compose)

 

7. Once Compose Added add an Expression called utcNow() and Click OK

 

 

8. Again Click on Add Step and Add another Compose to Convert UTC to IST TimeZone

 

 

convertFromUtc(utcNow(),'India Standard Time')

 

Add the Above Query in the Expression and Click Ok

 

9. Now Save the Flow and Click Test

 

 

 

10. In the Test flow--> Select manually and Click Test

 

 

11. Then Select Run Flow and Click Done

 

 

 

12. Now all the Steps Ran Successfully

 

Expand the Respective Steps to View the Time Difference

 

 

 13. Now you can see the difference, first Compose showing UTC and Second Compose 2 Showing UTC to IST Conversion

 

You can Rename it for Better Understanding as well

 

That's it 

Get the Length from List Rows using Microsoft flow

 Introduction:

In this blog, we will see how to check length of List Rows in Microsoft flow.

Implementation Steps:

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

2. Click My Flows

3. Select New Flow --> Select Instance Cloud Flow 

4. Input Name and Select PowerApps

5. Click Create 

In this Scenario, i will pass a name filter in Account to check how Many Records Available

6. Click New Step --> Select Dataverse

7. Input Table name as Account --> and Expand and input filter as name eq demo

8. Now Click Add Step --> Select Condition --> Click on the Condition and Select Expression

9. Input as length of Values

10. Click OK then Select Is equal to (based on your needs) and input number

11. Now Save and Run to see the result

if the condition is satisfied it will given you true, else it will return false.

That's it

TO check the Length simply use

length(outputs('List_rows')?['body/value'])