This is an issue that has been the subject of many questions and below is the series of processes which I believe adequately addresses the structure needed.

Firstly, the three initial things to do (which I will not go into any depth with) are: -

• Configuring any SharePoint views to display only the columns you want all users to see and
• Filtering the View data so that it displays only the records you want available for choosing. I am assuming here that the users need to see records other than those they created.
• Configuring the Integrated App to restrict the users (or the particular user) to only be able to do and see what they need to.

Then however we are left with a number of inbuilt SharePoint functions that allow a reasonably knowledgeable user to circumvent these controls and do/see things you do not want them to.

In today's data-driven world, we often need to extract valuable information from various sources, including images and PDFs. Power Automate and AI Builder offer a powerful solution for extracting text from these documents, enabling businesses to streamline processes and gain insights from previously unstructured data. 

In this Blog, we will see how to enable Copilot for End Users in Canvas PowerApps

Often there will be a need to create a Form with a repeating section and typically, this can be achieved with a Gallery control.

Suppose on the other the hand that your requirement is a bit simpler. Your data source has multiple number columns for example, and you want to hide/show those columns in a set order based on an “Add” button.

In this blog post we will learn how to leverage the vertical container control to allow galleries to scroll in both directions regardless of gallery type.

In this Blog we will see how to change help URL in Microsoft Dataverse

Do you want to learn how to customize and control your autonumber-fields in Dataverse with Power Automate? In this blog post, you will discover how to use the SetAutoNumberSeed unbound action to reset or change the seed number based on your needs.

When working with the new tab list control you may have stumbled on the fact that this control does not contain native reset capabilities. As modern controls are a new set of controls, certain features present in the classic controls are currently not available in the modern variant. At the time of writing, modern controls are in preview and not meant for production use.

A common tab list question on the Power Apps Community forum, is how to reset the control or how to change tabs based on an action from another control. In this blog post we will be exploring some workarounds to reset the tab list and dynamically change the default selected tab.

TAB LIST RESET FUNCTIONALITY

The modern tab list is currently defined as a non-resettable control. As you quickly scan through the property dropdown, you notice that the ‘Reset’ property is missing. When trying to reset the control via the Reset() function, you receive the error ‘The function expects a resettable control as its input’.

Luckily, we can work around this limitation by using a variable. This variable will keep track of the currently selected tab and provide reset-like functionality by setting the variable back to the initial tab / value.

ADDING THE TAB LIST

Add a tab list to your Power Apps Canvas screen by (1) selecting ‘Insert’ in the top header, (2) opening the ‘Modern Controls’ tab and (3) clicking on the ‘Tab list’ control. In our scenario, I will create a tab list with ‘Cats’, ‘Dogs’ and ‘Other pets’ as separate tabs. The tabs can be defined by adding an array of text values in the Items property.

["Cats", "Dogs", "Other pets"]

TRACKING THE TAB LIST STATE

In order to keep track of the selected tab, let’s create a context variable that captures the tab changes. The OnSelect of the tab list should look as follows:

UpdateContext({locTab: Self.Selected})

The variable keeps track of the state but we will need to reference this value in the DefaultSelectedItems property in order for the tab to visually change.

locTab

In order to avoid a blank variable value during a new Power Apps session, define a default value in the OnVisible of that screen.

UpdateContext({locTab: {Value: "Cats"}})

Note: Should you want to change the tab state across screens or define the default value within the app OnStart, use a global variable instead.

RESET THE TAB LIST CONTROL OR NAVIGATE TO A SPECIFIC TAB

Now that we’ve defined our tab variable and a default value, you can reset the control or navigate to a specific tab by simply changing the variable value. In order to reset the control you will have to set the variable back to the initial tab value – similar to our OnVisible code.

Example of specific tab nagivation: After pressing a button I would like the tab list to automatically change to the Dogs tab – my second tab. The OnSelect of that button would have to contain the following code:

UpdateContext({locTab: {Value: "Dogs"}})

FINAL RESULT

As a closing note, the modern controls are still in preview and thus continiously being improved upon. A dedicated forum thread has been opened on the Power Apps Community forum for feedback. I have provided feedback on the Reset capabilities – feel free to give it a thumbs up.

If you liked this blog post, feel free to give it a like. | For more tips and tricks check out my blog (LaurensM).

Scannable invoices are an important part of the accounts payment process because they make it easier to process and find paper invoices. As companies deal with more and more bills, it becomes clear that they need to automate the process.  

Sometimes we need to push invoice data to accounting system, also for reporting and need to send messages to vendors and customers, this scanning process will help.  

Power Automate and AI Builder, two tools from Microsoft's Power Platform, work well together to make this process faster and better. 

Power Automate is a service that helps create automated workflows between your apps and services to synchronize files, get notifications, collect data, and more. AI Builder, on the other hand, is a turnkey solution that brings the power of Microsoft AI to Power Automate, enabling organizations to automate processes and glean insights from their data through machine learning models. 

Take your Power Fx skills up a level with this awesome function

We want to add multiple checkbox controls inside a DataCard. Each selected checkbox will populate a Text Input control, and deselection will also remove that selection from the Text Input Control.

Sometimes you run in to scenarios where the out-of-the-box configuration simply is not sufficient to fill your or your customers' needs. One cool tool at your disposal for achieving this customization is the Client API, which allows you to manipulate the UI and data within your Model-Driven Apps using Javascript.

Developing a streamlined and efficient vendor approval process is crucial. It not only ensures that you work with the best vendors but also guarantees smooth operations in your supply chain or service delivery. 

In this tutorial, we've seen how you can structure a comprehensive vendor approval process using Microsoft Power Automate and SharePoint list. We've broken down the process into the following steps: 

• Vendor Invitation 

• Registration Form Automation 
• Approval Automation 
• Building the Vendor List 

In today's business landscape, developing a streamlined and efficient vendor approval process is crucial. It not only ensures that you work with the best vendors but also guarantees smooth operations in your supply chain or service delivery. Here's a step-by-step guide on how you can structure a comprehensive vendor approval process. We will learn these things -  

1. Vendor invitation 

1. Registration Form automation 

1. Approval Automation 

A dual list selector allows users to select and move items from one list of available items to another list of selected items. Unlike a select list, a dual list selector separates the available options and the selected options into two separate lists, which allows users to easily scan the items they selected (definition sourced from: https://www.patternfly.org/components/dual-list-selector/)

An easy way to add some fun to your UI!

In this Blog we will see how to set Lookup Value to Null Using Power Automate

We have a SharePoint List which includes the standard "Title" field and a single-select People Picker field.

In our Power Apps Form, we want to:

• Change our People Picker to display only users listed in an Office 365 Group
• Submit the selected user back to a SharePoint People Picker field
• Return the saved user back into the Form

Email organization is an absolute necessity, not just a task. If left unchecked, the daily electronic mail deluge can quickly grow into an impassable mountain. A person's cognitive load can be decreased, their productivity can be increased, and they won't miss important communications if their email is organized effectively.   

Although many platforms provide email services, Outlook's collection of productivity tools is unmatched. Its automation capabilities have been refined over time with the user's changing demands in mind. 

Power Fx enables PowerApps developers to build efficient and robust business apps with an arsenal of handy functions. The With function is used to simplify complex formulas by assigning a name to an expression or value, allowing for reuse elsewhere in the same formula. This can enhance readability and maintainability and prevent PowerApps from recalculating named values multiple times, leading to performance improvements in some cases.

💡To get started, let's explore how the Power Fx With function can be utilized. Below are some examples that showcase its adaptability.

Title: Enhancing Client Engagement with PowerApps: From Memphis to Clients Cities, Drive Ease and Gas Expense Rating (Use Case)

Introduction
In a world where data-driven decisions are critical, visualizing information is a powerful communication tool. Leveraging Canvas PowerApps, I demo a mechanism to assess the "drive ease" from Memphis, TN (an Example) to various clients' cities. It's not only about distance; this application also rates the price expense based on the distance, visually representing it through dynamic color changes. Let's dive into the specifics!

A journey of how I discovered to use the more complicated of the Easing Equations in PowerApps, and how these can be made into Custom Functions using components that can be used anywhere.

In today's data-driven world, ensuring clean and accurate data is paramount. With PowerFx, you can take data validation to the next level in PowerApps Applications using the Regex Expressions in combination with functions like CountIf, IsMatch, Split, and Not. What's even cooler? This code is user-interactive, allowing your users to spot and correct data errors effortlessly without the need for any Variable or Collection 
This can be combined with multiple text inputs with a sum function to check for each. 

A use case scenario here - https://medium.com/@olumideojoniyi/data-input-validation-in-powerapps-fd7e0b9b2db7

We will create a sample approval process in this chapter which will give an overview of how you can create your own approval processes in your business. We will first create a SharePoint list.  

To better manage date difference numbers in PowerApps you sometimes want to display the difference in the number of days, weeks, months etc, This blog post presents a simple method of doing this PowerApps 

In this Blog we will see how to use Delete Operations in Microsoft Dataverse or MSCRM

Introduce the concept of pagination and its significance in managing and displaying large datasets in Power Apps. Explain how it enhances user experience and optimizes performance.

In the fast-paced world of today, it's important that data handling is done well. By automating things that you do often, you can get a lot more done. Putting together Microsoft Excel, Power Automate, and Microsoft Forms is a useful way to collect and organize data. In this piece, we'll look at how Power Automate and Microsoft Forms can be used to add a row in Excel. 

This step-by-step guide will walk you through setting up dropdowns, managing user choices, and displaying them beautifully in a gallery.