Embedded Canvas App - "We are having trouble displaying this app" Error

Issue Are you trying to embed a canvas app in a model driven app and seeing this error - “We are having trouble displaying this app”? We are having trouble displaying this app Solution There is a Canvas App Entity/Table that the user needs ‘Read’ access to. To provide this access, navigate to Advanced Settings -> Security -> Security Roles -> -> Customizations -> Canvas App -> Provide Read Access at Organization level ...

Mar 18, 2021 · 1 min · Vivek Bavishi

Setting goals for 2020

Happy new year!!! Do you like new year resolutions? Do you like setting personal goals every year? It’s the new year and the whole world is talking about taking new year’s resolutions. This year, the added layer of a new decade has made it even more exciting for some people. However, there are some people who don’t like to do it just for the sake of it, and then there is always this other group of people who just ask - “So how many days did your resolution last? 😏”. Recently, I have seen another group of people who just set goals for the year and work towards achieving them. ...

Jan 13, 2020 · 4 min · Vivek Bavishi

Validate a URL in PowerApps

Do you have a form where you ask a user to enter a website URL ? There is no direct way to validate URL in PowerApps today, however, you can use IsMatch function along with Regular Expressions to do this. Here is the expression you need to validate a URL - IsMatch(URL_Input.Text, "(?:http(s)?:\/\/)?[\w.-]+(?:\.[\w\.-]+)+[\w\-\._~:/?#[\]@!\$&'\(\)\*\+,;=.]+$") That’s it, now you can use this to change the border-color of the Text Input box so that the app user knows when he URL entered is incorrect. ...

Sep 18, 2019 · 2 min · Vivek Bavishi

PowerApps and Power Automate license based on Office 365 license

This blog post is based on the Licensing document released by Microsoft in April 2019. The intent of this blog post is to help you understand the licensing better based on the Office 365 license you currently have. If you have any of these Office 365 Licenses - Office 365 Business Essentials Office 365 Business Premium Office 365 A1 for Students Office 365 A1 Plus for Faculty Office 365 A1 Plus for Students ...

Apr 7, 2019 · 3 min · Vivek Bavishi

PowerApps Challenge

In this video we will show a step by step approach to solve the 3 tasks mentioned in this challenge by Audrie Gordon - Challenge Form Challenge 1. We will create a PowerApp with 2 data sources such that the user can read the data but can’t edit it. Challenge 2. Tracking inventory of PowerApps Swag using Flow. Challenge 3. Saving a photo to a Sharepoint Document library using Flow and adding some more meta-data to it. https://youtu.be/T7aLyuEwmw4 ...

Feb 3, 2019 · 1 min · Vivek Bavishi

Click-through PowerApps Analytics

Introduction This blog post will walk through a simple approach to create your own click-through analytics. Extend your reporting options to include statistics which will raise visibility into how your app consumers navigate your applications, enabling you to use data to validate assumptions on app usage and design. I have attached the MSAPP files and the datasource sample(excel spreadsheet) so you can play around with the app to understand it better and then implement the same approach in your apps. Workflow overview – To explore the app, follow these steps – Step 1: Install the app from the MSAPP file that I have attached below. Step 2: Save the excel spreadsheet “AnalyticsDemo.xlsx” in your OneDrive and add it as a data source in the app using the OneDrive connector. Step 3: After saving and publishing the app, open the app and click on some icons and navigate around the app. Check whether the data gets collected in the Excel Spreadsheet. (Note: Sometimes it may take a few seconds before the data gets updated so you might have to close and open the spreadsheet once) Step 4: Use the OneDrive excel spreadsheet as a data source in a PowerBI report and create different graphs/statistics based on what you would like to measure. Below is an example to get you started – Capturing Interaction points- The main functions that I have used to capture the user interaction are the Patch and Collect functions. To start with, you would probably like to collect some basic user information before you capture any further interaction points of that user. To do this, I used the below formula in the OnStart property of the app-Collect(AnalyticsDemo,{UserName:Office365Users.MyProfile().DisplayName,UserEmail:Office365Users.MyProfile().Mail,LoginDate:Today(),LoginTime:Text( Now(), "\[$-en-US\]hh:mm:ss" ),Latitude:Location.Latitude,Longitude:Location.Longitude})This will create a new record in the Excel data source and because we are using the OnStart property, the basic user information will get collected only once, i.e., when the app is opened by the user. For capturing user details, I have used the Office365users connector. For any further interaction points / clicks , I used the Patch function to update data in the record that was created above. Below is an example of the Patch function used in the OnVisible property of the Products screen –``` Patch(AnalyticsDemo,Last(AnalyticsDemo),{ProductScreen:“Y”}) ...

Nov 8, 2018 · 3 min · Vivek Bavishi