Skip to main content

PowerApps new features

What’s new in PowerApps?

Microsoft has recently released a few new features in PowerApps. A few of them are in preview and others are already released.

What are Named Formulas?

PowerApps Named formulas the name is derived from the old school Name Manager that was used in excel. Excel allows you to name tables, cells and so and then refer to them using the name.

How to enable Named Formulas?

Assuming you have already created an app and you are using the latest version of PowerApps studio. Click on settings on the top bar of the screen. 

image

You need to select Upcoming Features and select Experimental Features option and search with “Name” in top search bar. 

You should now see the “Name Formulas” feature, Just enable it.

Graphical user interface, text, application, Teams Description automatically generated

How to use Named Formulas?

Named formulas allows us to  

Set( SampleTextVariable, “70”);

With

SampleTextVariable = “70”;

You can now refer SampleTextVariable in any screen in the same PowerApp. These formulas can be used in App.Formulas property as of now. 

Below are a few advantages of using Named Formulas.

  • The formula’s value is always available.
  • The formula’s value is always up to date.
  • The formula’s definition is immutable.
  • The formula’s calculation can be deferred.
  • Named formulas are an Excel concept.

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...
2 comments
Read more

Identity client runtime library (IDCRL) did not get a response from the login server.

Recently I was doing some testing with a background PowerShell and encountered a weird error. “Identity client runtime library (IDCRL) did not get a response from the login server”. The error that you might encounter while working with PowerShell. This error is very misleading when it comes to identifying what could go wrong. After doing quite a good amount of research below are the probable causes for the error. Invalid Credentials MFA (Multi-Factor Authentication) Manage security defaults. Solutions Invalid Credentials Check if your credentials are wrong. Especially if you are using variables. MFA (Multi-Factor Authentication) Check if MFA is enabled on the account which you are using. These only affect you badly if you are developing PowerShell for a background Job. Go to Microsoft 365 admin center Users -> Active users -> Select the user -> Manage multifactor authentication -> Select the user -> Disable multi-factor authentication. M...
2 comments
Read more

Copying Footers Between SharePoint Sites Using PnP PowerShell

Recently, I have been extensively working with SharePoint and the Patterns and Practices (PnP) PowerShell module. PnP has significantly simplified various tasks by providing easy-to-use command sets and thorough documentation. One particular task that PnP has made straightforward is copying a footer from one SharePoint site to another. This process can be achieved with just a few commands. Why Use PnP PowerShell? PnP PowerShell is a set of cmdlets designed to work with SharePoint Online and SharePoint on-premises. It simplifies the management and automation of common tasks and provides commands for nearly every aspect of SharePoint administration. The PnP module is especially useful for tasks that would otherwise require complex scripting or manual intervention. Copying a Footer with PnP PowerShell To copy a footer from one SharePoint site to another, follow these steps. This process involves exporting the footer template from the source site in XML format and...
Post a Comment
Read more