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.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).