The Dynamics GP Blogster

In this video you will learn how to save pictures taken in Power Apps Mixed Reality or Augmented Reality viewer to a SharePoint document library.     Some topics covered include: Power Apps ForAll(), With(), Mid(), and Len() functions, the Self operator. Learn to use the Power Automate SharePoint connector and the Create File action, and the base64toBinary() function in an expression. Finally, you will see how you can call a flow from Power Apps to make it all work like a single application. To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP

This video was made in response to the Microsoft Power Apps team challenge, found here . What was your best app and what workplace frustration inspired you to make it? Film a video with your answer and share it with #MadeItWithPowerApps and #Sweepstakes for a chance to win. This is the second video in a series of weekly videos leading up to the announcement of the sweepstakes winners. Music in this video comes courtesy of Bendsound: Summer - www.bensound.com (Royalty free music from Bensound) Until next post! MG.- Mariano Gomez, MVP

This video shows how to embed PowerApps applications inside of Microsoft Dynamics GP, leveraging the Connect gadget feature as a mechanism to deliver the application. Learn how you can achieve this in 2 simple steps to create a unique user experience. More information on Dex.ini settings and web client: Dex.ini on this site - click here Web client on this site - click here Until next post! MG.- Mariano Gomez, MVP

This is part 1 of 2 showing how to build a persisted button pressed numeric up/down control. This video addresses the fundamentals of the control, starting with understanding the button pressed event, how it can be used to start and stop a timer, how to make 2 buttons increase and decrease a text input control, and finally introducing a timer to persist the press. Part 2 will show how to componentize all these controls into a unit that can be reused across other applications. For more information on button and timer controls, please check the following videos from MVP Shane Young ( Twitter: @ShaneCows ): PowerApps Timer Control: https://youtu.be/Xe2NI2aTGvY PowerApps Hide Button Based on User and other fun: https://youtu.be/0MB-z9cyFCQ Until next post! MG.- Mariano Gomez, MVP

In this video I explore the recently released AI Builder Form Processing component, by creating and training a utilities billing model. I also show how to build a real life PowerApps application to take advantage of the utility billing model and some elements and considerations while doing so. You can find more information on AI Builder here: https://docs.microsoft.com/en-us/ai-builder/overview Until next post! MG.- Mariano Gomez, MVP

In this video I take a look at the newly released JSON() serialization function and how it can be used to serialize an image, added to PowerApps in the month of June. You can read the full details on the PowerApps Blog article, JSON for canvas apps . Also, take a look at the video created by PowerApps MVP, April Dunham on the subject, along with her intro to AI Builder. Until next post! MG.- Mariano Gomez, MVP

This past Microsoft Business Applications Summit 2019 - Atlanta , I teamed up with fellow Microsoft MVP, Belinda Allen to deliver a 20 minutes theater session showing how to build a cash flow in Power BI, then use Microsoft Flow to get notifications based on specific conditions in the report, and embedding the cash change calendar as a tile in a PowerApps application. We had a lot of fun putting this presentation together, so I hope you enjoy it. Until next post! MG.- Mariano Gomez, MVP

Hi PowerAppers! PowerApps Canvas Apps Components remain one of those features that seem to have endless possibilities. I have, for quite some time now, been working with the Google Maps API in many of my applications to return a static image pointing to a specific location on the map. As I moved from application to application, I noticed that I always ended up doing the same operations: format a label with a string representing the maps API Url, then substituting very specific elements within that string, with address information or latitude and longitude coordinates, adding the API key, and playing with the size of the map image returned by the maps API. Frankly, a time consuming process that added no value to my projects. This is a sample Google maps API Url string with some the classic substitution patterns: Click image to enlarge In order to solve this problem, I decided to farm this out to Canvas Apps Components. Since my Url string had many placeholders for things li...

I just recently returned from the Microsoft MVP Global Summit 2019 where I had a chance to meet some of the top minds in the Microsoft PowerApps and Flow space. This was a truly exciting moment as I have been learning from the very same MVPs I met - yes, we do learn from each other! In one of my hallway discussions, I ran into my buddy Mehdi Slaoui Adaloussi , Principal Program Manager at Microsoft, who I first met at Microsoft Build 2018. I had read Mehdi's recent article on reusable components and, in particular, that I had been playing with his version of the Numeric Up/Down Control. See 10 Reusable Components: tab control, calendar, dialog box, map control and more . I must start by saying that the components Mehdi put in place expose some very clever implementation techniques, so I highly recommend you download the msapp files and load them up in your environment and study them. The Numeric Up Down control in particular, caught my attention as it required multiple...

In Part 1 of this series, you saw how my first version of the digital clock went. Although it got the job done, it was plagued with repetitive code, repetitive controls, and over saturation of variables, which in turn rendered the application hard to follow, and worse yet, affected performance. In this article, I will show how to use PowerApps Components  to promote reusability and decrease the code footprint. Components is currently a preview feature, hence word of caution when using them as you may need to retest your app once it becomes generally available. The previous experience showed us that we can save time and code by creating a component to be used for the digits of the clock. This digit component could then be enhanced by allowing the developer to pass in the digit to be displayed and the foreground and background colors the segments - all set up as custom properties to the component - as shown here: We have also added code for each of the segments that will b...

Building a Digital Clock the traditional way When I first set out to build a digital clock with night mode, I figured I was just going to start from what I know. Each digit of the clock is composed for 7 segments and each segment would behaves in a binary way based on the number that it needs to display. To create each segment, I would use a Rectangle from the Icons gallery. Since I initially set out to add 3 digits to the clock - two to display seconds, and 1 to display minutes - this would require a whopping 21 rectangles, plus 2 for the blinking dots to bring the total rectangles to 23. Controlling each digit required the use of 3 timers. Each timer would have to evaluate a value to determine which segments to display. For the right most digit, the following code is used for the timer, Timer1 : Timer1 OnTimerStart() Select(Button1) Timer1 OnTimerEnd() UpdateContext({MyCounter: MyCounter + 1}); If ( MyCounter > 9, UpdateContext({MyCounter: 0}), false )...

As of late, I have been very interested in all things "Motion" as it relates to developing PowerApps applications - see #PowerApps: Motion Patterns with Parametric Equations . Although, most of the apps you will see tend to be around solving business problems, you cannot really dismiss the capabilities of PowerApps as a gaming platform. The Basics In this article, I explore a simple object proximity and collision detection approach, based on some simple logic. The world of gaming uses more sophisticated algorithms based on the laws of physics and what's not, but keep in mind that PowerApps is designed to be a low code/no code environment, hence access to user driven programmatic methods is extremely limited. The following is a representation of the actual canvas apps I created for this example. It consists of 4 directional arrows to provide motion to smiley, a simple character added from the icons gallery. In addition, we have a rectangular obstacle added a...