Power Apps Cheat Sheet

ProblemExpression
Show the current logged in userThe User Function Examples

User().Email - Shows email address
User().FullName - Shows user's name
User().Image - Shows user's photo
Filter the rows to a certain criteriaThe Filter expression can filter the rows based on an expression of your choosing.

Filter(DataSource, Expresssion)
Filter( DataSourceName, Column > 0 )
Filter( DataSourceName, Column > 0, Column2 = "Value" )
 
Lookup a value in another table or sourceThe lookup function can see the value from a different source based on an expression.


Lookup(Source, Condition, ValueToShow)
Lookup(DataSourceName, CustomerID = 5, CustomerName)

 
 
Create a Global VariableGlobal variables can be seen on any screen. They can be created when you start an app by selecting the App OnStart event or on any actionable event.
 
Set(VariableName, value)
 
Navigate to a new screenNavigation can be done two ways: either go back to the previous screen you came from or navigate to a specific screen..
 
Navigate(ScreenName)
 
Optionally, you can specify an effect during the transition:

Navigate(ScreenName, ScreenTransition.Fade)
 
Send data from a form to the source.

A few ways to send data from a form are SubmitForm or the Patch commands. The SubmitForm is easiest with he smallest amount of flexibility.

SubmitForm(FormName)
     
Searching multiple columns for a rowThe Search command does a contains search across multiple columns and is usually used in galleries or data tables.
 
Search(DataSource, SearchString, Column1 [, Column2, ... ] )
Search(DataSource, txtInput.Text, "FirstName", "LastName") 
 
Updating or inserting data without a formThe Patch function is one way to update or insert data without using a form. For example, you can tie it to an OnChange even of a drop down box.
 
For inserting a record:
Patch(DataSource, Defaults(DataSource), {ColumnName:"Value1", ColumnName2:Number2})
 
Similarly, you can update data when you select an item in a gallery:
Patch(DataSource, ThisItem, {ColumnName:”Value1″, ColumnName2:Number2})
SharePoint Variations with a person picker

Lookups and the Person Picker in Sharepoint require some variations to your code in Power Apps since it’s a packed field, meaning that the one field has a bunch of items inside of it with references. This gives you the ability to navigate the hierarchy easier in Power Apps.

For filtering based on a Person Picker based on the person who’s signed in:

//Put this code in the App OnStart
Set(varUserEmail, User().Email)

//Gallery code or wherever you want to filter
Filter('Assembly Work Orders', Owner.Email=varUserEmail)

 

Patching is especially challenging into a Person Picker and a choice column. Both are shown below showing you how to unpack the column before inserting into your list. The below is showing inserting with Patch into a SharePoint list with a choice column called Status and a Person Picker column called Owner. A title column is required also for SharePoint.

Patch(‘SharePoint List Name’, Defaults(‘SharePoint List Name’), {Title:”Your record title here”, Status: {‘@odata.type’:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”, Value:”Complete”}, Owner:{ ‘@odata.type’: “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser”, Department: “”, Claims: “i:0#.f|membership|” & User().Email, DisplayName: User().FullName, Email: User().Email, JobTitle: “”, Picture: “” } })


Filtering on a choice column requires that you specify the value of the choice as shown below with a drop-down filter.

Filter('SharePoint List Name', ChoiceColumn.Value=Dropdown1.SelectedText.Value)


Defaulting a drop-down box in a form to your name in a person picker column
Set the DefaultSelectedItems property to the following if your form is called Form1 and your Person Picker column is called CreatedBy. Note the code is going to check to see if the form is in New mode and do this or if it’s in edit mode, it will keep its existing value from the list.

If(Form1.Mode = New,{
  '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
   Claims:Concatenate("i:0#.f|membership|",User().Email),
   DisplayName:User().FullName,
   Email:User().Email
    }, 
ThisItem.CreatedBy)
Get the first Day of the monthSome systems will require you insert the first day of the month vs today’s date.
 
Date(Year(Today()), Month(Today()), 1)

Would return 3/1/2021 if it were 3/16/2021. Replace Today() with your own date picker if you want the customer to pick the date instead of always getting today’s date as shown below.

Date(Year(DatePicker1.SelectedDate), Month(DatePicker1.SelectedDate), 1)

For the last day of the month, you can use the With statement to construct your logic. The below code finds the first day of the next month then subtracts one day from that, giving you the last day of the previous month. With the With statement, you essentially, create a variable that’s only in scope of this one command. In my case that scope is only in the scope of a text label.

With({DateSelected:Date(Year(DatePicker1.SelectedDate), Month(DatePicker1.SelectedDate), 1)}, DateAdd(DateAdd(DateSelected, 1, Months), -1, Days))
 
 Download the Power Apps Cheat Sheet.

Comments

Post a Comment

Popular posts from this blog

If any case created, then check for the same user how many cases are created with in 30 days, if more than 2 and less than 5 send a mail to team lead, if more than 5 and less than 9 then send a mail to manager using power automate.

Image
If any case created, then check for the same user how many cases are created with in 30 days, if more than 2 and less than 5 send a mail to team lead, if more than 5 and less than 9 then send a mail to manager using power automate. Step 1 and 2: Step 3&4 Step 5&6 Step 6&7 Hear One condition will checks for cases are of greater than 2 or less than 5 and Second condition will check for cases are of greater than 5 and less than 9 check in you mail  which you provided
Read more

Create approve & reject ribbon buttons, once click on approve it should change the status field to approve.If clicked on reject it should change to Reject. Based on status field change trigger work flow to send a email to stating request is approved/Rejected.

Image
C reate approve & r eject ribbon buttons, once click on approve it should change the status field to approve. I f clicked on reject it should change to Reject . Based on status field change trigger work flow  to send a email to stating request is approved/Rejected. Ans. For doing this we should follow step wise Step 1: Create an entity name it as ApprovedBy. Step 2: Create a field name with status and data type as Option set Step 3: Create a new solution Next Inside solution add existing entity > Click on entity component > now click on Add existing entity > search Your entity > select that entity and click on ok > an entity assert pop up is visible In entity Asserts right side corner we can see two check box l  Include entity meta data l  Add all asserts     Now uncheck the Add all asserts > select the include entity metadata check box > Click on finish button > then  Missing required component pop up will be appear.   For ...
Read more

How to get and set values in plugins?

  How to get and set values in plugins?   Ans.   using System; using System.Collections.Generic; using System.Diagnostics; using System.IO; using System.Linq; using System.Net.NetworkInformation; using System.Text; using System.Threading.Tasks; using System.Xml.Linq; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sdk.Messages; using Microsoft.Xrm.Sdk.Metadata; namespace DatatypesPlugin {     public class UpdateData : IPlugin     {         public void Execute(IServiceProvider serviceProvider)                           {             IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));             IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));   ...
Read more