Power Apps: Formulas & Properties

By Ashwin Venugopal -

 





Formulas and Properties  

Power Apps typically include numerous properties and formulas. Every element within a Power App will have a range of properties to utilize. A portion of these will characterize a specific attribute of the item. A screen for example has:

  • BackgroundImage

  • Fill

  • ImagePosition

  • LoadingSpinner

  • LoadingSpinnerColor

These properties are set up and persist until you change them. Some properties will perform actions based upon a state of the item. For example, a screen has:

  • OnHidden

  • OnStart

  • OnVisible

Properties of this kind will perform a change linked to the property only when that specific behavior is triggered; for instance, when a screen appears, you can refresh the data.

To implement change or specify an action that occurs when a property is activated, Formulas are utilized. Consider formulas as guidelines. They can perform calculations, trigger events, or assist in establishing a logical progression within which specific actions may occur. They resemble Excel formulas, but Power Apps offers a wider range of functionalities.

Certain controls possess attributes like OnSelect, which allows you to specify, through a Formula, the actions that should occur when you select it directly.

Top 10 Formulas

The key to effectively using formulas lies in discovering what functions well and testing different approaches. In the formula bar, there's a feature named IntelliSense. This tool from Microsoft 365 assists you by potentially auto-completing a formula or recommending a structure for the formula you want to create (hover over underlined items in red to receive guidance on any issues being flagged).

The more you utilize IntelliSense, the more instinctive it will become, so there's no need to feel pressured at the beginning. Simply experiment and gain experience to achieve the outcomes you desire. There are approximately 150 formulas available for use with Power Apps, all of which can be found on Microsoft's documentation website.

Conclusion

We have successfully discussed about the formulas and properties of Power Apps. 



































Comments

Post a Comment

Popular posts from this blog

Information Protection Scanner: Resolve Issues with Information Protection Scanner Deployment

By Ashwin Venugopal -
Image
  About If you are experiencing problems with the Microsoft Purview Information Protection scanner, check the health of your deployment by utilizing the Start-ScannerDiagnosticsPowerShell cmdlet to start the scanner diagnostic tool. The diagnostics tool checks the following details and then creates a log files with the results: Whether the database is up to date. Whether network URLs are accessible. Whether there's a valid authentication token and policy can be acquired. Whether the profile is defined in the Azure portal. Whether offline/online configuration exists and can be acquired. Whether the rules configured are valid.  The Start-ScannerDiagnostics command does not perform a comprehensive check of prerequisites. If you encounter problems with the scanner, you need to verify that your system meets the scanner's requirements, and that your scanner's configuration and installation are finished.  Verify Scanning Details Per Scanner Node and Repository Run the Get-ScanSt...
Read more

How AMI Store & Restore Works?

By Ashwin Venugopal -
Image
  CreateStoreImageTask The CreateStoreImageTask API stores an AMI as a single object in an S3 bucket. The API initiates a task that collects all the data from the AMI and its associated snapshots, subsequently using an S3 multipart upload to store this data in an S3 object. It gathers all elements of the AMI, including most of the non-Region-specific metadata and all EBS snapshots included in the AMI, and consolidates them into a single object in S3. During the upload process, the data is compressed to minimize the space utilized in S3, which means that the S3 object could be smaller than the total sizes of the snapshots in the AMI. If the account making this API call has access to AMI and snapshot tags, they will be retained. The S3 object shares the same ID as the AMI, except it has a .bin extension. Additionally, the S3 metadata tags for the object include the AMI name, AMI description, AMI registration date, AMI owner account, and a timestamp indicating when the store operation...
Read more

Create A Store Image Task

By Ashwin Venugopal -
Image
  Introduction When you save an AMI in an S3 bucket, a task for storing the image is initiated. This store image task allows you to track the progress and result of the procedure. Securing your AMIs It is crucial to verify that the S3 bucket is set up with adequate security to protect the content of the AMI and that this security is upheld for the entire duration that the AMI objects are stored in the bucket. If this cannot be achieved, it is advisable to refrain from using these APIs. Make sure that public access to the S3 bucket is prohibited. It is suggested to activate Server-side encryption for the S3 buckets where you keep the AMIs, even though it’s not mandatory. When AMI snapshots are transferred to the S3 object, they are sent over TLS connections. It is possible to save AMIs that contain encrypted snapshots; however, the snapshots will be decrypted during the storing process. Identify the source AMI used to create a new Amazon EC2 AMI You can determine the AMI that was us...
Read more