Switch function in Power Apps
The Power Apps Switch function evaluates a single condition against multiple possible matches.ย If a match is found, a corresponding value is returned. If no match… Read More »Switch function in Power Apps
I have 8+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
The Power Apps Switch function evaluates a single condition against multiple possible matches.ย If a match is found, a corresponding value is returned. If no match… Read More »Switch function in Power Apps
Theย Concatย function concatenates the result of a formula applied across all the records of a table and returns a single string. Concat(ย Table,ย Formula,ย separator) Tableย – Required. Table to… Read More »Concat function in Power Apps
Power Apps is a robust platform that allows you to create custom business applications with ease and efficiency. One of the most common and useful… Read More »Power Apps send email
In Power Apps, you can submit multiple records to a data source using different different approaches. It depends on your specific scenario. We will explore… Read More »Submit multiple records in Power Apps
Theย Calendarย andย Clock functions are used to display dates and times in the language of the current user. Calendarย andย Clock functions functions return single-column tables that can be… Read More »Calendar and Clock functions in Power Apps
Power Apps provides built-in functions such as Reset and ResetForm.ย Reset function allows you to reset a control to its Default property value while ResetForm allows… Read More »Reset multiple controls or all controls on a form in Power Apps
Theย ShowColumns function creates a new table including all the columns that you specify and exclude all other columns. It does not modify the original table.… Read More »ShowColumns function in Power Apps
LookUp function in PowerApps allows you to find data from a related data source or table that satisfies the condition or formula given in the… Read More »LookUp function in Power Apps
Power Apps Filter function allows you to find a records in a table that match the specific condition criteria. You can use more than one… Read More »Filter function in Power Apps
The With function in Power Apps evaluates a formula for a single record. It improves the readability of complex formulas by dividing it into smaller… Read More »With function in Power Apps
The Sequence function in Power Apps generates a single column table of sequential numbers. The name of the column returned by Sequence function is Value.… Read More »Sequence function in Power Apps
In Power Apps, to add an alternate background color to rows in gallery, you need a sequential number (1,2,3,4,5..) or you can say an auto… Read More »Add alternate row color in gallery Power Apps
Power Apps Text function is used to convert any value and formats a number or date/time value to a string of text. Syntax: Text(Value, Format,… Read More »Text function Power Apps
A gallery control is used to show multiple records from a data source, and each record can contain multiple types of data. To filter the… Read More »Filter and search items in gallery Power Apps
Creating a cascading dropdown or dependent dropdown allows users to select values in one dropdown and filter the records in another dropdown for those selected… Read More »Create a cascading dropdown in Power Apps
A variable is a temporary storage that can be defined and used anywhere within Power Apps. Variables are created and typed by default when they… Read More »Create a variables in Power Apps
Power Apps ClearCollect function deletes all the records from a collection and then adds a different set of records to the same collection. Basically, this… Read More »ClearCollect function in Power Apps
A collection is used to store and manage a group of items or records. It acts as an in-memory data source. It allows you to… Read More »Collection in Power Apps