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'])

How to increase Do Until Loop in Microsoft Flow?

Introduction:

In this blog, we will see how to increase Do Until Loop Count in Microsoft flow.

Implementation Steps:

 

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

 

2. Click Flows --> Select Instant Cloud Flow (Depends on your requirement)

 

3. Input Name and Select PowerApps and Click Create

 

 

4. Once Page Loaded then Select Add Step and Search for DO UNTIL

 

 

5. Once Selected You will see an Option Called Change Limit

 

 

6. Expand that Change Limit, Initially the Limit Will be 60 ( Which means Do Until Loop only Run With 60 Counts/Records )

 

 

 

7. If you want to Run for More than 60 Counts/Records just increase the Count from 60 to Based on your Needs, if you want to set time out you can input the same in Timeout Value

 

 

That's it 

How to Publish Major Version in SharePoint using Microsoft Power Automate

Introduction:

    In this Blog we will see how to publish Major Version in SharePoint using Power Automate

Scenario :

 

Consider we have a Library to store Document. When we change Status the system should automatically publish to Major Version in SharePoint. 

 

Let's see how we can achieve this.

 

Implementation Steps:

 

1. Navigate to your SharePoint Site and select your Document Library

 

 

2. Click New and Create a new Document

 

 

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

 

4. Click My Flows --> Select New --> Input Name as "Publish Major SharePoint Document"

 

5. Select type as "When an Item is Created or file is modified"

 

 

6. Click Create

 

7. Once Page Loaded Select Site Address and Select List or Library

 

 

8. Now Initialize Variable and Name it as SharePoint Address then Type as String and Input your SharePoint Address

 

 

In my case SharePoint Address : https://forplugins.sharepoint.com/sites/DEMOSITE/

 

9. Add Another Variable With Type as String and Name it as Relative Path

 

 

here input the Value, in my case it is /site/LibraryName/

 

10. Click New Step and Search SharePoint

 

 

11. Then Select Send an HTTP request to SharePoint (Rename it as CheckOut)

 

 

Use Post Operation with URI as below

 

 

/_api/web/GetFileByServerRelativeUrl('@{variables('RelativePath')}@{triggerOutputs()?['body/{FullPath}']}')/CheckOut()

 

 

12. Now Add Another Step as Send an HTTP request to SharePoint (Rename it as PUBLISH)

 

 

Use Post Operation with URI as below

 

 

/_api/web/GetFileByServerRelativeUrl('@{variables('RelativePath')}@{triggerOutputs()?['body/{FullPath}']}')/CheckIn(comment='COMMENTS FOR PUBLISH',checkintype=1)

 

 

comments --> Mandatory to publish the file

checkintype --> Pass it as 1 for Publish

 

13. Now save Power Automate.

 

14. Make Some Change in the File like Add title etc

 

Once flow triggered Successfully then check the version history

 

 

You will see the Published Version.

 

That's it

 

Note:

 

For Publishing SharePoint we need Check out and Check in Mandatory.

How to Copy Schema and Logical name in PowerApps

Introduction:

In this blog, we will see how to copy Logical name and Schema name in Dataverse/MSCRM canvas.

Implementation steps:

 

1. Navigate to https://make.powerapps

 

2. Click Solutions --> Open Solution where the table is Available else CLICK DataVerse --> Click Tables and Open Table

 

3. Now Click On Columns

 

 

4. It will take you to all the columns where the field is Available

 

5. Now Select One of the Field and then you can see a Button Will get Enable called TOOLS

 

 

 

6. Click on the Tools you will see two options called Copy Schema Name and Copy Logical Name

 

 

 

What is the Main Difference Between Logical name and Schema Name?

 

• Schema name --> It will be in Casing in my Case Schema Name will be pac_AccountId
• Logical name --> It won't be in Casing in my Case Logical Name will be pac_accountid

 

That's it