Power Automate

If you or your organization uses Microsoft Bookings and would like to sync events from Microsoft Bookings to Dynamics or Dataverse or to any other calendar, then this blog post is for you. 👉 A while ago, I had a use case with a client where they were using Bookings to let their customers book a time-slot for a 1:1 feedback session as a part of annual customer survey. That time, there wasn’t a straight-forward way to sync events and also the Bookings API was in beta. Now, with the new Bookings connector in Power Automate, it should make things much easier. ...

Ever wanted to build your own photo library in an app without using much code? In this post, you will learn how to connect to the Google Photos API and get photos from your Google account in Power Apps / Power Automate. Before you start In order to build a custom connector for Google Photos and use it in Power Apps, you will need at-least these before you start building ...

If you want to find all the distinct records in your data-source like a SharePoint list, there is no “Distinct records” action or distinct expression that you can use in Power Automate (earlier called Microsoft Flow) . There is a simple way to do it using the union expression . This expression returns all the common items in two arrays. So, if we you use the union expression for an array on itself , it will return basically all the items, but the items that are there multiple times will be returned only once. Voila! You just found out the lookalike of ‘Distinct’ function in Power Apps. ...

If you are an Office 365 admin who wants to streamline requests to create teams in Microsoft Teams, this blog post was written exactly for you. Those who aren’t admins, share this blog post with your Office 365 admin and push them to implement this. It’s a win for all! Solution Overview Step 1 - Download the .zip package from my GitHub repo. Step 2- Install the flows and the Power App Import the following package in Power Automate / Power Apps in the following order - ...

In this post, you will learn how to connect to an API with OAuth 1.0 authentication in Power Automate. Using this connection, we will connect to Twitter API to post tweets with @mentions and also send DMs with quick actions. The Twitter connector available in Power Automate doesn’t allow user mentions and also doesn’t have an action to send DMs. Currently, it’s not possible to implement OAuth 1.0 directly in Power Automate as the HTTP action doesn’t have this type available in the list of authentication types. To overcome that, we will create an Azure function which connects to the Twitter API and then call the Azure function from Power Automate. Don’t worry if you haven’t created an Azure function before. I will walk through all the steps to create an Azure function as well ...

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. ...

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. ...