Copy Appointments from Microsoft Bookings to Dataverse or Dynamics

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

Jul 25, 2022 Âˇ 5 min Âˇ Vivek Bavishi

Get Distinct Records using the union expression in Power Automate

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

Apr 4, 2020 Âˇ 3 min Âˇ Vivek Bavishi

OAuth 1.0 Connection in Power Automate | Post Tweets with user mentions and send DMs using Twitter API

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

Feb 16, 2020 Âˇ 6 min Âˇ Vivek Bavishi

Stay hydrated 💧💧💧 using Microsoft Teams, Flow and PowerBI

Recently, I was looking for some app to remind me to drink water and monitor my waterintake. I know you might say - JUST REMEMBER IT YOURSELF! However, I am a geek who likes to use technology to give me some nudges. So, I reviewed a bunch of apps but none of them had the exact thing I was looking for. Some of them were too fancy and some were asking to PAY for the “pro” version. I was definitely not going to spend money to just give me reminders , so I ventured to build something from the Microsoft suite of tools which was more integrated with my work life and was the best way to actually make me drink more. ...

Aug 26, 2019 Âˇ 5 min Âˇ Vivek Bavishi

Quick Tip - Use Flow to publish your PowerApps on a regular basis

Flow Screenshot It is a good practice to publish all your PowerApps regularly as sometimes the enhancements/features don;t show up until you publish the app. You can use Flow and the “PowerApps for App Makers” connector to publish your apps on a regular basis. ( I do it on a monthly basis) Hope this helps. Link to the flow files here - https://github.com/thatapiguy/Publish-All-PowerApps-using-Flow/ Comments: Michael - Feb 5, 2023 ...

Jun 19, 2019 Âˇ 1 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

Alexa, ask Microsoft Flow to read out my latest e-mail

[tweet https://twitter.com/that_API_guy/status/1104836878107373570 ] I posted this on twitter and got a lot of requests to create a blog on this , so here you go - Why are we doing this? We are all surrounded by different smart home devices and voice assistants around us. Wouldn’t it be great if we could use them to - Add a task to To-Do Read email/ send email Read out calendar Create a meeting invite Add an item to SharePoint list and much more… What do we need? Microsoft Flow - If you don’t know what Microsoft Flow is , check out this video from Jon Levesque https://www.youtube.com/watch?v=FOr6wlH5Kgs and sign up for the free trial now! Alexa device / Alexa app Alexa Developer console account - Here is an overview of the developer console for your reference - https://www.youtube.com/watch?v=q-mrSBrlDso Concept - ...

Mar 11, 2019 Âˇ 7 min Âˇ Vivek Bavishi

Open Meeting Links Automatically on Desktop | Microsoft Flow

Frustrated with always opening the meeting invite and clicking on the join Skype / Teams meeting? Want to know how to automatically start the meeting window on your desktop a few minutes before any meeting starts? You are at the right place! What you need - Microsoft Flow Pushbullet Account Pushbullet API Access token (don’t get scared, it’s simple) That’s all you need to automate your online meetings. Step 1: Get the access token for Pushbullet API After signing up for Pushbullet, go to My account and click on “Create Access Token” Copy this token and save it in some document / sticky note. ...

Feb 17, 2019 Âˇ 2 min Âˇ Vivek Bavishi

Microsoft To-do! Due dates based on E-mail Importance

I recently read this blog post from Luise Freese about Microsoft To-do - 11 reasons why I fell in love with Microsoft To-Do and I couldn’t agree more. In-fact, I can add 10 more to that list! :) One of the reasons mentioned was around moving flagged e-mails to To-Do using Microsoft Flow . To take this a step further, I wanted a way to assign due dates and reminders for the e-mails based on some priority level. Below is a step-by-step approach to achieve this - Note: This applies only for desktop Outlook ...

Feb 4, 2019 Âˇ 4 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