tag:blogger.com,1999:blog-52859701355103715652024-03-16T14:52:48.191-04:00The Dynamics GP Blogster<em><strong>"Your Microsoft Dynamics GP world without barriers"</strong></em>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger1087125tag:blogger.com,1999:blog-5285970135510371565.post-89000689003847654872021-08-12T15:09:00.002-04:002021-08-12T15:09:08.980-04:00Power Apps - Application Monitoring with Azure Application InsightsIn this video, learn to enable Power Apps Application Monitoring with Azure Application Insights. <div><br /></div><div style="text-align: center;"><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/nISv1JHNRQY" title="YouTube video player" width="640"></iframe></div><div><br /></div><div>The following topics are covered in this video: </div><div><br /></div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=0s">0:00</a>) - Intro </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=36s">0:36</a>) - What is Azure Application Insights </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=92s">1:32</a>) - The timesheet app </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=132s">2:12</a>) - Creating an Application Insight for the timesheet application </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=235s">3:55</a>) - Identify and copy the application instrumentation key </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=249s">4:09</a>) - Enabling the timesheet application with the instrumentation key </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=332s">5:32</a>) - Working with Application Insights </div><div>(<a href="https://www.youtube.com/watch?v=nISv1JHNRQY&t=486s">8:06</a>) - Outro</div><div><br /></div><div>For additional information on Azure Application Insights, please follow these resources:</div><div><br /></div><div>Microsoft Docs - What is Azure Application Insights? <a href="https://docs.microsoft.com/en-us/azure/azure-monitor/app/app-insights-overview">here</a></div><div><div>Adam Marczak - Azure for Everyone: Azure Application Insights Tutorial, <a href="https://youtu.be/A0jAeGf2zUQ">here</a></div></div><div><br /></div>To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br /><b><br /></b><div><b>LIKE AND SUBSCRIBE!!!<br /></b>
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-13160203128298709252021-08-03T15:46:00.000-04:002021-08-03T15:46:06.686-04:00Power Platform ALM - Visual Studio Code Extensions<p>Learn about Power Platform extension for Visual Studio Code and how this toolset is improving both the code first developer experience and strengthening the ALM story. </p><br /><div style="text-align: center;"><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/vfwYY6Aexeg" title="YouTube video player" width="640"></iframe></div>
<p><br /></p><p>The following topics are covered: </p><p></p><ul style="text-align: left;"><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=0s">0:00</a>) - Intro </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=76s">1:16</a>) - Installing the Power Platform extensions for Visual Studio Code </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=133s">2:13</a>) - Working with the Power Platform CLI inside of Visual Studio Code </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=222s">3:42</a>) - Authenticating to your environment from Power Platform CLI </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=438s">7:18</a>) - Saving your canvas app to your local machine </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=535s">8:55</a>) - Unpacking your canvas app </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=619s">10:19</a>) - Using Visual Studio Code to make changes to your application </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=710s">11:50</a>) - Packing and uploading your application changes </li><li>(<a href="https://www.youtube.com/watch?v=vfwYY6Aexeg&t=835s">13:55</a>) - Outro</li></ul><p></p>
To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br /><b><br /></b><div><b>LIKE AND SUBSCRIBE!!!<br /></b>
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-20127317291056662132021-08-02T17:31:00.004-04:002021-08-02T17:31:58.715-04:00Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)I revisit an old video I did couple years ago showing how to pass collections from Power Automate to Power Apps. <br /><br /><div style="text-align: center;"><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/qUmi3JwjLfI" title="YouTube video player" width="640"></iframe></div><div style="text-align: left;"><br /></div><div style="text-align: left;">This time around, I show how to leverage arrays to accomplish the same. This time around you will learn about:<div><ul><li><a href="https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows" target="_blank">Power Apps trigger in Power Automate</a> </li><li><a href="https://docs.microsoft.com/en-us/connectors/sql/" target="_blank">Get Rows SQL action</a> </li><li><a href="https://docs.microsoft.com/en-us/power-automate/create-variable-store-values" target="_blank">Variables action</a></li><li><a href="https://docs.microsoft.com/en-us/power-automate/data-operations" target="_blank">Select action and Arrays</a></li><li>Response action</li><li><a href="https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-update-collection" target="_blank">Power Apps Collections</a></li></ul><div><br /></div></div></div>To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br /><b><br /></b><div><b>LIKE AND SUBSCRIBE!!!<br /></b>
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-22122277774171757742020-11-10T14:00:00.003-05:002020-11-10T14:00:18.226-05:00AI Builder Form Processing: Multi-layout Form ProcessingAI Builder Form Processing Multi-layout Form Processing has been one of the most requested features and is now available in preview for you to test. This feature allows you to process forms with a variety of different layouts (but similar in content) with a single model, which brings this feature one step closer to a scalable enterprise solution.<br /><br /><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/WL_eEOUK0fw" width="640"></iframe><br /><br />In this video I cover the following:<br /><br />- Creating a model<br />- Form collections<br />- Training the form processing model<br />- Publishing the form processing model<br />- Testing the model<br /><br />For additional information, please refer to:<br /><br />Create a form processing model - click <a href="https://docs.microsoft.com/en-us/ai-builder/create-form-processing-model">here</a><br />AI Builder form processing announcement - click <a href="https://flow.microsoft.com/en-us/blog/ai-builder-form-processing-models-can-now-train-using-documents-that-have-different-layouts/">here</a><br /><br />To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br /><b><br /></b><div><b>LIKE AND SUBSCRIBE!!!<br /></b>
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-66906673044693265072020-10-20T16:15:00.000-04:002020-10-20T16:15:06.079-04:00Power Platform: Application Lifecycle Management (Part 3/3) - Build and Release PipelinesWelcome to the final episode of Power Platform Application Lifecycle Management. In parts 1 and 2 you saw how to prepare your environments, set up an Azure DevOps project, and define Service Connections to your Power Platform environments. <div><br /></div><div>In this, the final installment of this 3-part series, you will learn how to create the Build and Release pipelines using the Power Platform Build Tools to take your Power Platform solution from an environment, through source code control, through staging and production deployments.</div><div><br />
<iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/NRLQeT0XP2M" width="640"></iframe>
<br /><br /></div><div>
Topics covered:<br /><br /></div><div>
- Power Platform source code control with Azure Repos<br />
- Build and Release pipelines<br />
- Sharing your solution<br /></div><div><br /></div>
References:<br /><br /><div>
Power Platform Build Tools webinar - <a href="https://youtu.be/Qwue8fwetJA">https://youtu.be/Qwue8fwetJA</a> <div>Solutions Overview and Limitations - click <a href="https://www.youtube.com/redirect?event=video_description&v=q2j3QO0iBSs&redir_token=QUFFLUhqbnVxcjViRmR5LWlsRDY4bGY2SGw1dzIwdmMtUXxBQ3Jtc0trRU5LNlA0U0VLRVJoSDRJckhFTnhKNFlZbElyVzJscEtWVy0tRndHTWF3V1pMdTR4cDNGR09SWnA0YnhHa3dEbFdjNlU5dVhBTURwaE9UT3hRdTl0YzM5ZmpQbmpuaFNNWDRucEh4ak5wY1c2MWtyNA%3D%3D&q=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fsolutions-overview">here</a><br />
<br />To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div></div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-56005198024118146522020-09-22T17:00:00.001-04:002020-09-22T17:00:03.836-04:00Power Platform: Application Lifecycle Management (Part 2/3) - Solutions and DevOpsIn the previous installment, you saw how to work through a set of prerequisites to get you going in your Power Platform Application Lifecycle Management journey. In this video, I will work through building an app and adding it to a solution and show you some additional Azure DevOps configuration options to link your repository to your Power Platform development environment.<br /><br />
<iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/q2j3QO0iBSs" width="640"></iframe><br />
<br />
Topics Covered:<br /><br />
1. Building app based on template<br />
2. Adding your app to a solution<br />
3. Linking your DevOps project to your Power Platform environment<br /><br />
References:<br />
Power Platform Build Tools webinar - <a href="https://youtu.be/Qwue8fwetJA">https://youtu.be/Qwue8fwetJA</a> <div>Solutions Overview and Limitations - click <a href="https://www.youtube.com/redirect?event=video_description&v=q2j3QO0iBSs&redir_token=QUFFLUhqbnVxcjViRmR5LWlsRDY4bGY2SGw1dzIwdmMtUXxBQ3Jtc0trRU5LNlA0U0VLRVJoSDRJckhFTnhKNFlZbElyVzJscEtWVy0tRndHTWF3V1pMdTR4cDNGR09SWnA0YnhHa3dEbFdjNlU5dVhBTURwaE9UT3hRdTl0YzM5ZmpQbmpuaFNNWDRucEh4ak5wY1c2MWtyNA%3D%3D&q=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fsolutions-overview">here</a><br />
<br />To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-79960610753462260702020-09-14T15:42:00.000-04:002020-09-14T15:42:03.074-04:00Power Platform: Application Lifecycle Management (Part 1/3) - PrerequisitesThis series is in response to multiple requests by my viewers to address the topic of Power Apps Application Lifecycle Management (ALM). This series is intended to breakdown the entire process in as much detail as possible, without lengthy explanations on how to get it done or, as often happens, little to no explanations on how you arrived at a particular step or result.<br />
<br />My first installment will focus on Prerequisites, this is, what you need to have in place to get started. I will walk you through provisioning your Power Platform Dev, QA, and Production environments, along with installing the Power Platform Build Tools and setting up your Azure DevOps project. I also explain the concept of solutions in Power Platform and why they are important to your ALM strategy.<br /><br />
<iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/6uQPDa4AxVA" width="640"></iframe>
<br />
<br />
Topics covered:
<br />
<br />
1. Creating Power Platform Environments<br />
2. Azure DevOps and Installing Power Platform Build Tools<br />
3. Creating an Azure DevOps Project<br />
4. Solutions<br />
<br />References:<br />
Power Platform Build Tools webinar - <a href="https://youtu.be/Qwue8fwetJA">https://youtu.be/Qwue8fwetJA</a>
<br />
<br />
Credits:<br />
Summer - Bensound - Royalty free music at <a href="https://www.bensound.com">https://www.bensound.com</a>
<br />
<br />
To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-39580984684017890632020-09-03T11:29:00.001-04:002020-09-03T11:29:14.859-04:00Power Automate: Transfer records from SharePoint list to Azure SQL databaseMajority of times, when we are working with various data sources, we want information to go from one source to another, conditioned to the occurrence of an event. Today, I will show you how to transfer records from a SharePoint list to Azure SQL database tables in response to a timesheet approval event. In the process, you will learn how I leveraged the existing Power Apps Expense template app and converted it into a Timesheet app for the purpose of recording time for various activities <div><br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/Xw4h7KECgNI" width="640"></iframe></div><div><br /><br /></div><div>Other topics covered:</div><div><br /></div><div><ul style="text-align: left;"><li>Working with SharePoint lists and Azure SQL databases</li><li>"When an item is created or modified" SharePoint connector trigger</li><li>"Delete Item" SharePoint connector action</li><li>"Get Items" SharePoint connector action</li><li>Conditional actions</li><li>Get Rows and Insert Row SQL connector actions</li><li>Apply to each action</li><li>substring(), formatDateTime()</li></ul></div><div><br /></div><div>Please leave your comments below and let me know what you think. Also, please feel free to suggest topics you would like me to cover. </div><div><br /></div><div>References:
Reza Dorrani - Expense Tracking Sample Power App with Receipt Scanning AI - <a href="https://youtu.be/1X8ihV_EGbE " target="_blank">Click here</a></div><div><br /></div><div>Credits:
Creative Minds - Bensound - Royalty free music at <a href="https://www.bensound.com">https://www.bensound.com
</a></div><div><br /></div><div>To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
</div><div><br /></div>
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-354926545674245002020-08-10T14:57:00.000-04:002020-08-10T14:57:00.325-04:00Power Apps: Save Mixed Reality pictures to SharePointIn this video you will learn how to save pictures taken in Power Apps Mixed Reality or Augmented Reality viewer to a SharePoint document library.<div><br /></div><div>
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/QDlN6CEHydk" width="640"></iframe> </div><div><br /></div><div>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.</div>
</a></div><div><br /></div><div>To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a></div>
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0Roswell, GA, USA34.0232431 -84.36155555.7130092638211565 -119.5178055 62.333476936178847 -49.205305499999994tag:blogger.com,1999:blog-5285970135510371565.post-9115196133131958052020-07-28T21:33:00.003-04:002020-07-28T21:33:46.088-04:00 Power Automate: Working with Microsoft Graph API and Teams ConnectorIn this video you will learn the basics of the Microsoft Graph API, how to use Graph Explorer, register an application to use Microsoft Graph in Azure Active Directory, and build a simple flow that will use the Teams Connector and Graph API to list a set of tabs in a Teams channel. <div>
<br />Other topics covered are: compose and HTTP actions, using the compose action as an alternative to variables, using the filter array action to filter the results in a JSON payload. </div><div><br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/E4Ve5frEO6s" width="640"></iframe>
<br /><br /></div><div>
References: <br />
Microsoft Graph: <a href="https://graph.microsoft.com">https://graph.microsoft.com</a> </div><div><br /></div><div>Credits: </div><div>Creative Minds - Bensound - Royalty free music at <a href="https://www.bensound.com">https://www.bensound.com
</a></div><div><br /></div><div>To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a></div>
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />
Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-40215789368035718592020-07-07T09:25:00.001-04:002020-07-07T09:25:35.136-04:00Power Automate: Calculate Soundex of a word with a flowIn this video, I will be showing you how to use Power Automate to calculate the
Soundex value of a word using a flow. This calculation uses the American
standard algorithm, but can be adapted to support other algorithms developed for
the English language.<div><br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="380" src="https://www.youtube.com/embed/AL92FNn5rtA" width="640"></iframe>
<br /><br />
In building the workflow you will learn how to use the
<b>Scope</b>, <b>Compose</b>, and <b>Append To String</b> actions, the Do Until and If Then control structures, along with the
<b>substring()</b>, <b>replace()</b>, <b>add()</b>, and
<b>mult()</b> functions. Please leave your comments below.
<br /><br /></div><div>
References:
<br />Wikipedia Soundex entry -
<a href="https://en.wikipedia.org/wiki/Soundex">https://en.wikipedia.org/wiki/Soundex</a>
</div><div><br /></div><div>
Downloads:
<br />Power Automate Cookbook: Click
<a href="https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Calculate-a-word-s-soundex-value-with-Power-Automate/td-p/616842">here</a>
</div><div><br /></div><div>
To check out my YouTube channel visit:
<a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />
</div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-1808694348704508092020-06-19T18:41:00.000-04:002020-06-19T18:41:18.093-04:00Power Automate: Building a REST endpoint with the HTTP Request connectorIn this video I show you how to build a REST endpoint with the Power Automate HTTP Request connector to be used as a web service to transfer data to a on-premises SQL database. In the process, I will be using Postman API development platform to test the endpoint and submit data to a Microsoft Dynamics GP company database via its eConnect API stored procedures.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/H9J68gCMbMs" width="640"></iframe><br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />
Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com3tag:blogger.com,1999:blog-5285970135510371565.post-53217720962701110622020-06-10T16:58:00.000-04:002020-06-11T14:43:36.934-04:00Power Apps: Calculating various dates with date functionsIn this article, I will show you how to leverage the <b>DateDiff()</b>, <b>DateAdd()</b>, <b>Weekday()</b>, <b>DateValue()</b>, and <b>Day(), </b>and <b>Today()</b> functions to calculate all sort of dates that are typical to business applications: first and last day of previous month, first and last day of previous quarter, first and last day of previous week, first and last day of current month, first and last day of current quarter, first and last day of current week, first and last day of next month, first and last day of next quarter, first and last day of next week, etc.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/sOmZP6twlyM" width="640"></iframe><br />
<br />
Let's begin:<br />
<br />
Each calculation is self-contained for convenience sake, which means the only dependency is on the <b>cdt</b> context variable.<br />
<br />
<b><u>Current Date</u></b><br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 40px; overflow: scroll; width: 640px;">
<pre>UpdateContext({cdt:Today()});
</pre>
</div>
Note: you could also use the Now() function, but be aware that this function also includes the timestamp.<br />
<br />
<b><u>First Day of Previous Month</u></b><br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
mts: DateDiff(
rootdate,
cdt,
Months
) - 1
},
DateAdd(
rootdate,
mts,
Months
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Previous Month</u></b><br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 40px; overflow: scroll; width: 640px;">
<pre>DateAdd(cdt, -Day(cdt), Days)
</pre>
</div>
<b><u><br /></u></b>
<b><u>First Day of Current Month</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
mts: DateDiff(
rootdate,
cdt,
Months
)
},
DateAdd(
rootdate,
mts,
Months
)
)
)
</pre>
</div>
<b><u><br /></u></b>
<b><u>Last Day of Current Month</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
mts: DateDiff(
rootdate,
cdt,
Months
) + 1
},
With(
{
FirstNxtMonth: DateAdd(
rootdate,
mts,
Months
)
},
DateAdd(
FirstNxtMonth,
-1,
Days
)
)
)
)
</pre>
</div>
<b><u><br /></u></b>
<b><u>First Day of Next Month</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
mts: DateDiff(
rootdate,
cdt,
Months
) + 1
},
DateAdd(
rootdate,
mts,
Months
)
)
)
</pre>
</div>
<u><b><br /></b></u>
<u><b>Last Day of Next Month</b></u>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
mts: DateDiff(
rootdate,
cdt,
Months
) + 2
},
With(
{
FirstNxtMonth: DateAdd(
rootdate,
mts,
Months
)
},
DateAdd(
FirstNxtMonth,
-1,
Days
)
)
)
)
</pre>
</div>
<br />
<b><u>First Day of Previous Quarter</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
qtrs: DateDiff(
rootdate,
cdt,
Quarters
)
},
DateAdd(
rootdate,
qtrs - 1,
Quarters
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Previous Quarter</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
qrtr: DateDiff(
rootdate,
cdt,
Quarters
)
},
With(
{
NxtQrtr: DateAdd(
rootdate,
qrtr,
Quarters
)
},
DateAdd(
NxtQrtr,
-1,
Days
)
)
)
)
</pre>
</div>
<br />
<b><u>
</u></b>
<b><u>First Day of Current Quarter</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
qtrs: DateDiff(
rootdate,
cdt,
Quarters
)
},
DateAdd(
rootdate,
qtrs,
Quarters
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Current Quarter</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
qrtr: DateDiff(
rootdate,
cdt,
Quarters
) + 1
},
With(
{
NxtQrtr: DateAdd(
rootdate,
qrtr,
Quarters
)
},
DateAdd(
NxtQrtr,
-1,
Days
)
)
)
)
</pre>
</div>
<br />
<b><u>First Day of Next Quarter</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
qrtr: DateDiff(
rootdate,
cdt,
Quarters
) + 1
},
With(
{
NxtQrtr: DateAdd(
rootdate,
qrtr,
Quarters
)
},
DateAdd(
NxtQrtr,
0,
Days
)
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Next Quarter</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
qrtr: DateDiff(
rootdate,
cdt,
Quarters
) + 2
},
With(
{
NxtQrtr: DateAdd(
rootdate,
qrtr,
Quarters
)
},
DateAdd(
NxtQrtr,
-1,
Days
)
)
)
)
</pre>
</div>
<br />
<b><u>First Day of Previous Week</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
diffval: DateDiff(
rootdate,
cdt,
Days
),
Offset: 1 - Weekday(cdt)
},
DateAdd(
cdt,
Offset - 7,
Days
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Previous Week</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
diffval: DateDiff(
rootdate,
cdt,
Days
),
Offset: 1 - Weekday(cdt)
},
DateAdd(
cdt,
Offset - 1,
Days
)
)
)
</pre>
</div>
<br />
<b><u>First Day of Current Week</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
diffval: DateDiff(
rootdate,
cdt,
Days
),
Offset: 1 - Weekday(cdt)
},
DateAdd(
cdt,
Offset,
Days
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Current Week</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
diffval: DateDiff(
rootdate,
cdt,
Days
),
Offset: 1 - Weekday(cdt)
},
DateAdd(
cdt,
Offset + 6,
Days
)
)
)
</pre>
</div>
<br />
<b><u>First Day of Next Week</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
diffval: DateDiff(
rootdate,
cdt,
Days
),
Offset: 1 - Weekday(cdt)
},
DateAdd(
cdt,
Offset + 7,
Days
)
)
)
</pre>
</div>
<br />
<b><u>Last Day of Next Week</u></b>
<br />
<div style="background-color: #f4f4f4; border-bottom: gray 1px solid; border-left: gray 1px solid; border-right: gray 1px solid; border-top: gray 1px solid; color: #3333ff; font: 12px / 12px "georgia" , "garamond" , serif; height: 227px; overflow: scroll; width: 640px;">
<pre>With(
{rootdate: DateValue("01/01/1900")},
With(
{
diffval: DateDiff(
rootdate,
cdt,
Days
),
Offset: 1 - Weekday(cdt)
},
DateAdd(
cdt,
Offset + 13,
Days
)
)
)
</pre>
</div>
<br />
You can download the application on the <a href="https://powerusers.microsoft.com/t5/Community-App-Samples/Power-Apps-Calculating-various-dates-with-date-functions/m-p/592175#M543">Power Apps Community apps gallery</a>
<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a>
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />
Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-12553447043008842182020-06-08T12:35:00.000-04:002020-06-08T12:35:42.866-04:00Power Apps: Mixed Reality spatial controlsFor the final installment of the Power Apps Mixed Reality series, I'm going to show you how to use the MR spatial controls, <b>Shape in MR</b> and <b>Measure in MR</b>. You will get to understand a bit more about the available properties for these controls and how they interact with collections and galleries to produce an app.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/OZQCWUEqjbg" width="640"></iframe>
<div>
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div>
Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-69562145181945891332020-05-28T23:43:00.003-04:002020-05-28T23:43:38.064-04:00Power Apps - Mixed Reality 3D Viewer and MR Viewer controlsIn this video, I show you how Power Apps Mixed Reality works from the ground up. We will build a simple app that leverages the 3D Viewer and MR Viewer controls to display a 3D model of Star Trek's USS Endeavour. Somewhere, I also introduce the use of the Power Apps Self operator and show you how you can capture images from your Augmented Reality (AR) experience and store them in a collection<div><br /></div><iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/pTgh6sqf8t8" width="640"></iframe> <div><br /></div><div>To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" /></div>Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-61763723415883260672020-05-28T23:37:00.000-04:002020-05-28T23:37:57.944-04:00 Fun and Non-Traditional uses for Power BI, Power Apps and Power AutomateIn this video, I teamed up with fellow Microsoft MVPs, <b>Belinda Allen</b> and <b>Daniel Christian</b>, to show some non-traditional use cases for Power Platform. You will see examples on motion and creating motion patterns for things like the Solar System in Power Apps, cool data analysis of everything from the lottery numbers to UFO sightings to fact checking politicians in Power BI, and a showcase of Star Trek's Starfleet with using mixed reality, along with some Galaga game concepts, all in Power Apps.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/jdGJMbr1Ba0" width="640"></iframe><br />
<br />
Recorded at the Virtual Power Platform World Tour held on May 14, 2020.<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-18947317640117538972020-05-06T16:59:00.000-04:002020-05-06T16:59:12.742-04:00#Hack4GoodMBAS 2020 Global HackatonThis past weekend, I was privileged to participate on the 24-hour <b>Hack4Good MBAS 2020 </b>global hackathon, carried out prior to the <a href="https://mymbas.microsoft.com/">Microsoft Business Applications Summit 2020</a>.<br />
<br />
The theme for this hackathon revolved around COVID-19 and challenged all participating teams to create innovative solutions leveraging the entire Microsoft stack to solve a single problem. The hackathon involved teams from across all continents.<br />
<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/F4AgG98EPFU" width="640"></iframe>
<br />
<br />
From left to right and top to bottom, me, <a href="https://thatapiguy.tech/"><b>Vivek Bavishi</b>,</a> <b><a href="https://www.youtube.com/channel/UClBCcDTylJUzvP8sycg6pEA">Jon Levesque</a></b>, <b><a href="https://www.youtube.com/user/apeyd41686">April Dunnam</a></b>, <b><a href="http://www.artisconsulting.com/geetha-sivasailam">Geetha Sivasailam</a></b>, and <b><a href="https://www.youtube.com/channel/UCv4gsiyRjfB9NlvPPBd2a3g">Joe Unwin</a></b>, collectively <b>Team FlowFam</b>.<br />
<br />
Our use of Microsoft Power Platform, Mixed/Augmented Reality, and advanced search and location services and data storage allows this solution to be used in several settings, but we decided to build a tool that could potentially help government and city planning officials, along with military engineers to quickly locate facilities and public spaces, measure and create floor plans, quickly calculate and plan bed space requirements, and place a request for beds to fill the space.<br />
<br />
This 5 minutes video summarizes our 24 hour effort - more to come!<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/j15u0kz1588" width="640"></iframe>
<br />
<br />
Here's the announcement by the judges evaluating the #Hack4GoodMBAS hackathon solutions. Our solution, <b>SpaceR</b>, was selected with one other among 11 teams participating across the Americas and has been entered into a pool of world finalists (APAC, EMEA, AMER) where it will be evaluated by a team of Microsoft judges.<br />
<br />
Winner will be announced at the next <a href="https://www.microsoft.com/en-us/businessapplicationssummit">Microsoft Business Applications Summit</a> which you can register and attend for free.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/QPs9lYmt6xo" width="640"></iframe><br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-45167227033444341712020-05-01T11:17:00.001-04:002020-05-01T11:17:29.460-04:00Power Platform Share with Steve, Mariano, and Belinda (Episode 7)I caught up with fellow MVP’s <a href="https://blog.steveendow.com/">Steve Endow</a> and <a href="https://belindathegpcsi.com/">Belinda Allen</a> again for our Power Platform Share and have invited a special guest, fellow MVP <a href="https://rezadorrani.com/">Reza Dorrani</a> to present some of the latest Power Platform features and stuff he's been working on. Suffice to say Reza blew us away with his COVID-19 tracker while showing some of the new mapping and geospatial capabilities available with Power Apps.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/TY1pNdTQ-4E" width="640"></iframe>
<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-19244048200665857312020-05-01T10:59:00.000-04:002020-05-01T10:59:02.740-04:00Working Remotely with Microsoft Dynamics GPI had a chance to sit down with fellow MVPs <a href="https://www.youtube.com/channel/UCEkrRBTOdi8YQJ-xuqfH1OA">Belinda Allen</a> and <a href="https://lifehacks365.com/">Shawn Dorward</a>, GPUG All*Star <a href="https://trainingbyamberbell.com/">Amber Bell</a>, and <a href="https://www.linkedin.com/in/zubingidwani/">Zubin Gidwani</a> from Dynamic Budgets to talk about "Work from Home" strategies with Dynamics GP amidst the Coronavirus stay at home orders<br />
<br />
Each one of us was tasked with presenting a rapid fire session outlining an approach to work remotely with Microsoft Dynamics GP.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/Hw4k-EIzB4g" width="640"></iframe>
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-27983456448388291162020-04-17T09:03:00.003-04:002020-05-28T23:06:01.195-04:00Power Apps - Introduction to Mixed RealityThis is the first video in a 2-part series that explains some of the basic concepts behind Mixed Reality. Learn what is a model, how you can compose a model file, pack it for consumption by Power Apps and having fun while doing it all.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/0Gicl6Y4y6g" width="640"></iframe><br />
<br />
Disclaimer:<br />
<br />
I am no mixed reality expert. This is just my personal experience trying to understand the elements and concepts behind it for the everyday citizen developer. I don't talk about Azure Mixed Reality or anything the Azure platform has to offer to developers. This is a simple "here's how you compose and pack a model for use with Power Apps Mixed Reality" video.<br />
<br />
References:<br />
<br />
GLTF to GLB Packer - click <a href="https://glb-packer.glitch.me/">here</a><br />
Microsoft 3D Viewer - click <a href="https://www.microsoft.com/en-us/p/3d-viewer/9nblggh42ths?activetab=pivot:overviewtab">here</a><br />
Microsoft Paint 3D support documentation - click <a href="https://support.microsoft.com/en-us/help/22881/windows-10-3d">here</a>
<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-64414655170659144482020-03-23T14:44:00.001-04:002020-03-23T14:44:48.532-04:00Power Virtual Agents - Create a Chat Bot for your on-premises ERPThis video shows how you can combine the power of Microsoft Power Virtual Agents chat bots and Power Automate flows with your on-premises data to provide an all around navigation-free user experience.<br />
<br />
While this video features Microsoft Dynamics GP as the on-premises ERP, technically speaking, you could create a chat bot for just about any ERP system in the market, whether on-premises or in the cloud. In fact, why stop at ERPs?<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/cKeFxMMIPGQ" width="640"></iframe><br />
<br />
Reference:<br />
<br />
Power Virtual Agents page - click <a href="https://powervirtualagents.microsoft.com/">here</a><br />
Use Power Virtual Agents Connector to build Power Automate flows for your bot - click <a href="https://powervirtualagents.microsoft.com/en-us/blog/use-power-virtual-agents-connector-to-build-power-automate-flows-for-your-bot/">here</a><br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-61904125823021515402020-03-14T15:10:00.003-04:002020-03-14T15:10:59.109-04:00Power Apps - Using Azure Text Analytics to monitor Coronavirus COVID-19 updatesIn this video I describe a Disease Monitor App I created as part of the #TemplatesForHumanity effort championed by Keith Wathling (Twitter: @KeithWathling) a couple years ago and that I have completely rehauled to support Coronavirus with an updated interface and approach to retrieve sentiment analysis with Azure Text Analytics.<br />
<br />
You will learn about:<br />
<ul>
<li>Using Text Analytics API in Power Apps (click <a href="https://powerapps.microsoft.com/en-us/blog/custom-connectors-and-text-analytics-in-powerapps-part-one/">here</a>)</li>
<li>Power Apps Collections (click <a href="https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect">here</a>)</li>
<li>Power Apps UpdateIf() function (click <a href="https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif">here</a>)</li>
</ul>
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/8vpP3_DVVzA" width="640"></iframe>
<br />
References:<br />
<br />
Download this app from my GitHub repo <a href="https://github.com/dgpblogster/DiseaseMonitoringApp">here</a>.<br />
#TemplatesForHumanity on Twitter <a href="https://twitter.com/search?q=%23templatesforhumanity&src=typed_query">here</a>.
<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-67028563827930144282020-03-05T20:04:00.000-05:002020-03-05T20:04:56.516-05:00Using Power Apps & Power Automate with On-Premises DataHello everyone!<br />
<br />
I sit down with <b>Samuel Adranyi</b> (<a href="https://twitter.com/sadranyi">@sadranyi</a>) from Ghana, on his Power Series show, to demystify the user of Microsoft Power Apps and Power Automate with on-premises data. We cover the On-premises Data Gateway, its architecture, hybrid connectors, and provide a couple samples on accessing on-premises ERP data with both Power Apps and Power Automate.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/bJ_i3ewKc0o" width="640"></iframe><br />
<br />
References:<br />
<br />
What is the On-premises Data Gateway? - click <a href="https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem">here</a><br />
Install an on-premises data gateway - click <a href="https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install">here</a><br />
<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-72251148772537212532020-02-22T12:43:00.000-05:002020-02-22T12:43:44.921-05:00Power Automate - Affirmation messages with Flic and the Twilio connectorIn this video you will learn how to setup a Twilio account, provision a phone number, and combine this with Flic and Power Automate to create an affirmation messaging system. You will also learn about the HTTP connector and the Parse JSON action. The result is this fun application of technology to deal with the everyday tensions in life. However, you can apply this to any areas of the enterprise, i.e., to create an emergency alert system or a company wide notification system.<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/C6N39j5h4SI" width="640"></iframe><br />
<br />
References:
Power Automate - Setting up and registering Flic hubs and buttons - <a href="https://youtu.be/PJbiS02pvEs">https://youtu.be/PJbiS02pvEs</a>
<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0tag:blogger.com,1999:blog-5285970135510371565.post-40588569343723793882020-02-14T14:57:00.000-05:002020-02-14T14:57:26.102-05:00Power Automate - UI flows IntroductionHello Friends!<br />
<br />
I had a chance to sit down with the incredible Jon Levesque, Senior Program Manager on the Microsoft Power Automate team to do a UI Flows 101 session. The result? A video with over 8K views!<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/W6-UptWrE14" width="640"></iframe>
<br />
<br />
This video covers the basics:<br />
<br />
1. How to get started<br />
2. Where to find the On-premises Data Gateway<br />
3. Installing the UI Flows desktop plug-in<br />
4. Types of UI flows<br />
5. A simple demo on how to automate a desktop application<br />
<br />
<b>References:</b><br />
<br />
UI Flows Setup documentation: <a href="https://docs.microsoft.com/en-us/power-automate/ui-flows/setup">https://docs.microsoft.com/en-us/power-automate/ui-flows/setup</a><br />
To download UI Flows Installer: click <a href="https://www.youtube.com/redirect?v=W6-UptWrE14&redir_token=WSsN78d55WVVRgefgJ98m9g8RLd8MTU4MTc5NTc2NUAxNTgxNzA5MzY1&event=video_description&q=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D2102613">here</a><br />
To download Selenium IDE for Web Automation: click <a href="https://chrome.google.com/webstore/detail/selenium-ide/mooikfkahbdckldjjndioackbalphokd">here</a><br />
To download the On-premises Data Gateway: click <a href="https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install">here</a><br />
<br />
With these items installed, you should be all set to follow along with me and Jon in this tutorial!<br />
<br />
To check out my YouTube channel visit: <a href="https://youtube.com/user/mgomezb1">https://youtube.com/user/mgomezb1</a><br />
<br />
LIKE AND SUBSCRIBE!!!<br />
<br />
Until next post!<br />
<br />
MG.-<br />
Mariano Gomez, MVP<br />
<img src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" height="1" mce_src="http://www.myworldmaps.net/map.ashx/8afd9933-b98d-4111-82fe-280b9e0f4122/ping" width="1" />Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.com0