Power BI

Hi & Welcome back to 24Days of PowerPlatform! In the past days, I’ve introduced the members of the #PowerPlatform family: Power BI, PowerApps, Microsoft Flow and the Common Data Model / S…

Power platform customer success story - Metro Bank used PowerApps connected to Dynamics 365 to improve the accuracy of estimated wait times and create a more personalized experience when customers walk into the bank.

Hi & Welcome back to 24Days of PowerPlatform! If your job includes building business applications, it is highly possible that you’ve re-implemented some sort of data models or entities in a nea…

The new options from the CDS and PowerApps canvas applications is to use relationships with 1 to many, or many to 1, however this is natively in the Dynamics 365 CE and now on CDS, but how we use these type of fields; for a technical CRM developer this was using the Code Value for the Optionsets and using the ID Guid for the Lookups, among other parts for the complex object. The new web API help to resolve or make it more interesting the way we use these 2 objects, let me get into the details on CRM before we get into the PowerApps Canvas App.

a couple of days ago, one of my friend challenged a group of "flowers" to come up with a Flow that converts a CSV file to whatever you want, in this specific case to JSON objects that can easily be tr…

As members of the PowerApps Customer & Partner Success team, we often get asked for resources to aid our customers on their PowerApps journey. Below is a set of links we've curated to help novice,…

Hi & Welcome back to 24Days of PowerPlatform! Today, I would like to introduce you to PowerApps. PowerApps allow you to quickly build business applications using various sources of data. Maybe …

In Microsoft Flow it is possible to use the Excel connectors to read data form a spreadsheet. there are however a few major issues with doing this: You data needs to exist within Excel Tables. Large t…

Over the last few weeks I have seen quite a few people asking questions about comparing two lists, synchronising lists and importing data into SharePoint lists. Within this post I'm going to include a…

The Common Data Model provides semantic consistency to data in Microsoft Azure Data Lake Storage Gen2 Preview.

We've added a new, rich HTML-based text editor that helps you write HTML-based emails and more. This editor allows you to customize the font, use bold, italic or underline, customize the color, and create lists or links. Partners have also released four new connectors: Imprezian360-CRM, Encodian, Soft1 , and <a href="https://flow.microsoft.com/connecto...

Read this blog post to create a sample PowerApps canvas app which uses an Azure function along with Azure Table Storage via custom connectors protected by Azure AD

When using PowerApps multi-line text inputs, behavior on line breaks is not always consistent. You may have also noticed that your Microsoft Flow approval comments will not (always) return line breaks…

In this article, I am going to explain how to send a mail on button click in PowerApps through Microsoft Flow. This article will help us to how to create flows , trigger from PowerApps, pass the dynamic values to flows etc.

Last year (in april 2017) I mentioned that I was a little bit worried that Microsoft Flow didn’t provide state machines workflows; I also mentioned that an easy way to achieve this was a loop…

In today’s digital world, organizations use and work with several applications for multiple different reasons. Often, data is stored and maintained in different applications and exchange of data…

Ok, here's a post to piggy-back off of my post regarding inbox sweep rules! A common scenario for many organizations and users is the need to organize images or documents that are sent from external s…

In this post, we will see how to implement a cascading dropdown list within the PowerApps application for a list with the two lookup columns where it has to display only the parent values if there are any associated child items. List data setup: SharePoint list “CarGroup” with the following data. Tata Motors Fiat Chrysler […]

A frequent pattern implemented in PowerApps is to have some form of debug buttons or panels that are only displayed when the Makers of the…

Recently a customer asked if PowerApps can support role based security controlled by SharePoint Security Groups. For example, can you make an Admin screen that is visible only to users who belong to a…

In the first part of this series we walked through creating multi-step form indicators in PowerApps. This post will help build a simple secondary navigation scheme using breadcrumbs to in…

According to the Endowed Progress Effect (which is a phenomenon integrated into designing any UX process based on how the human brain makes decisions) we’re more likely to complete an action if the…

I have a dropdown list and i want to set that the default value when the formmode is new to a character like "-" and when the formmode is somethings else it will go with the ThisItem.VariableName So if the dropdown list is named country then the function would have been. If(SharePointForm1.Mode...

I created a purchase request app with two galleries connected to their own SharePoint List, "RequestList" and "ItemsList." The user clicks on the "RequestGallery" and it loads the "ItemsGallery." The user can then add/edit/delete items associated to their purchase request. All rows in the ItemsList...

Sometimes, the new connectors are added to Microsoft Flow that open up a lot of options. One of those connectors was added to Flow last night. The Encodian connector makes it possible to do a lot w…

This app simulates the motion of throwing a ball based on concrete physics. Time development of ball is basically given by the motion of projectile with gravity and air resistance (See attached photo), also I have implemented effects of bounce and reflection.

From Tableau to Power BI and Qlik to Alteryx, pick your tool and there’s a good chance you can integrate it with DataRobot. The key lies in the API. One of the most challenging aspects of any data pro…

I love these little wins that truly highlight the power of Office 365! Here’s my use case: in the Boston office of Slalom, we have an annual Learning Day that everyone is required to attend. …

For those who work with primary and foreign keys on CDS and SQL Server, we have added GUID as a first class data type. Although not common, you may want to beat the rush and start updating any formula…