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 

Using Force Sync User to sync users – Power Platform / Dynamics 365

Introduction: 

In this Blog we will see how to Force Sync Users using Microsoft Flow with Dataverse environment.

Implementation Steps:

 

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

 

2. Search Users

 

3. Search User Name

 

 

4. Once the User page Loaded, search for Object ID, if the Object ID is Not Available, Click Edit Columns and Add OBJECT ID

 

 

 

5. Copy the GUID(Object ID) and Paste it in Notepad

 

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

 

7. Click My Flow --> Select New Flow --> Select Instant Cloud Flow

 

8. Enter the Name and Select PowerApps

 

 

 

9. Once Select Click Create --> Once Page Loaded select Add Steps --> And Search for Power Platform For Admins

 

10. Search for Force Sync Users

 

 

 

11. Once Force Sync User selected it will ask you for Environment and Object ID

 

 

 

12. Input the Details and for Object ID (Select Ask in PowerApps)

 

13. That's it.. Now Click on Save --> And Click Run and Select Manually --> Click Test --> Click Continue

 

14. Now it will ask for Object id, Paste the Object ID from Point 5

 

 

 

15. Click Run Flow --> Click Done

 

 

16. Once done, you can check the synced user  in your environment.

 

That's it 

 

Convert String to Number using Power Automate

Introduction:

In this Blog we will see how to convert String to Number using Power Automate

Implementation Steps:

 

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

 

2. Click My Flows --> Click New Flow --> Select Instant Cloud Flow (You can select based on your needs)

 

 

3. Input Flow Name and Select PowerApps as Trigger

 

 

 

4. Click Create

 

5. Click Add Step --> Search for Variables --> Select Initialize Variable --> Input Name and Select Type as String and Value as "10"

 

 

6. Then Again Click Add Step and Select Initialize Variable Again and Input Name and Select Type as Integer

 

 

7. Write below Expression to Convert string to Integer 

 

int(variables('STRING Values'))

 

 

8. Click Save --> Click Test (at the Top Right)

 

9. Select Manually --> Click Test --> Click Run Flow --> Then Click Done

 

 

10. That's it 

Change Radio Button Layout from Vertical to Horizontal in Canvas App

Introduction:

In this Blog we will see how to Change Radio Button layout from Vertical to Horizontal in Canvas App.

Implementation Steps:

 

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

 

2. Click Apps

 

3. Click New Apps --> Select Phone or Tablet Mode

 

4. Input Name for the Apps and Click Done

 

5. Once the Page Loaded --> Click Insert and Radio Button

 

 

 

6. Once the Radio button added the LAYOUT for the Radio button will show in Vertical Manner

 

 

7. Now if I want to change it to Horizontal Manner --> We need to Select Layout as Horizontal

 

Change Value From :

 

 

 

To:

 

 

 

That's it 

How to Set Model Driven App theme in PowerApps Canvas

Introduction:

In this Blog we will see how to set Model Driven App theme in PowerApps Canvas

Implementation Steps:

 

Model Driven Apps:

 

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

 

2. Click Gear Icon at the Top --> Select Advance Settings 

 

3. Once the Page Loaded --> Click Customization --> Select Theme --> You will see Default Theme ( You can see only one default theme for an Application)

 

COPY THE NAME OF THEME

 

 

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

 

5. Click App --> And Provide the Name for the App and select Tablet or Phone Mode based on your needs --> In this i have selected Tablet Mode

 

 

6. Click DataSource --> Select Theme DataSource

 

 

7. Once the DataSource Added In the On Start of App Paste the below code

 

Set(getThemeValues,LookUp(Themes_1,'Default Theme'='Default Theme (Themes_1)'.Yes));

 

1. Get the Value from Lookup in Theme with Default Theme as Yes

 

8. Add Multiple Labels in the Form

 

 

9. Now Based on the Theme we can load the values(getThemeValues)

 

10. Now Add one by one to the LABEL : FILL and Label Text

 

 

ColorValue(getThemeValues.'Legacy Accent Color')
ColorValue(getThemeValues.'Navigation Bar Fill Color')

 

11. Based on the Above code we can use the color in different places according to Model Driven App

 

Final Output

 

 

 

That's it 

 

What's my IP for Microsoft Flow?

Introduction:

In this blog, we will see how to Retrieve IP Address for Microsoft Flow

Scinario:

 

I want to get Response from WebService, that service is restricted to some of the IP Address. I need to get that Service Using Microsoft Flow, So i need to get IP Address of Microsoft Flow to add that IP Address manually to service to get the values.

 

Let's see how we can achieve this.

 

 

Implementation Steps:

 

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

 

2. Click New App --> Select Instant Cloud Flow

 

 

 

3. Input Name For the Flow and Select PowerApps

 

 

4. Select HTTP Trigger

 

 

5. Select Method as GET and Input URI as

 

 

 

https://api.ipify.org/?format=json

 

 

 

6. Now Save the Flow 

 

7. Click Test at the Top Right and Select MANUAL trigger --> Select Run Workflow

 

That's it 

 

 

 

8. You can see the IP address in BODY of result.