Category: Canvas Apps

Search for multiple fields in Combo Box

Akanksha GuptaLeave a comment

By default, we can display only one field in Combo Box and Search for only one field in Combo Box.

There is a requirement to display multiple fields and also search for multiple fields in Combo Box. For example, we have EmployeeDetails as the Data should display Employee Name and Employee Email ID and can also search the record using same.

Modify below parameters of ComboBox:

Items: EmployeeDetails
DisplayFields: ["EmployeeName","EmployeeEmailID"]
SearchFields: ["EmployeeName","EmployeeEmailID"]

We can use this for ID and Definition Column types as well.

Get details of the new item created

Akanksha GuptaLeave a comment

When we want to get the details of latest created or updated item using SubmitForm, we use Form1.LastSubmit

Below is an example of Employee Details table.

  • Form Name: frmEmployeeDetails
  • Column Names in Employee Table: ID, Name, Address, Phone, Designation, PrimarySkill
SubmitForm(frmEmployeeDetails);
UpdateContext({newItem: frmEmployeeDetails.LastSubmit.ID})

This way, you can also fetch other details of the last submitted record, e.g., frmEmployeeDetails.LastSubmit.Name, frmEmployeeDetails.LastSubmit.Address etc.

What is DLP?

Akanksha GuptaLeave a comment

Data Loss Prevention (DLP) policies help users to prevent accidently exposing organizational data.

  • Scope: Environment Level OR Tenant Level.
  • Tenant level policies: Scope can be all environments, selected environments, all environments except ones you have specifically excluded
  • Classification of Connectors: Business, Non-Business, Blocked.
  • Business Connectors host data that is used by the business/organization.
  • Non-Business Connectors host data that is used for personal purpose
  • Connectors that are restricted and should not be used across one or more environments are classified as Blocked.
  • Default classification for a connector for new policy is Non-Business. Admins can move connectors from this category to other categories based on business preference.
  • DLP policies can be modified from Power Platform Admin Center
  • DLP policies affect Canvas Power App and Power Automate flows.
  • You should be a Tenant Admin OR Environment Admin to create DLP Policy.

People Picker in Canvas Apps

Image Akanksha GuptaLeave a comment

Insert a People Picker in Canvas Power App using Combo Box. Below are the steps: Add Office 365 Users Data Source. Add a Combo Box. Click on Edit Fields on Properties Bar. Select Person as the Layout. To pre-populate the Combo Box with the existing value, write below code in DefaultSelectedItems property. RequestSubmittedByEmail and RequestSubmittedByName […]

Check if a Table in Data Source is empty

Akanksha GuptaLeave a comment

To check whether a table in data source is empty or not, use IsEmpty

IsEmpty(tableName)

This is equivalent to CountRows(tableName)=0

We cannot use CountRows() directly on data source as it generally gives Delegation warning (Depends on the Connector)

If IsEmpty(tableName) returns true, this indicates that your Data Source table has no rows.

Add new line in Text

Akanksha GuptaLeave a comment

There are times when we want to add a new line in a text to be displayed in Label.

Use Char(10) to insert a new line in Label like shown below.

Add new line in Label

Use <br> to insert a new line in HTML Text Input like shown below.

Add new line in HTML Text Input

Convert values selected from Combo Box to a Comma separated string

Akanksha GuptaLeave a comment

I have a Combo Box with dummy values A, B, C , D and multi-select On. I want to select multiple values and display them in a Label as comma-separated string

For this, we can use function Concat. Below is an example for the same

As these are hardcoded values in Combo Box, I took Value in Concat function.

If you are getting these values dynamically, you can also use Result.

Calculate Start Date and End Date of Current Month

Akanksha GuptaLeave a comment

Below is the formula to Calculate Start Date and End Date of current month

Month Start Date

UpdateContext({
   monthStartDate: 
   Date(
     Year(Now()), Month(Now()), 1)
   )
})

Month End Date

UpdateContext({
   monthEndDate:
   DateAdd(
     DateAdd(
        Date(Year(Now()), Month(Now()),1),
        1, Months
     ),
     -1, Days
   )
})