Blogs

Be the first person to recommend this.
While working on a project at work, I came across a very interesting issue with a Microsoft PowerApps and Power Automate. A number of you probably already know this, but if you trigger a Power Automate Flow from a button within a PowerApps app, the Flow retains the context of the user account that  triggered the Flow and not the user account that was used to create the Flow. In most instances this is fine, but what happens when you trigger an approval workflow, that needs to update the content approval status of a list item? It would mean everyone would need an elevated level of access to the SharePoint list. What  if that was not an option? What if you only ...
0 comments
Be the first person to recommend this.
@Reza Rad   and @Leila Etaati  are both Microsoft MVPs, User Group All Stars & Academy instructors, well-known international speakers, best-selling authors, and avid bloggers about the Microsoft Power Platform - the true definition of a 'Power Couple'.  Dynamic Communities (DC): Leila, you were the first Microsoft AI MVP in New Zealand and Australia. What does that mean to you? Leila Etaati (LE): I was energized (and still am) by anything AI. Even the time that I was Data Platform MVP, I always did the data science and AI parts of it, and evangelized those parts. That led me to become the first AI MVP or let’s say double-sided ...
0 comments
Be the first person to recommend this.
Dear Dynamic Communities Members:   I hope you and your families are safe and healthy in these challenging times. As we all face the uncertainty of a COVID-19 world, we want to connect and share some important updates with our community members.   First, on behalf of the Dynamic Communities team, thank you. The onset of Covid-19 in March brought an unprecedented impact to community members around the world, and we want you to know how much we appreciate the users, partners and organizations who make up our diverse global community. We are listening. We understand the personal and professional challenges you are facing, and we will continue to be here ...
0 comments
Be the first person to recommend this.
If you are just getting started with Power BI you may be seeing a lot of references to a 'Calendar' Table or 'Date Table.  Maybe you already have a handle on this aspect of PBI, but a lot of people seem not to understand how to get started.  If you forego having a 'Calendar' Table altogether, you can end up having a very cumbersome file and you won't be able to take advantage of many of the awesome date/time functions offered through Power BI.  There are quite a few good resources already out there.  This post points you to a few of those and helps you get started in both M and DAX. To turn off Time intelligence - here is a great blog resource:  sqlbi - DAX ...
0 comments
Be the first person to recommend this.
Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. There are news stories published almost daily about data breaches and identity theft. To address this community need, Dynamic Communities has partnered with industry experts in the cyber security world to provide valuable information on how to protect your organization from cyber crime attacks. Join us for a tapas-style (small bits of learning on various topics), no-charge webinar series June 8-10, 2020. Cyber ...
0 comments
Be the first person to recommend this.
Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. There are news stories published almost daily about data breaches and identity theft. To address this community need, Dynamic Communities has partnered with industry experts in the cyber security world to provide valuable information on how to protect your organization from cyber crime attacks. Join us for a tapas-style (small bits of learning on various topics), no-charge webinar series June 8-10, 2020. ...
0 comments
Be the first person to recommend this.
What's your type? For a beginner in Power BI and in business intelligence in general, it is not easy to understand data types and differentiate them from data format. And then comes data category... So, what's all that about, really? It's true that in spreadsheet applications like Excel, data type is not really of a bother to the user, as there is no functionality to define the type of the data present in cells. We just enter values and it's all fine (somehow). In fact, I only started to bother about data types when starting to use Power Query, Power BI and Power Pivot (data modelling tool in Excel). Power Query is less friendly with typeless (or rather ...
0 comments
Be the first person to recommend this.
https://www.kaispe.com/generate-lead-record-in-microsoft-dynamics-crm-through-web-contact-form-using-ms-power-automate
0 comments
Be the first person to recommend this.
If we want to perform multiple actions Common Data Service at once , like creating/ updating 100 different records, Flow will make many different calls to CDS. Although it works fine, but it takes lot of time and keeping   limitations on number of requests   , this might not be a good approach. But, no worries , Microsoft is going to solve this by introducing   “Batch”   concept in flow. We can add a  Batch  scope to your flows that will group all these different operations into a single call to Common Data Service to dramatically improve performance. To use this, search for  Batch  under the  Common Data Service  connector. Once you add this ...
0 comments
Be the first person to recommend this.
I have come across a requirement to trigger flow when a record is updated and one of the fields contains data. We can achieve this using condition action . But there is a better way to do it using   Trigger Condition   setting in Power Automate and   functions  provided by the  Workflow Definition Language . Here are the steps. Step 1 :   Navigate to settings area. Step 2 :   Go to   Trigger Condition   and click on   Add Step 3 : Add condition to check if field contains data. Like this , multiple conditions can be added. And we can even use expressions like   and,or   to check multiple conditions. For more information about ...
0 comments
Be the first person to recommend this.
No matter how great we are in programming , sometimes our code has errors. They may occur because of our mistakes, an unexpected user input, an erroneous server response, and for a thousand other reasons. So handling these exceptions is very important . Anyone who has even a little experience with programming knows the   “try – catch”   to handle these exceptions. The same approach can be used in Power Automate / Flow to handle exceptions. In fact, we have a template in Power Automate templates gallery and it can be used straight away. https://flow.microsoft.com/en-us/galleries/public/templates/e8e028c6df7b4eb786abdf510e4f1da3/try-catch-and-finally-template/ ...
0 comments
Be the first person to recommend this.
Recently , I have come across this issue with Power Automate while I am trying to create a record using “Create a new record ” action with Common Data Service(Current environment) connector based on some trigger. I am not doing any complex stuff, just creating a quote line record and referencing a quote record. Referencing records is as simple as using dynamic content and populating it to a lookup attribute right !!! No, its not. Let’s see. I just run the flow with the above setup and flow run got failed with  “Resource not found for the segment ‘c262238e-fc89-ea12-ba11-000d3ab615df'” After some digging , found the cause. The new   CDS ( ...
0 comments
Be the first person to recommend this.
Hi Friend,  When New York was first picked as a stop on the Power Platform World Tour ,  the topic of how the Microsoft Power Platform was being used to influence change in the NY Taxicab system seemed fitting. Although Dynamic Communities has made the decision to take a virtual approach to this event to ensure the health and safety of our community, we still find value in sharing this story about big data and Power BI. Power BI Reporting and Integration with Azure Synapse Analytics Meet Jared Brown  and  Kenneth (KC) Philcox   from  Tallan – two guys who certainly get data and analytics. Their story is something you need to see ...
0 comments
Be the first person to recommend this.
See how can we use Azure Machine Learning services with Microsoft Power Automate https://www.kaispe.com/developing-custom-connector-in-ms-power-automate-using-azure-ml-services/
0 comments
Be the first person to recommend this.
Automation has always been a key to businesses to achieve higher productivity and lower the operating cost by avoiding repetitive tasks. With recent situation where social distancing is playing a major role handling the pandemic, businesses are focusing even more on process automation than ever before. Drones, robots, autonomous vehicles are contributing in the businesses and we have seen numerous cases where drones were used for goods delivery, robots were used to tighten the social lock down in streets etc. Software based Robotic Process Automation is emerging now on a rapid pace and companies like Microsoft has already been   investing   a lot in Robotic ...
0 comments
Be the first person to recommend this.
Hi folks! In the last few days we have observed several news about the Coronavirus that started in China and around the world today is globalized in several regions of the world! My concern is to understand the seriousness of this moment and nothing better than numbers to reach the conclusion that the situation is critical! See my dashboard, I would be grateful for your comment or suggestion for improvement! Link to report: https://app.powerbi.com/view?r=eyJrIjoiNDRhNjQwNjQtZjRlNC00NDEzLTljMGEtMGUxNDRhZTJiNzY2IiwidCI6ImRkYzM1ZDUzLTgxMzUtNDYyNy1hYzM3LWIwZjAwNjQwNGI3MSJ9 Thanks! Vithor da Silva e Silva | Power BI UG Leader - Vitória-ES / Brazil Blog:  ...
0 comments
Be the first person to recommend this.
The Dynamic Communities Power Platform User Group Team wants to take the opportunity to thank all of our User Group Leaders across the world for volunteering their time , energy and efforts to share , engage , and foster development in their local user group communities.    Reza Dorrani      Leader,  Houston Power Apps & Power Automate User Group   Microsoft Business Applications MVP   Principal Consultant at Catapult Systems  Twitter - @rezadorrani   YouTube -  https://www.youtube.com/channel/UCvBYTqRx-n_8KzFO0MJlUVw     This year alone Reza Dorrani  has contributed more than 30 community posts and ...
0 comments
Be the first person to recommend this.
Hi everyone. This is my first post (in Elnglish), and I hope you can help me. I have a table of dates with all the necessary fields ([Year], [Month], [MonthName], etc) I have another table 'Results' with records of various types (Sales, Returns, Discounts, etc; all these in a single field [Description]) and the value of each record per month [Amount]. I must say that this table is of monthly closing results, so two things happen: (1) to July I will have records until June of that year and (2) for each description there is only one record per month. Both tables are related by the [Dates] field. I want to do a sales analysis comparing one year X (the most recent ...
0 comments
Be the first person to recommend this.
Hola a todos. Este es mi primer post, espero que puedan ayudarme. Tengo una tabla de fechas con todos los campos necesarios ([Año], [Mes], [NombreMes], etc) Tengo otra tabla 'Resultados' con registros de varios tipos (Ventas, Devoluciones, Descuentos, etc; todos estos en un solo campo [Descripción]) y el valor de cada registro por mes [Monto]. He de decir que esta tabla es de resultados de cierre mensual, así que ocurren dos cosas: (1) a julio tendré registros hasta junio de ese año y (2) por cada descripción hay un sólo registro por mes.  Ambas tablas están relacionadas por el campo [Fechas]. Quiero hacer un análisis de ventas comparando un año X (el ...
0 comments
1 person recommends this.
Diseño de cuadros de mandos para auto servicio con Power BI ¿ Les ha pasado que dentro de una misma sección en un cuadro de mando de Power BI, algunos usuarios prefieren gráficas de barras y otros prefieren una tabla sencilla y y quedamos analizando como cubrir esa solicitud? ¿O que algunos usuarios solicitan ver indicadores de satisfacción del cliente, pero otros prefieren indicadores de desempeño de sus equipos? Si bien es cierto, podemos organizar cuadros de mandos que muestren la información en secciones y así darle la oportunidad a los usuarios que consulten el área de su preferencia, también podemos combinar todo dentro de una misma sección ...
0 comments