This series is all about creating components from other components. PCF maybe the best choice but it isn't always enabled and requires a different skillset.

The first in the series is all about creating a stack of notifications (very much like how this community site shows notifications).

In this article, we will learn how to get the first and last date of a month for a user selected date in the DatePicker control. There can be many use cases for such utility which provides first date and last date of the month corresponding to a user provided date. Example of such use cases can be Billing and Invoicing Systems, Event Scheduling, Report Generation, Due Dates and Deadlines for task or project management applications, Interest Calculation, Subscription Renewals.

This article shows how to obtain the number of records in a gallery (or a datasource) without asking user to scroll all the way to the bottom. It overcomes the limitation of 100 records count.

One challenge when creating a modern-looking canvas app is that we have a mixed usage of classic and modern controls, and you may notice that the text in modern controls appears smaller than in classic controls. To maintain visual consistency, we need to keep the font size consistent across all the app's controls

Introduction

One of the most common requirements while pushing the record in Dynamics 365 is to check whether a record is already present or not. If not, then create a new record else Update the existing record with updated information.

This requirement can easily be achieved through Power Automate as well, however today we shall learn how this can be achieved through PowerApps itself using Patch Function.

Basically, Patch Function is useful to perform following operations in any data source:

• Create (single or multiple) records
• Update (single or multiple) records
• Merge records

Now, I will use following two Patch function and Let's see what result I get:

Below syntax use to Create a record in Database Table:

Patch(Customers, Defaults(Customers), {ID: "3"}, {First Name: "firstnametext"}, {Job Title: "jobtitle_text"})

Below syntax use to Update the record in Customer Table where ID = 2:

Patch(Customers,First(Filter(Customers, ID = "2" ) ), { Job Title: "jobtitle" } )

Now, Let's understand this, by taking a very simple example from Dynamics 365 perceptive.

Scenario: I want to create a contact in Dynamics 365, If contact with same emailaddress is already present in Dynamics then only Update its details else Create a new contact record.

Step 1: Create a new Canvas App (ignore if you already have) > Connect to Dynamics 365 Data Source.> Connect to contact Entity.

Step 2: Insert a Blank Screen in order to add few Text Input and Button Controls or you can design the app as per your requirement.

Step 3: Insert a Success Screen to show Success Message, once the record gets Created/Updated in Dynamics 365

Step 4: Write following formula on Button Control (onSelect property)

If(IsBlank(

LookUp(Contacts,emailaddress1 =Emailaddress_Text.Text)),

Patch(Contacts,Defaults(Contacts),{'First Name':firstname_text.Text},{'Last Name':lastname_text.Text},{emailaddress1:Emailaddress_Text.Text},{'Home Phone':phone_text.Text}),

Patch(Contacts,First(Filter(Contacts,emailaddress1 =Emailaddress_Text.Text)),{'First Name':firstname_text.Text},{'Last Name':lastname_text.Text},{emailaddress1:Emailaddress_Text.Text},{'Home Phone':phone_text.Text})

);

Navigate(SuccessScreen,ScreenTransition.Fade);

Step 4: Run the App

No Contact records present in dynamic 365

Run canvas app in order to create contact record in dynamic 365.

Fill the details and click on Submit.

Record will get created in Dynamics 365 and Navigate to Success Screen.

A new contact has been created in Dynamics 365.

Now I am updating Last Name and mobile phone and Click on submit.

Submitted information in Dynamics 365 and Navigate to Success Screen.

Existing contact Record has been updated with updated Last Name and mobile phone.

Thank you..!

This article shows how to get Dataverse record for current logged in user from the systemuser table.

In this blog post, we'll delve into how organizations can harness the power of the Microsoft Translator Connector within PowerApps to seamlessly integrate multilingual capabilities, ensuring a smoother user experience across linguistic boundaries. 

Scenario

I recently came across the following scenario posted on the forums and I moved my response to this blog.

Do you need a simple way to create a custom ID that auto-increments and even resets at the beginning of the year?

Named Formulas allow you to create your own reusable properties within your app. Imagine defining custom calculations like a pro mathematician, but without the headache.  These formulas streamline initialization and enhance app performance. 

In today’s competitive job market, organizations receive numerous resumes daily. Manually reviewing each one can be time-consuming and prone to errors. In this blog, we’ll explore how to automate the resume screening process using Microsoft Power Automate. By leveraging its advanced capabilities, we can streamline the hiring process and identify the most promising candidates efficiently.

Ever wondered if you had the latest and greatest version of the Plugin Registration Tool (PRT) or Configuration Migration Tool (CMT)? And always had to Google Bing Copilot it to find and download the tool? You can now just pac it!

Are you looking to enhance the functionality of your Power Apps Portals and provide users with an intuitive way to view events and schedules? Look no further than leveraging the List Calendar View feature. In this article, we'll walk you through the steps to seamlessly integrate this dynamic calendar view into your portal.

With the List Calendar View in Power Apps Portals, you can transform a standard list of events into an interactive and visually appealing calendar format. Whether you're managing marketing events, training sessions, or project deadlines, this feature offers a streamlined way for users to stay informed and organized.

We'll start by guiding you through the process of creating a list within your Power Apps Portals environment, using the Event entity to store relevant information. From there, we'll demonstrate how to enable the Calendar View feature, allowing you to map essential fields such as Start Date, End Date, and Summary.

Once the calendar view is enabled, we'll show you how to seamlessly integrate it into your portal pages. Whether you're creating a new web page or updating an existing one, adding the calendar view component is a breeze, thanks to the intuitive interface of Power Apps Portals Studio.

But the customization doesn't stop there. We'll also provide tips on how to leverage custom entities to achieve unique calendar views tailored to your specific needs. Whether you're highlighting product releases, tracking customer appointments, or showcasing community events, the possibilities are endless.

By following our step-by-step guide, you'll empower your portal users with an engaging and user-friendly way to navigate events and schedules. From marketing professionals to project managers, everyone can benefit from the convenience and efficiency of the List Calendar View in Power Apps Portals.

So why wait? Unlock the full potential of your Power Apps Portals today and revolutionize the way your users interact with event data. Dive into our article and discover how easy it is to create dynamic calendar views that elevate the user experience and drive engagement.

I recently came across the following scenario posted on the forums and I moved my response to this blog.

The excitement around low code solutions and technological advancements has made everyone eager to see automation advances. Since we are technophiles and using low-code technology is our course of action, automating our process is not only an exciting but groundbreaking move for us. Even so, we need to take a moment to reflect and consider: Automation is undoubtedly beneficial, but is it necessary for everything to be automated? As digital automation becomes more prevalent, the dilemma of how to discern which jobs are appropriate for automation and which ones are not arises. We should not put off taking the initiative to search for indications of various parallels among these pointless initiatives.

In this Blog, we will see how to use Multilingual Language in Canvas PowerApps.

In this blog post we’ll explore how introducing a collection to our scanning approach can easily allow us to build our own ‘reset’ functionality for the Barcode Reader control.

I recently came across the following scenario posted on the forums and I moved my response to this blog.

Scenario:

When a user selects a record from a Gallery control, an Edit Form is automatically populated with the selected record. The user wants to be able to copy the existing record, make a change to one or more fields, and then submit the Form as a new record.

A login screen acts as a barrier between the content of your application and unauthorized users.

with the help of logging screen, you can have control on access and sensitive information and maintain integrity of application by making users to authenticate them.

Let’s get started with creating a login screen in PowerApps.

Step 1: Create a New App

Log in to PowerApps and navigate to the 'Apps' section.

Click on 'Create an app' and choose the 'Canvas app from blank' option.

Step 2: Design the User Interface

Once the new app is created, you can open the app using PowerApps Studio.

Design the login screen interface by adding two input fields for ‘Email id and ‘Password along with a ‘Login’ and ‘Register’ buttons.

You can add two text labels to text input boxes as shown in below screen.

Step 3: Connect to Data Source

Go to the ‘View’ tab and click on ‘Data sources’ à Add data and search for SharePoint, then click on Add a connection as shown in below screens.

Once connection is added you can able to find data source.

Step 4: Validate User Credentials

Double-click on the ‘Login’ button to open the formula bar.

Use the Lookup function to check if the entered username and password exist in your data source. The formula might look like:

If(!IsBlank(LookUp(EmployeeList, Email= TextInput1.Text And Password=TextInput2.Text).Title),Navigate(View_Screen_1),Navigate(Failed_Screen));

Reset(TextInput1);

Reset(TextInput2);

Step 5: Handle Navigation

If the credentials are valid, navigate user to your app main screen else navigate user to error scree.

 Login error screen :

Login successfully:

Step 9: Publish and Share

Once testing is complete, publish your app.

Hope this article help!

Streamlining Your Workflow: How to Bulk Download Attachment Files from a Dataverse Table from a Canvas Power Apps
Are you managing data in Dataverse tables, and do you have a canvas app for your end-users that they can use to download multiple attachments from these tables? The process can be time-consuming and complex. This blog post introduces a streamlined solution using a Power Apps formula, making your workflow more efficient.

Download Multiple Attachments from Dataverse table using a Canvas Power Apps! 

In this article we will first familiarize ourselves with the Left, Mid, Right and Find functions – the key building blocks required for text extraction. More importantly, we will explore ways in which we can combine these functions to meet our more complex, dynamic text extraction requirements.

In the realm of business, we often encounter a myriad of document formats containing vital information crucial for our organizational needs. From resumes and invoices to contracts and reports, the task of manually extracting relevant data can be time-consuming and prone to errors. However, in this article, we delve into a transformative solution: leveraging AI Builder models to streamline and simplify this process. Join us as we explore how effortlessly you can create and train custom AI models to extract information tailored to your business requirements.

In this blog we will see how to increase Do Until Loop in Microsoft Flow.

How to Make a Text Bold in Canvas App?

First, we need create simple form as show below using SharePoint list which has the following columns - Full Name, attachments inbuild column.

I recently came across the following scenario posted on the forums and I moved my response to this blog.

Scenario:

We have a SharePoint List which has three SharePoint LookUp Columns:

1. Country: configured in SharePoint as a Single-Select SharePoint LookUp column.
2. City: configured in SharePoint as a Multi-Select SharePoint LookUp column.
3. Town: configured in SharePoint as a Multi-Select SharePoint LookUp column.

We want to add these fields into an EditForm control, and cascade each Combobox selection according to the levels ordered above.

In this blog post we will more explore ways to append & remove a user from a multi-select SharePoint Person column via the Power Apps Patch function.

If you need more custom Icons in your app, this post is for you! We will use the Formulas and experimental feature of User Defined Functions to create custom lightweight icons which you can reuse throughout your app and adjust the colours using function parameters!