PowerApps tips and tricks

In this Microsoft PowerApps tutorial, let us discuss various PowerApps tips and tricks that you can easily use while working with PowerApps.

PowerApps tips and tricks

Now let us see the below 10 PowerApps tips and tricks that you can use as a PowerApps developer and you should know.

#1- Show and Hide TextBox based on CheckBox value

If you got any requirement to show or hide textbox based on a checkbox value, then you can write the below formula in the Textbox visible property.

If(chkNominee.Selected.Value="No",true, false)

#2- PowerApps allow only numbers

If you want to allow numbers only in textbox in PowerApps. then you can change in the PowerApps textbox control properties. Change Format to Number like below:

You may also like PowerApps Employee Directory.

#3- PowerApps Allow Password Only

In PowerApps, if you want to allow password only in a textbox, then in the PowerApps textbox properties change Mode to Password.

#4- PowerApps Textbox with Maximum Length

If you want to set maximum length for textbox in PowerApps, then change the PowerApps textbox control properties to MaxLength to 8.

#5- PowerApps Lookup DropDown

If you want to implement lookup dropdown in PowerApps, follow below steps like the screenshot.

Then list will looks like below:

Here, we have two textboxes like State, Branch like below.

In the State dropdown, Items choose States column.

Then in the Branch write the Filter condition in the Items like below:

Filter('Bank Branches','State Name').Value=ddlStates.Selected.'State Name')

#6- Add Year to Current Date

To add Year to Current Date in PowerApps, you can write the below formula.

Current Date : 11/9/2020

Add 15 Years in Current Date : 'Maturity Date':Text( DateAdd( Today(), 15, Years ),"[$-en-US]dd-mm-yyyy" )

O/p: 11-09-2035

#7- Auto Generate Number in PowerApps

If you want to auto generate number in PowerApps, write the below formula in the textbox.

Set(UniqueAccountNumber,"ABC-"&Text(Now(),"[$-en-US]yymmddhhmmss"));

O/p: ABC-200911115739

#8 Get first starting letter of your name in PowerApps

If you want to get first starting letter of your name in PowerApps, write the below formula like below:

Left(LookUp('User Registration',Title=vAccountNo).AccountHolderName,1)

#9- Open outlook when click on Email id in PowerApps

If you want to Open outlook when click on Email ID in PowerApps, then in the OnSelect select property write the below formula.

Launch("mailto:"&(Lookup('User Registation', Title=vAccountNo).EmailID))

#10- Open Contact when click on mobile number in PowerApps

If you want to open contact when click on mobile number in PowerApps, then write the below formula:

OnSelect=Launch("tel:"&(LookUp('User Registration',Title=vAccountNo).MobileNumber))

You may like the following PowerApps tutorials:

• Power Apps SharePoint Button
• Power Apps Navigate Function + 16 Examples
• PowerApps form benefits for SharePoint
• How to view PDF files using PDF Viewer in PowerApps
• How to create a PowerApps Canvas app from Excel OneDrive for Business data source
• PowerApps Combobox SharePoint List Example
• Fetch azure groups in PowerApps using PowerApps Azure AD Connectors
• How to create calculator in PowerApps
• PowerApps Examples: Restaurant management system
• Fetch Outlook email details PowerApps using Office 365 Outlook Connector

I hope these PowerApps tips and tricks will help you. Give it a try!  We would love to hear your feedback. If you have any feedback or issues, please feel free to add your comment here.