Latest PowerApps update introduces the App Usage report and the new Split string function
The newest update for PowerApps (version 690) launches a preview of the 'Usage' report for app authors to review the usage of their apps across their organization and the ability to use a delimiter to break a text string into parts with the Split function.
App usage report
Need an easy way to monitor how many users are using your app within your organization? Introducing the preview of the App Usage report.
The App usage report gives app authors the ability to track how many users have launched your app over the past 30 days broken down by day, device platform and location. If you are interested in learning more, check out my blog post that outlines the capabilities of the report and where you can find it on web.powerapps.com.
Got a list of fruit to buy at the market? “Apples, Oranges, Bananas”? Need a way to quickly and easily break that string up so that you can check them off, one by one?
Do we have the function for you! Introducing the Split function. It takes as input a string to break apart and a separator string to break on, and outputs a table of substrings. So, for the above example:
Split( “Apples, Oranges, Bananas”, “,” )
Results in a table of [ “Apples”, “ Oranges”, “ Bananas” ]. Note that there are spaces in front of “ Oranges” and “ Bananas”. That is because we broke the string up on exactly a single comma and nothing more. We can fix this by changing the separator to look for two characters which includes the space:
Split( “Apples, Oranges, Bananas”, “, ” )
Or if we aren’t always sure that there will be a space, or there might be two, we can use the TrimEnds function on the result (input is a single column table and output is a single column table):
TrimEnds( Split( “Apples, Oranges, Bananas”, “,” ) )
Both of these methods result in the desired single column table [ “Apples”, “Oranges”, “Bananas” ].