Connection not Configured for this service ? Error While Calling Instant Microsoft Flow ?

Introduction:

In this Blog, we will see how to get rid of Instant Cloud Flow Connection Issue wile calling from PowerApps.

Implementation steps:

 

I have a PowerApps Application, in that While OnStart of the App am having an Instant Cloud Flow to check weather the User Exists in SharePoint Group or not and it will respond to PowerApps as true or false

 

If i Run this Application in Dev Environment am getting the flow triggered Successfully, when am moving from one Environment to another environment am getting Flow name : Connection not Configured for this service 

 

In Dev I have System Administrator Role hence I didn't face any issues.

In UAT am having only Basic User Access

 

Let's see how we can fix the issue

 

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

 

2. Click Gear Icon at the Top then Click Advance Settings 

 

 

 

3. Click Settings --> Security --> Select Security Roles 

 

 

4. Open Basic User --> Select Customization Tab --> Search for Process

 

5. Change the Read Access from User to Organization

 

 

 

6. Now Click Save and Close 

 

That's it 

 

Once after done this Refresh the Application, you won't get the Connection Issue Further 

Get OptionSet Text and Value Using Microsoft Flow

Introduction:

In this Blog we will see how to get OptionSet Text and Value using Microsoft Flow from MSCRM

Implementation Steps:

 

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

 

2. Click My Flows --> Click New Flows 

 

3. For this Demo we are using Instant Cloud Flows

 

 

 

4. Enter the Name and Select PowerApps and Click Create

 

5. Now Navigate to CRM and get an Account to Proceed further

 

From the Above Screenshot select the Account id and Have a look on the Industry Drop Down As well

 

6. Now Navigate to Microsoft Flow and Select Get a Row By id then Select the Entity and paste the Account id Copied from Point 5.

 

 

7. Now Initialize the Variable to get the Value of Industry

 

 

8. Now Save the Application Click Test and Run Test

 

9. Once you Ran the Application, you can see Number as Output, let's see how we can get the text from the Option Set Values

 

10. Expand the Get Rows and you will see ODATA File over there Search for Industry in the Body

 

 

11. Copy the Formatted Value like below

 

industrycode@OData.Community.Display.V1.FormattedValue

 

12. Now Frame the Query like below

 

outputs('Get_a_row_by_ID')?['body/industrycode@OData.Community.Display.V1.FormattedValue']

 

13. Create another Variable and paste the Expression from #12

 

Now Try Running the App and Check the Variable

 

 

Now you can see the Text from Option Set Values

 

That's it 

 

How to Get Count of Records for a List in Power Automate

Introduction:

In this Blog we will see how to get Count of Records using List Rows

Implementation Steps:

 

First I will navigate to my CRM Accounts and Check the Count of Records

 

As of now Currently am having 3 Records in Account Table

 

Microsoft Flows

 

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

 

2. Click My Flows --> Click New Flows 

 

3. For this Demo we are using Instant Cloud Flows

 

 

4. Enter the Name and Select PowerApps and Click Create

 

5. Once Page Loaded --> Select List Rows

 

 

6. Enter the Table Name as Accounts

 

 

7. Click Save and Click Test --> Select Manually --> Click Test --> Click Run Flow

 

 

8. Once Flow is Success you can see the Values over there then you can use Length to getting Count of Records

 

9. You can see the Count of Records

 

 

That's it 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

 

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

 

 

11. Now you can see the Error Message Occurred.

 

 

 

That's it 

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

 

 

4. Then select Advanced Permission Settings

 

 

5. Click Create New Group

 

6. Provide Name for SharePoint Group and Choose the Control

 

 

 

7. Once Done Open the Group and Copy the MemberShipGroupID

 

 

 

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

 

 

3. Enter the Flow Name and Select PowerApps

 

 

 

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

 

 

 

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

 

 

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

 

 

 

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

 

10. Now Add Parse JSON 

 

 

 

11. Input the Details

 

 

 

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