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
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
TrimEnds 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
Launch 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
IsNumeric 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
Table 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
AddColumns 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
Patch 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
Navigate 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
ForAll 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
EndsWith 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
StartsWith 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
Refresh 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
Create a confirmation pop-up 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
RemoveIf function 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
UpdateIf 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
Select multiple records in a gallery using checkboxes
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
Reset multiple control values in Power Apps
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
Compare the values of current row with previous row in SQL
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
Extract URL and display name from string
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
Find the numbers that appear at least three times consecutively
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