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 ...
Welcome to Power-N-Apps! In this week’s video, the PowerApps Gaming guru Brian Dang shows us his scavenger hunt app, and we also discuss how to convert office 365 docs to PDF using Flow and then read it in PowerApps. Join us in this power journey and let’s learn together. Show notes To follow Brian on twitter: https://twitter.com/8bitclassroom To follow me on twitter : https://twitter.com/that_API_guy To follow me on my blog: https://thatapiguy.tech https://youtu.be/_NVU2jfG5Y8
[audio src="/uploads/2018/11/power-n-apps-e1.mp3"][/audio] Welcome to Power-N-Apps! You can think of it as “Power and Apps” , “Power in Apps” or as I pronounce it - “Power naps” :D . These sessions are equivalent to having “power naps” as these will give you the right amount of content to get you more energized and pumped about PowerApps and Flow. In these videos, we will build something from scratch, talk about the latest updates, review some cool PowerApps / Flows and also have Q&A throughout the session. In our first episode, we discuss about the new canvas apps sharing experience, display names of columns, Flow online conference & flow checker. We also demonstrate how you can send a contact card vcf file using flow and integrate it with PowerApps. And we show how PowerApps can be used to Gamify Physics. Looking forward to a great start! Join me in this power journey and let’s learn together. Link to show notes https://youtu.be/KDIwAk9WjUE ...
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”}) ...
Why this blog? I am having an amazing journey through the world of PowerApps and Flow. This platform has enabled the non-programmers/citizen developers like me to develop apps easily to simplify business processes(and sometimes just to have some “Nerdy Fun”). This blog is for the community to benefit from and to learn what I have already explored. Why “That API Guy”? One of the game-changing feature that was introduced by PowerApps and Flow was the ability to return data back to PowerApps from a Flow. This makes it possible to connect to any of the available APIs on the internet and get a plethora of data from these APIs (like Restaurant data from Yelp, Movie data, Walmart data, etc.) into PowerApps and boom! you can integrate multiple of these data-sets into one app or make it interact with your own data. Possibilities are endless! By now, you can realize that I am crazy about APIs and that’s why the name. I hope this blog helps all those who are either new to the platform or want to do some amazing (read cool/crazy) things with PowerApps and Flow. ...