Programming by Examples in Power Apps

Overview:

During this article, we will talk about new rolled out functionality by Microsoft this year in Power Apps Ideas. We will talk about “Programming by Examples” feature in detail. So, Let’s get started!

What do we mean by Programming by Examples?

“Programming by Examples” is a new AI Driven capability in Power Apps Ideas that automatically generate Power Fx Formula for us. This new feature is powered by PROSE (Programming by Examples and Natural Language), researched and developed by the Microsoft PROSE team. 

The same technology is already used in other Microsoft products as well, e.g., Flash fill in Excel, Intellicode suggestions in Visual Studio, and Table extraction in Power Query, etc.

Note:  At this moment, it is only available for US Region. 

Enable Preview Feature:

Go to File menu, Open Settings, click on Upcoming Features and make sure Ideas Panel is turn on!

Once we turn on the above feature, the Ideas Panel will be available for you!

1. Please take a look at the following Gallery control which is showing account information.
   
2. Now, we want to show the date as “June 3 2021”. Then how can we do that?
   
3. The above example output generated the Power Fx formula automatically. Select the formula and check the result. It will show you the following result!
   

So, this is how we can apply “Programming By Examples” in Power Apps. 

Let’s check some more examples:

Apply PBE on Text Columns:

• We want only First name from Full name. Then just provide your expected output and the formula will be generated automatically. 
  
• Below is the end outcome!
  

Apply PBE on Date column by Training the example:

• We want to display the Month name in 3 characters. So, how can we do that?
• Select Label, click on “Train from Examples’
  
• Provide sample outcome for few fields and click on “Get Ideas”.
  
• This will generate Power Fx formula
  
• Apply the formula and check the result.
  

Conclusion:

This is how Power Apps Ideas feature works in Power Apps. Isn’t that cool? Happy Power Apping!!

If you have any questions you can reach out our SharePoint Consulting team here.

Show values based on Lookup List Conditions for Lookup Column in Power Apps

Overview:

In this article, we will learn how we can show only specific values as Lookup value based on some conditions in Power Apps.

Real-Life Business Use Case:

We have come across a scenario where we have two SharePoint lists.

Domains List:

Request List:

 - Domain is a Lookup column from Domains List in the Request List.

 - We are implementing a Power Apps Form for Requests List.

 - We only want to show those Domains which are active, so how can we achieve this?

Let’s get started!

Step 1: Open Power Apps Form. By default, all values appear in the Lookup Dropdown.

Below is the code for the Default event which is available for the lookup dropdown.

Step 2: Now, we need to change the code with the following code.

 Filter(  
   RenameColumns(  
     AddColumns(  
       RenameColumns(  
         Choices([@Requests].Domain),  
         "Id",  
         "MID"  
       ),  
       "Status",  
       LookUp(  
         Choices([@Requests].'Domain:Status'),  
         Id = MID  
       ).Value  
     ),  
     "MID",  
     "Id"  
   ),  
   Status = "Active"  
 )  

Understanding the code:

 - By default, Lookup has two columns, ID and Value. With the above formula, we added one additional column –“Status” by using AddColumns() function.

 - To achieve this, we need to use the "RenameColumns" function to make the exact final structure that the lookup value expects.

 

- Now, let’s test the result. We can see only Active records in the dropdown.

 

- Now, let’s fill the form and save the value. 

 - The values are stored successfully in the SharePoint list.

Conclusion:

This is how we can apply a lookup list condition to show only active requests in the Lookup column. Hope this is clear now! Stay connected for amazing Power Apps Articles! Happy Power Apping!

If you have any questions you can reach out to our SharePoint Consulting team here.

Power of AI in Power Apps – Enhance your Business Capabilities with AI using Power Platform AI Builder (Webinar)

Overview:

AI refers to the simulation of human intelligence in the Business Applications. With the help of AI, we can automate so many business processes without any human interactions. 

With Power Platform AI Builder, we can utilize AI capabilities inside our Power Apps and Power Automate (MS Flow). Today, we are covering several real-time use cases and scenarios in order to see the power of AI in Power Apps. Please check the full video session of webinar, covering the followings:

Chapters of the session:

• Overview of AI 
• Overview of Power Platform AI Builder
• Custom AI Model
• Pre-Built AI Model
• Real-life use case and scenarios where we can use Object Detection AI Model
• Real-life use case and scenarios where we can use Form Processing AI Model
• Real-life use case and scenarios where we can use Prediction AI Model
• Real-life use case and scenarios where we can use Category Classification AI Model
• Real-life use case and scenarios where we can use Entity Extraction AI Model

The session is more focused for Business Users. Here, we have covered all custom AI models available in AI Builder.

Recording of the live session:

Conclusion:

This is the Power of AI in Power Apps which can be utilized with the help of AI Builder in Power Platform. Happy PowerApping!!!

 If you have any questions you can reach out to our SharePoint Consulting team here.