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 

Filter Email To/CC/BCC Column in Email Table

Introduction:

In this Blog we will see how to filter Email To/Cc/Bcc Fields in CRM/Model Driven Apps

Implementation Steps:

 

Consider if I have an Email Table with To/CC/Bcc Fields, but To Fields contains lots of Entities in it, But we need to Restrict to Some of the Entities alone

 

  

 

Here is the List of Entities with TO Fields,

 

 

Let's See how we can filter this Fields..

 

Steps to Follow :

 

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

 

2. Click Solutions --> Create a New Solution or open an Existing Solution

 

3. Click Add --> Select New Web Resource

 

4. Write Below Code and Save it..

 

function SetDefaultView(executionContext) {
var formContext = executionContext.getFormContext();
var customerControl = formContext.getControl("to");
if (customerControl.getEntityTypes().length > 1) {
customerControl.setEntityTypes(['account','contact']);
}
}

 

the Above code mentioned that we are taking the Control ("TO") and filtering the ENTITYTYPES only to ACCOUNT AND CONTACT Table.

 

5. Once Done , Call this Event in OnLoad of the Form once the Page Loaded you will see only 2 Entity Types with Account and Contact

 

 

That's it 

 

Using JavaScript we can Filter the TO/CC/BCC fields in Email table

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 

 

How to Increase File Column Size in Dataverse

Introduction:

In this Blog, we will see how we can increase size of File Column in Dataverse/MSCRM Environment.

 

Implementation Steps:

 

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

2. Select the Respective Environment

3. Click Solutions if you have any else click Dataverse and Select Tables

 

 

4. Click on Respective Table and Open it.

5. Click New --> Select Columns

 

 

6. Once Selected New Column it will open a Popup in that Select Data Type as File and Select File as an Option

 

7. On Selected Click Advance Settings to Increase file Size

      Default Size will be 32768

 

8. If we want to Increase the Default File Size you can increase the same in Maximum File Size Column.

 

9. Once Done Click On Save

 

That's it 

Create Filter Expression with AND & OR Condition in Model Driven Apps

Introduction:

In this Blog we Will see how to Use Filter Expression with Both And/Or Condition with Query Expression

Implementation Steps:

 

Consider a Scenario that I want to make Multiple Filter Condition with Both And/or Condition From Account Table Using Plugins

 

QueryExpression query = new QueryExpression("account");
query.ColumnSet.AddColumns("accountid");
FilterExpression filterAccount = new FilterExpression(LogicalOperator.Or);

FilterExpression filterName = new FilterExpression(LogicalOperator.And);
filterName.Conditions.Add(new ConditionExpression("NAME_LOGICALNAME", ConditionOperator.Equal, PASSYOURVALUEHERE));
filterName.Conditions.Add(new ConditionExpression("NAME_LOGICALNAME", ConditionOperator.Equal, PASSYOURVALUEHERE));

FilterExpression filterName2 = new FilterExpression(LogicalOperator.And);
filterName2.Conditions.Add(new ConditionExpression("NEWFIELD_LogicalName", ConditionOperator.Equal, id2));
filterName2.Conditions.Add(new ConditionExpression("NEWFIELD_LogicalName", ConditionOperator.Equal, id3));

filterAccount.AddFilter(filterName);
filterAccount.AddFilter(filterName2);

query.Criteria = filterAccount;

 

In the Above Example Am using Both And/OR Condition in FilterExpression with QueryExpression.

 

That's it 

How to use Terminate Operation in Microsoft Flows

Introduction:

In this Blog we will see how to use Terminate Operation in Microsoft flows

Implementation Steps:

 

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

 

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

 

3. Then it will show a popup input the name and Select PowerApps

 

4. In My demo am using Back End as SharePoint List.

 

5. If the SharePoint List Does not Contain Data Terminate the flow else process the flow

 

6. For that First use Get List and Get the Items from the List

 

 

 

7. Add a Condition and Check the Length of the List

 

 

 

8. If the Length is 0 then Terminate the flow (Click Add Step and Search for Terminate)

 

 

9. Once Added you can provide Your Own Status Code and Message 

 

 

 

That's it