How to Use Multilingual Language in Canvas PowerApps

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

 

How to Install Smart Buttons for Ribbon Workbench using XrmToolBox

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 

 

How to Filter Gallery with SharePoint with Blank Values Without Delegation Warning

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 

How to get Quarters from Date in Canvas PowerApps

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 

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 

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