Introduction:
In this Blog we will see how to Run Microsoft Flow for Every one Month.
Implementation Steps:
1. Navigate to https://make.powerautomate.com
2. Click My Flows at the Left Side
3. Click New Flows and Select Scheduled Cloud Flows
4. Once Selected it will prompt a page there enter the Name of the Flow and Select the Date on when to trigger and Select the Repeat every 1 MONTH
That's it 
Introduction:
In this Blog, we will see how to use multilingual language in Canvas PowerApps
Implementation Steps:
1. Open an Excel and Create Data Like Below and Save the Excel.
2. Now Navigate to https://make.powerapps.com
3. Click Apps
4. Click New Apps --> Page Design
5. Click Data Source at the Left Side and Search for IMPORT FROM EXCEL
6. Now Select the Excel from your Saved Location
7. Once After Selected the Excel you will see the Data Gets added Successfully in the PowerApps
8. Now in On Start of App write Below Code to get the Lanaguage of User (based on Broswer)
Set(
getCurrentLanguageofLoggedinUserBrowser,
Coalesce(
Lower(
Left(
Language(),
2
)
),
"en"
)
)
9. Now Add 3 labels (Click Insert and Click Labels)
Write Below Code
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Approved Leave").Text
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Pending Leave").Text
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Rejected Leave").Text
10. That' it . Now will run the PowerApps
11. For English
12. For Arabic
Introduction:
In this blog we will see how to install Smart Buttons for Ribbon Workbench using XRMToolBox
Implementation Steps:
1. Navigate to https://make.powerapps.com
2. Click Solutions
3. Select Import Solutions and import Ribbon Work Bench (Download here)
4. Once Solution Imported then Click Gear Icon at the Top and Select Advance Settings
5. Select Solutions --> You will find Ribbon Work Bench
6. Click the Ribbon Work Bench it will open PopUp like below
7. At the Left side you can see the Smart Button but it does not contain any values
Let's see how to show SMART Buttons
8. Now Click Below Link
https://ribbonworkbench.uservoice.com/knowledgebase/articles/896958
9. Once You Opened Link you will find another Link
https://github.com/scottdurow/RibbonWorkbench/releases
10. Once you clicked on Above Link you will redirect to Github and Download the Highlighted Solution
11. Now again go to Solutions (Follow Point 1 and 2)
12. And Import Solution downloaded from Point 10
13. Select the Solution and Click Import
14. Now again go to Legacy Mode and Click on Solutions and Select Ribbon Work Bench Again
15. Once page loaded you can find the Smart Buttons.
That's it 
Introduction:
In this Blog we will see how to Filter Gallery with SharePoint with Blank Values Without Delegation Warning.
Implementation Steps:
In this Blog am using Back End as SharePoint.
1. Navigate to https://make.powerapps.com
2. Click Apps
3. Select Canvas App and Select Type as Either Phone Mode or Tablet Mode and input Name
4. Click Create
5. Add Data Source (Here in my scenario am selecting Data Source as SharePoint)
6. Add Gallery and Select Items as SharePoint
7. Now Select the Items as SharePoint List
8. Now Consider I need to filter the Title as Blank without Delegation Warning
9. If i use IsBlank then it will cause Delegation Warning
Delegation Code : Filter('Account List - New',IsBlank(Title))
10. Based on Below Code we can avoid Delegation
Non-Delegation Code: Filter('Account List - New',Title = Blank())
That's it
Introduction
In this Blog we will see how to get Quarters from Date in Canvas PowerApps
Implementation Steps:
1. Navigate to https://make.powerapps.com
2. Select Apps --> Select New App --> Select Canvas
3. Once Page Opened Input the name and Select Tablet or Phone depends on your requirement, from my end am selecting Tablet Mode
4. Once Page Get Opened --> Add a Label by Selecting (Insert --> Label) and Add a Button as Well
5. Now Select the Button and go to OnSelect and Write below code Logic
Code For Converting Date to Quarter
If(
Month(Now())<=3,
Set(getQuarterFromDate,"1"),
Month(Now())>=04 && Month(Now())<=06,
Set(getQuarterFromDate,"2"),
Month(Now())>=07 && Month(Now())<=09,
Set(getQuarterFromDate,"3"),
Month(Now())>=10,
Set(getQuarterFromDate,"4")
)
6. Now Set the Default Value to getQuarterFromDate
7. Now Click on the Button
You will see the Current Quarter Value there.
That's it 
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 
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 
