Virtual Camp Apr’19

PowerApps

After 3 fantastic days, Virtual Camp Apr'19 has finished. An event with many high level speakers and a great diversity of topics. From Intelequia we feel very proud to have been part of it.

On this occasion, I had the opportunity to share the talk with Abe Santana and Mario Trueba about my favorite topic: PowerApps.

PowerVault: Manage your Azure Key Vaults from PowerApps

The Azure Key Vault service is perfect for saving all kinds of information in a secure manner: authentication keys to connect to a database server, SSL certificate files, and of course, passwords... or as Azure Key Vault names them, secrets.

Recently, Microsoft released a connector to use this service (still in preview) so building a PowerApp to manage these secrets is a match made in heaven

Using custom fonts in PowerApps

When using PowerApps, we get a fair amount of settings to change our text controls but sometimes, we need that little extra touch. One of those options is the font family. We get 14 font styles that are suitable for most design ideas. We might get more in the future but now, I’m going to show you how to include any desired font that might be required for any of your projects. First approach, the HTML control The first idea that you might have tried is to use the powerful HTML control that is included in PowerApps. This control lets you format it’s contents using plain HTML code, but it...

Tired of small dialogs in Dynamics 365 CRM? Try this fix

These days we are used to work with big resolutions. With all this real state, why do we settle with these small dialogs in Dynamics 365 Wouldn’t it be nice to seize all this windows space, specially for lookup dialogs? Recently, a customer approached us regarding this issue… it was really difficult for them to search for contacts when creating marketing lists by using this small dialogs. So, by using an out-of-the-box approach, as one of my colleagues calls it, we installed a browser extension which allows you to change the styling of a webpage, including the resize of dialogs and pop-ups. This open source extension is called Stylus. It’s...

Beyond PowerTwitter: | Updating Collections using Regular Expressions in PowerApps

Ahhh Regular Expressions… that thing that keeps you returning to Stack Overflow for answers every time you need to use this language: Even so, this language is extremely helpful when you need a more powerful way to deal with string data. Recently, PowerApps got an update to add more features to it’s regular expression functions. We now have to two more functions in our ever growing arsenal: Match and MatchAll. As the name implies, these functions serve mainly to find matches for a given regular expression formula. Match finds the first piece that meets the requirements and MatchAll gives us a table of records of all the matches. This is...

PowerTwitter

PowerTwitter is a pixel-by-pixel implementation of Twitter’s homepage in a canvas PowerApp. Application features:Full use of the Twitter’s connector Sentiment analysis using Azure’s Text Analytics API Light and Dark themes The idea behind this project was to showcase the many possibilities when designing user interfaces for Canvas apps. You can learn by example on how to create rounded user dialogs, display a shade for zoomed images / dialogs, handle theming of your app and explore the fully potential of the flexible height gallery. User dialogs and shades for zoomed images As in popular image editing applications as PowerPoint itself, PowerApps lays all screen elements as layers. Depending on the localization...

Renaming Sharepoint List PowerApps forms

When you create a Sharepoint List PowerApp you might have noticed that this kind of PowerApps get an auto generated name. Something like “MyApp on PowerApps forms”: You might also have noticed that there is no way to change this name from the App Settings: There is a little trick that I’ve found in order to change it’s name: From the File menu, in the Save section click on See all versions It will open a new tab listing all the saved versions of your App. Close the PowerApp tab. We need to do this because PowerApps locks the app to prevent changes from other locations. We are going to change the name from Versions...

Query and transfer data between Azure SQL databases

In the DevOps world, there are some situations where you need to have a way to transfer data from different Azure SQL databases.  For example, let’s say you have a client who inadvertently deleted a huge amount of records from a table in the production database. With the help of the Point in Time backups, we could restore the database to an earlier point in time in which those records still exists. This process will create a new database with the restored contents and then we could swap names between these databases by renaming them. However, there is a caveat of performing this action. The restored database will lose all the...