Send an Email With Line Breaks From Share Point List : Multi-Line Column ​

Introduction:

In this Blog, we will see how to send email with Line Breaks from Share Point List using Multi-Line Column.

Implementation Steps:

First you need to Create a Multi-Line Text in Share Point List

SharePoint List :

1. Open SharePoint Site 

2. Click Add Column

3. Select Multiple Lines of Text

4. Click Create

 

 

Power Automate:

 

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

2. Create a new Flow

 

 

Now Create a Record in SharePoint List and Save it

 

 

Once Saved the Microsoft Flow will trigger and you can see the Email in your Inbox

 

 

 

Now Compared with Email and SharePoint List Record Creation the email not came with Line Breaked. Lets see how we can achive this.

 

Steps to Follow to Achive:

 

Create a Power Automate flow 

Steps :

1. When a Record is Crated

2. Initialize Variable to get the Multiple Line Text

 

3. Encrypt the Step 2

4. Now Use Replace Option to Replace '%0A' with '<br>'

5. Now Decrypt the Variable

6. Now Send an Email

 

Create a new Record in SharePoint List and Check the Email

 

That's it 

How to Fix Microsoft Flow Error : Request to Azure Resource Manager failed with error: '{'error':{'code':'InvokerConnectionOverrideFailed','message':'Could not find any valid connection for connection reference name 'shared_excelonlinebusiness' in APIM tokens header.'}}'.

Introduction:

In this Blog we will see how to fix Microsoft Flow error - InvokerConnectionOverrideFailed

Implementation Steps:

 

Consider while creating a new Power Automate Flow which contains Excel or SharePoint. Once After you done with your flow while triggering/testing the flow sometimes you will get Request to Azure Resource Manager failed with error: '{"error":{"code":"InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared_excelonlinebusiness' in APIM tokens header."}}'. this error.

 

 

 

Why this Issue Occurs?

 

This is Because the While Creating the Flow you are trying to add a new Connection within the flow like Adding an Excel (it will automatically create a Connection or SharePoint etc.,.)

 

How to Resolve this Issue?

 

There are Couple of Ways we can Resolve this Issue

 

Resolution 1 - Below Steps need to be Performed Once the Flow Gets Created : 

 

Once the flow gets Created 

 

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

 

2. Click My Flows 

 

3. Select the Flow and Click on RUN

 

 

4. Once You Click on Run it will Load the Popup with Respective Connections ( All the Connection with Current Microsoft Flow is Required) 

 

 

 

5. Once after it is Success you are Good to Trigger the Flow.

 

Refresh the Screen and Start Working 

 

Resolution 2 - Below Steps need to Be Followed before Flow Gets Created:

 

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

 

2. Click on Data --> Select Connections

 

 

3. Click New Connections

 

 

4. Search for the Respective Properties Item to Use (like Excel, SharePoint, Dataverse etc.,.)

 

 

5. Select the Respective Item --> Once Selected it will Show you a Popup to Create a Connection

 

 

6. Click Create

 

7. Once After You done this you are food to Create Microsoft Flow, now if you try to add a new connection it will Automatically fetch it from the Respective Connections which we have created.

 

That's it 

 

Create an Excel using Microsoft Flow - SharePoint

Introduction:

In this blog we will see how to create an Excel using Microsoft Flow SharePoint. 

Implementation Steps:

 

1. Navigate to Your SharePoint Site.

 

2. Click Documents or Open Your Document Library

 

3. Click New and Select Excel Work Book

 

 

4. Once Selected it will Open a Page in Different Window

 

5. Create a Column and Frame a Table (Optional)

 

 

 

6. Once Done Rename the Excel File (Optional). Here i renamed it as Parent Document.xlsx

 

7.  Now Navigate to https://make.powerautomate.com

 

8. Click My Flows --> Select Instant Cloud Flows --> Provide Name for the flow --> and Select PowerApps

 

 

9. Once Click on Create it will open a Page

 

10. Now Select Add Step and Search for SharePoint 

 

 

 

11. Once Selected It will Create a Connection --> Then Select GET FILE CONTENT USING PATH

 

 

12. Once Selected input the Site URL and Path of our Excel File

 

 

 

13. Once Done --> Click Save and Test --> Automatically --> Run Flow

 

14. Once it is Success you will get File Content

 

 

15. Now Click on Add Steps --> Search for Compose --> And Paste the Content from GET FILE CONTENET USING PATH

 

 

16. Once Done --> Create a New File with the Same File Content 

 

17. Click Add New Step --> Select Create File --> Input Site Address, Folder Path(where to create a new file), File name and Content from Compose

 

 

18. Once Done Click Test and Run the Flow

 

 

19. if the Flow Ran Successfully, Navigate to SharePoint to View the New File

 

 

20. Now here you can see the New File Copied Successfully --> Open the File to Check the Columns

 

 

 

That's it  This is How we need to Create an Excel using Microsoft Flows with SharePoint

 

Video For your Reference : https://youtu.be/z-86xSgghTI

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