User function in Power Apps
The User function in Power Apps is used to retrieve information about the currently logged-in Power Apps users. It provides details such as the user’s… Read More »User function in Power Apps
![]()
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
The User function in Power Apps is used to retrieve information about the currently logged-in Power Apps users. It provides details such as the user’s… Read More »User function in Power Apps
![]()
The TrimEnds function in Power Apps is used to remove any leading and trailing spaces from a string. It helps clean up text input by… Read More »TrimEnds function in Power Apps
![]()
The Launch function in Power Apps is used to open a web page, another app, or trigger an action in a browser or external app… Read More »Launch function in Power Apps
![]()
The IsNumeric function is used to check whether a given value is a number. It returns true if the input is numeric (integer, decimal, etc.)… Read More »IsNumeric function in Power Apps
![]()
The Table function creates a table from a list of records or tables provided as arguments directly within the app. The resulting table includes all… Read More »Table function in Power Apps
![]()
The AddColumns function is used to add new columns to a table. This function allows you to create new columns by defining expressions or calculations… Read More »AddColumns function in Power Apps
![]()
The Patch function in Power Apps is used to create or modify records in a data source. It can be used to insert new records,… Read More »Patch function in Power Apps
![]()
The Navigate function in Power Apps is used to change the screen within an app. It allows for a dynamic user experience by enabling users… Read More »Navigate function in Power Apps
![]()
The ForAll function in Power Apps is used to perform a specific action or apply a formula to each record in a table or collection.… Read More »ForAll function in Power Apps
![]()
The EndsWith function in Power Apps is used to check if a text string ends with a specific sequence of characters. It’s commonly used to… Read More »EndsWith function in Power Apps
![]()
The StartsWith function in Power Apps is used to check if a text string begins with a specific sequence of characters. It’s typically used for… Read More »StartsWith function in Power Apps
![]()
The Refresh function is used to refresh or update data from the data source, ensuring that the app displays the most current data. Refresh has… Read More »Refresh function in Power Apps
![]()
A confirmation pop-up or dialog box enhances the user experience by adding a layer of safety and making the app more intuitive. It helps prevent… Read More »Create a confirmation pop-up in Power Apps
![]()
The RemoveIf function in Power Apps is used to delete single or multiple records from a data source based on specified conditions. This function allows… Read More »RemoveIf function in Power Apps
![]()
The UpdateIf function is used to update records in a data source that meet specific conditions. It allows you to modify single record or multiple… Read More »UpdateIf function in Power Apps
![]()
A Gallery control can show multiple records from a data source, and each record can contain multiple types of data However, in many scenarios, users need to… Read More »Select multiple records in a gallery using checkboxes
![]()
In Power Apps, resetting multiple control values can be achieved using the Power Apps in-built function Reset for each control you want to reset. The… Read More »Reset multiple control values in Power Apps
![]()
Sometimes, we need to calculate the difference between the values of the current row and the previous row in a table or you can say… Read More »Compare the values of current row with previous row in SQL
![]()
How would you extract the display name and URL from a string in the format [display_name](url)? For example: Let’s say for string [abc](https://www.sqlskull.com), how would… Read More »Extract URL and display name from string
![]()
This is one of the most asked SQL interview question find the the numbers that appear at least three times consecutively. As, you can see… Read More »Find the numbers that appear at least three times consecutively
![]()