cancel
Showing results for 
Search instead for 
Did you mean: 

Join the discussion

Most Recent
maqsoftware
Regular Visitor

In this blog post, we will talk about how organizations can make the most of pipelines. Pipelines help teams adopt automated ALM practices more easily, cutting down on the effort and expertise needed to see results.

Read more...

SebS
Super User
Super User

🚀 Revolutionize Your Invoice Management Workflow! 📧💼

Discover how to seamlessly send emails with PDF attachments using Office365 Outlook while simultaneously updating attachments in SharePoint Lists. Our step-by-step guide, coupled with visual references, ensures efficiency and accuracy in your invoicing process. Say goodbye to manual tasks and hello to a streamlined workflow! Stay tuned for the ultimate integration journey. Coming soon! 🎉 #InvoiceManagement #Office365 #PowerApps #SharePoint

Read more...

c_stringham_
Helper I
Helper I

Are you an MSP looking to revolutionize the way you communicate with your clients? Discover how to leverage the Microsoft Power Platform and SendGrid to create a dynamic, cost-effective notification system that’s easy to use and maintain. Say goodbye to additional contact lists and hello to customizable, streamlined messaging. Don’t miss out on this game-changing approach—read on to transform your MSP communications now! 

Read more...

wyattdave
Responsive Resident
Responsive Resident

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.

This blog is all about making a multi list sorter (mainly designed for mobile devices)

Read more...

LaurensM
Super User
Super User

Ah, the good old If & Switch conditional statements! One of the first Power Fx functions you’ll familiarize yourself with when working with Canvas Apps.

 

In this blog post we’ll shortly familiarize ourselves with the Power Fx If and Switch functions. More importantly, we’ll look at some tips & tricks to easily improve code readability and scalability.

Read more...

SebS
Super User
Super User

Creating dynamic content in Power Apps can significantly enhance user experience, especially when generating documents like invoices. In this guide, we will walk through the steps to create a dynamic invoice using string interpolation and mimic CSS styles using variables.

Read more...

rampprakash
Super User
Super User

This blog post will guide you through the process of running asynchronous plugins or workflows in your Dataverse environment.

Read more...

Rahman1005
Advocate III
Advocate III

In this article I will show you how to make a tabbed form. We will create form tabs we place a tab list control above a form and show/hide its input fields based upon the current selection.

We need to enable modern controls in your app. Click on Settings > General and search for "modern". Enable the Modern controls and themes feature.

Please fellow below screen shots.

Rahman1005_0-1715861140400.png

 

 

Rahman1005_1-1715861140403.png

 

 

Setup The SharePoint List:

Create a new SharePoint list called Employee information with the following columns:

Employee Name (single-line text)

Employee Id (single-line text)

Department (single-line text)

Mobile Phone (single-line text)

Email Address (single-line text)

Address (single-line text)

Additional Information (multiple-line text)

 

Rahman1005_2-1715861140405.png

 

 

Navigate to https://make.powerapps.com/ and Open Power Apps Studio and create a new app from blank. Add a text control onto the screen to show the title “Contacts.” Then insert a tab list control.

 

Rahman1005_3-1715861140408.png

 

 

On item property of the tab list control write below code.

["General", "Contact Info", "Location", "Additional Information"]

 

 

Rahman1005_4-1715861140409.png

 

 

Add An Edit Form Control:

 

Add new form control directly below the tab list to display the Employee data.

 

Rahman1005_5-1715861140412.png

 

 

 

 

Add the employee information data source to the app then use this code in the Items property of the form.

Rahman1005_6-1715861140415.png

 

We need to write logic on fields to Show/Hide Fields on the Form.

 

On select of "General" tab we want to show the following cards and hide the rest, select the cards and write code on visible property, prefer below screen short.

 

TabList1.Selected.Value="General"

 

  • Employee Name
  • Employee Id
  • Department

 

Rahman1005_7-1715861140419.png

 

 

 

On select of "Contact Info" tab we want to show the following cards and hide the rest, select the cards and write code on visible property, prefer below screen short.

  • Mobile Phone
  • Email Address

Rahman1005_8-1715861140421.png

 

 

On select of "Location" tab we want to show the following cards and hide the rest, select the cards and write code on visible property, prefer below screen short.

  • Address

Rahman1005_9-1715861140424.png

 

 

Save the canvas app and publish the apps.

Final screens.

Rahman1005_10-1715861140425.png

 

 

Rahman1005_11-1715861140426.png

 

 

Rahman1005_12-1715861140427.png

 

 

Rahman1005_13-1715861140428.png

 

 

Thank you..!

markinwaukesha
Advocate I
Advocate I

There are many advantages to utilizing stored procedures such as: reducing application complexity, improving speed by executing at the database level rather than on the client side, eliminating the record limit and using design patterns to improve the overall architecture. 

I'll share my journey into using Stored Procedures and I hope it will help either excite you into trying them or assist you with any blockers you may have with using them.  

Read more...

wyattdave
Responsive Resident
Responsive Resident

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).

Read more...

happyume
Multi Super User
Multi Super User

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.

Read more...

happyume
Multi Super User
Multi Super User

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.

Read more...

TuongDoan
Responsive Resident
Responsive Resident

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

cover_fontsize1.png

Read more...

Rahman1005
Advocate III
Advocate III

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.

Rahman1005_12-1714372904603.png

 

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.

Rahman1005_13-1714372904606.png

 

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

Rahman1005_14-1714372904608.png

 

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);

 

Rahman1005_15-1714372904613.png

 

Step 4: Run the App

No Contact records present in dynamic 365

Rahman1005_16-1714372904615.png

 

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

Rahman1005_17-1714372904616.png

 

Fill the details and click on Submit.

Rahman1005_18-1714372904617.png

 

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

Rahman1005_19-1714372904618.png

 

A new contact has been created in Dynamics 365.

Rahman1005_20-1714372904620.png

 

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

Rahman1005_21-1714372904621.png

 

Submitted information in Dynamics 365 and Navigate to Success Screen.

Rahman1005_22-1714372904622.png

 

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

Rahman1005_23-1714372904624.png

 

Thank you..!

happyume
Multi Super User
Multi Super User

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

Read more...

maqsoftware
Regular Visitor

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. 

Read more...

Amik
Super User
Super User

Scenario

 

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

Read more...

JR-BejeweledOne
Super User
Super User

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

Read more...

SpongYe
Super User
Super User

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. 

Read more...

sandeepstw
Super User
Super User

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.

Read more...

EricRegnier
Most Valuable Professional
Most Valuable Professional

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!

Read more...

Surendran_R
Advocate III
Advocate III

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.

Read more...

Amik
Super User
Super User

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

Read more...

Joseph_Fadero
Continued Contributor
Continued Contributor

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.



Read more...

rampprakash
Super User
Super User

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

Read more...

LaurensM
Super User
Super User

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.

Read more...

Amik
Super User
Super User

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.

Read more...

Rahman1005
Advocate III
Advocate III

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.

Rahman1005_0-1710161762178.png

 

 

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.

Rahman1005_0-1710506025550.png

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

Rahman1005_1-1710506057606.png

 

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);

 

Rahman1005_4-1710161762189.png

 

 

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 :

Rahman1005_5-1710161762190.png

 

Login successfully:

 

Rahman1005_2-1710506082242.png

Step 9: Publish and Share

Once testing is complete, publish your app.

Hope this article help!