Posts

Power Virtual Agents and its Components

Image
Power Virtual Agents is a Microsoft platform that allows users to create chatbots and conversational AI experiences without the need for extensive coding or development skills. It's designed to enable business users and subject matter experts to create and deploy chatbots quickly. The important components of Power Virtual Agents include: Bot Framework: Power Virtual Agents is built on top of the Microsoft Bot Framework, which provides the underlying technology for creating, managing, and deploying conversational agents. Bot Topics: Bot Topics are at the core of Power Virtual Agents. They define the conversational flows, responses, and actions that the bot will take in response to user inputs. Topics are created using a graphical interface, allowing you to define triggers, user messages, and bot responses. Triggers: Triggers are conditions or user inputs that initiate a bot conversation. These could be keywords or phrases that users type or select. Triggers determine which bot t...

New feature of Power Automate in the last year

Image
 Let review some new features that came out in the last year or so in Power Automate. Copilot for Power Automate: This new feature allows you to create automations using natural language. You can simply type out what you want the automation to do, and Copilot will suggest actions and connectors that you can use. You can use Copilot to create an automation that sends you an email notification when a new lead is created in your CRM system. You can simply type out something like "create an automation that sends me an email when a new lead is created in Salesforce" and Copilot will suggest the actions and connectors that you need to use. Actions SDK for desktop flows: This new SDK allows developers to create custom actions for desktop flows. This can be used to automate legacy apps and systems that don't have native connectors in Power Automate. You can use the Actions SDK to create a custom action that opens a specific file in a text editor. This can be used to automate tas...

Steps to Integrate ChatGPT with Power Automate

Image
Integrating ChatGPT with Power Automate (formerly known as Microsoft Flow) can enable you to leverage the power of AI chatbots in your workflows and automate various tasks. Here's a step-by-step guide on how to integrate ChatGPT with Power Automate, along with some examples: Set up a ChatGPT API: You need to have access to an API that allows interaction with ChatGPT. There are various providers available, including OpenAI's GPT-3.5 API. You'll typically need an API key to authenticate your requests. Create a new Power Automate flow: Log in to the Power Automate portal (https://flow.microsoft.com/) and click on "Create" to start a new flow. Define a trigger: Choose an appropriate trigger for your workflow. For example, you might want to trigger the flow when a new email arrives, when a form is submitted, or when a specific event occurs in another application. Add an action: Click on the "+" icon to add an action to your flow. In the search bar, type ...

Alternate tools to Power Automate

Image
Power Automate is a powerful workflow automation tool, but there are several other competitive tools available in the market. Here are a few popular alternatives to Power Automate and how Power Automate compares to them: Zapier: Zapier is a widely-used automation platform that allows you to connect different apps and automate workflows. Power Automate offers more advanced capabilities, such as integration with Microsoft products and services, extensive connectors, and a larger set of triggers and actions. Pricing: Zapier offers a free plan with limited features and paid plans starting at $19.99 per month. Power Automate has a free plan with limited features, and premium plans start at $15 per user/month for the per-user plan and $500 per flow/month for the per-flow plan. Integromat: Integromat is another popular automation platform that integrates various apps and services. Power Automate provides a more user-friendly interface and integrates seamlessly with Microsoft applications and ...

Megam Talks Episode 14 : DevOps (Tamil)

Image
In the recent episode (Episode 14) of Megam Talk, we explored the topic of DevOps in-depth. We began by discussing what DevOps is and how it has revolutionized the software development process compared to the practices prevalent in the 2000s. In the past, building and deploying software would typically take around two days, but with the adoption of DevOps principles, this time frame has significantly reduced. During the episode, we highlighted the various user roles in DevOps and their responsibilities within the development and operations teams. We emphasized the collaborative nature of DevOps, where developers, operations personnel, and other stakeholders work together to streamline the software delivery process. We dedicated a segment to version control in VSTS (Visual Studio Team Services), covering popular version control systems such as Git and Visual Studio Team Foundation. Additionally, we discussed other version control options available in the market. Furthermore, we provided...

Megam Talks : Episode 13 Power BI (Tamil)

Image
In the latest episode of 'Megam Talks,' we delved into the topic of Power BI, which is recognized as one of the prominent business intelligence (BI) tools in the market. During the episode, we dedicated significant time to discussing dashboards, exploring their functionalities, and highlighting their significance within the BI landscape. Moreover, we provided insights into other leading BI tools like Tableau, Power BI, and SAP BI, comparing their features and capabilities. In addition to that, we explored the various connectors available for Power BI, which allow seamless integration with diverse data sources. We discussed the importance of these connectors in enabling data consolidation and analysis within Power BI. We also touched upon how Power BI fits within the broader Power Platform ecosystem, emphasizing its integration capabilities with other Microsoft tools. Furthermore, we shed light on the licensing model associated with Power BI, providing an overview of the availab...

Challenges with Power Automate

Image
Power Automate, formerly known as Microsoft Flow, is a cloud-based service that allows users to create automated workflows between different applications and services. While Power Automate offers numerous benefits, there are also several common challenges that users may encounter. Some of these challenges include: Complexity: Power Automate can be complex, especially for users who are not familiar with workflow automation concepts or have limited technical expertise. Creating and configuring workflows may require a learning curve and some level of technical proficiency. Integration limitations: Power Automate integrates with a wide range of applications and services, but there may be instances where certain integrations are not available or have limited functionality. This can create challenges when trying to automate workflows involving specific tools or platforms. External service dependencies: Power Automate relies on external services and APIs to connect with various applications...

Scope : is it really that useful?

Image
In Power Automate, the "Scope" action is used to group a set of actions together and define the error handling behavior within that scope. It allows you to specify how errors are handled and what actions should be taken if an error occurs within the defined scope. Let's dive into an example to illustrate the use of the Scope action: A simple Use Case: Expense Approval Workflow Scenario: You want to create an expense approval workflow where employees submit expense reports, and managers review and approve them. In this workflow, you need to handle errors that may occur during the approval process. Start with a trigger: Begin your Power Automate flow with an appropriate trigger, such as when a new item is created in a SharePoint list or when an email is received. Add a Scope action: Drag and drop the "Scope" action from the actions list to create a new scope within your flow. Configure the Scope action: Name the scope, such as "Expense Approval Scope." S...
Image
 Today's episode we talked elaborately about NFT. Play the below to access the full episode Non-Fungible Tokens (NFTs) have gained significant attention in recent years as a revolutionary concept in the world of digital ownership. From artwork and collectibles to virtual real estate and music albums, NFTs have transformed the way we perceive and trade digital assets. This article delves into the intricacies of NFTs, exploring their definition, technology, use cases, challenges, and potential impact on various industries. Understanding NFTs: 1.1 Definition and Characteristics: Learn what exactly NFTs are and how they differ from traditional cryptocurrencies like Bitcoin or Ethereum. Understand the unique characteristics of NFTs, including indivisibility, verifiability, and ownership attribution. 1.2 Token Standards: Explore popular NFT token standards such as ERC-721 and ERC-1155, which define the technical specifications and interoperability of NFTs on blockchain networks. Technolo...

Use Case for Power Automate and Power BI integrations

Image
The integration between Power Automate and Power BI opens up several interesting use cases that combine the power of workflow automation with data visualization and analysis capabilities. Here are some examples: Automated data refresh: Power Automate can be configured to trigger the refresh of Power BI datasets. For example, you can create a workflow that runs on a scheduled basis (e.g., daily, weekly) and refreshes the dataset connected to a specific data source. Alternatively, you can set up a workflow that triggers a refresh when certain conditions are met, such as when new data is added to a connected database or when an API endpoint provides an update. Data-driven alerts and notifications: Power Automate can monitor specific data thresholds or conditions in Power BI reports or dashboards and trigger automated alerts or notifications. For instance, you can set up a workflow that checks a sales report daily and sends an email notification to the sales team if the total sales for t...

What it takes to build a Power App

Image
 Building apps with Power Apps involves the following steps: Define app requirements: Start by clearly defining the requirements and objectives of your app. Determine the purpose, functionality, and desired user experience of the app. Identify the data sources and integrations that the app needs to connect with. Choose the app type: Power Apps offers different app types to suit various needs. Select the appropriate app type based on your requirements: Canvas app: Provides a flexible, drag-and-drop interface for designing custom apps from scratch. Model-driven app: Offers a data-driven approach using pre-built components and a standardized user interface. Design the user interface: Use the Power Apps Studio to design the app's user interface. Add screens, controls, and elements such as buttons, text inputs, galleries, forms, and navigation controls. Customize the layout, color scheme, and branding to match your desired design. Connect to data sources: Power Apps allows you to co...

Megam Talks Episode 10 : 5G (Tamil)

Image
Tune into "Megam Talks" episode 10 to learn more about 5G in tamil. 5G technology is the fifth generation of wireless network technology that offers faster data transfer rates, lower latency, and increased connectivity compared to 4G. The 5G network is designed to handle the increasing demands of data transfer and the growing number of connected devices, particularly with the proliferation of Internet of Things (IoT) devices. The 5G technology is talkative because it has the potential to revolutionize the way we use the internet and interact with technology. The faster data transfer rates and lower latency of 5G can enable new applications and services that were not possible with previous generations of wireless networks. For example, 5G can support the development of autonomous vehicles, remote surgery, virtual and augmented reality, and smart cities. 5G is better than 4G because it offers several advantages over previous wireless network technologies, including: Faster Dat...

ChatGPT in Power Platforms

Image
 Suhail and me did an episode (tamil) on chatGPT few days ago but I would like add and elaborate on how chatGPT is used on Power platforms here. ChatGPT can be used in Power Platforms to provide conversational interfaces that allow users to interact with the platform using natural language. This can help simplify the user experience and enable users to quickly and easily access information and perform tasks. Here are some specific areas where ChatGPT can be used within Power Platform: Power Virtual Agents : Power Virtual Agents is a low-code tool that allows users to create and deploy chatbots using natural language processing. ChatGPT can be integrated with Power Virtual Agents to enhance the chatbot's ability to understand and respond to user input. Power Automate : Power Automate is a workflow automation tool that allows users to create automated processes to streamline business operations. ChatGPT can be integrated with Power Automate to provide conversational interfaces for tr...

Megam Talks Episode 9 : ChatGPT (Tamil)

Image
ChatGPT is a large language model developed by OpenAI, based on the GPT (Generative Pre-trained Transformer) architecture. ChatGPT is trained on a vast amount of text data to generate human-like responses to a wide variety of questions and prompts. The purpose of chatGPT is to assist users in generating natural language text, answering questions, and engaging in conversation. Vinod and Suhail discussed the evolution of ChatGPT through OpenAI in the 'Megam Talks' episode 9 to highlight the technical advancements and capabilities of the language model. ChatGPT is a language model that uses deep learning algorithms to generate natural language responses to a wide variety of prompts, while search engines rely on algorithms to retrieve relevant information from a vast amount of indexed web pages. One of the main differences between ChatGPT and a search engine is that ChatGPT generates human-like responses that are contextually relevant and personalized to the user's input, whil...

Megam Talks Episode 8 : Microsoft Power Pages (Tamil)

Image
  Tune into the "Megam Talks" episode 8 for learning about Power Pages in Tamil. Microsoft Power Pages is a secure, enterprise-grade, low-code software as a service (SaaS) platform for creating, hosting, and administering modern external-facing business websites. Whether you're a low-code maker or a professional developer, Power Pages enables you to rapidly design, configure, and publish websites that seamlessly work across web browsers and devices. #megamtalks

Megam Talks Episode 7 : Microsoft Teams (Tamil)

Image
 #megamtalks Microsoft Teams is a popular communication and collaboration platform designed for teams and organizations. It provides a range of features that enable remote work, such as chat, video conferencing, file sharing, and collaboration tools. One of the main reasons Microsoft Teams is so popular is its integration with other Microsoft products, such as Microsoft Office, SharePoint, and OneDrive. This integration allows users to seamlessly access and collaborate on documents and files within the Teams platform, making it a convenient all-in-one solution for remote work. Another factor that has contributed to Teams' popularity is its security and compliance features. Teams is built on top of the Microsoft 365 platform, which has a robust security framework that meets industry standards and regulations. This makes it a popular choice for organizations that require strict security and compliance standards. In comparison to Zoom, Microsoft Teams has several advantages. For exam...

PowerApps - Merge Two Collections and Remove Duplicates

One of my Project got a requirement to combine two Collections and Remove the Duplicates while Combining in to a single collection. For Example i have two Collections, StudentDetails - Columns StudentID, Name, Age, DateOfBirth StudentMarks - Columns StudentID, Subject1Marks, Subject2Marks, Subject3Marks Now I want to merge these two collections without having the Duplicate data. I have used following formulae to combine the two collections into new collection StudentsCollections With(    {       StudentInfo1:       ShowColumns(          'StudentDetails',           "Name",          "Age",          "DateOfBirth"       ),       StudentInfo1:       ShowColumns(          'StudentMarks',           "StudentID",          ...

Power Platform - Recover Deleted Environments

Image
 As Power Platform admin users can recover the deleted environments. Microsoft only past 7 days deleted items. Following are steps to recover the deleted items, Open Power Platform Admin page on URL - https://admin.powerplatform.microsoft.com/ (only admin users will have the option to recover the environment) Click on Environments in the left Navigation In the Ribbon, Click on "Recover Deleted environments". It will navigate the Deleted Environments page. Select the Environment and click on "Recover". We will get a confirmation Pop-Up. Click on "Continue" button to confirm the recovery It may take hours to complete the restore the environment. 

Megam Talks Episode 6 : Microsoft Power Automate (Tamil)

Image
 #megamtalks Microsoft Power Automate , previously known as Microsoft Flow, is a cloud-based service that allows users to create automated workflows between various applications and services. It provides a visual interface for creating and managing workflows, and integrates with a wide range of external applications and services, including SharePoint, OneDrive, Salesforce, and more. One reason why Power Automate is an important tool is that it can help automate repetitive and time-consuming tasks, allowing users to focus on more important and strategic work. For example, users can create workflows to automatically send notifications, update data, and perform other tasks based on specific triggers or events. In the " Megam Talks " episode 6 , Power Automate was identified as a very popular tool for workflows and integration to external applications because it provides a simple and flexible way to automate processes across multiple systems and applications. The visual interface...

Powe Automate - Get Team Web URL

Image
 While working with Power Automate flow, i had a requirement to pull the web url of the Teams. Using the Get Team Information, i am able to get the ID of the teams not the Site URL. By using Graph API and sending the requests i am able to get the details required. Here are the steps i have followed to get the information. Add Action, Get Teams. Enter the Team ID/Name. Then call HTTP Request as below. We get the Teams details from Graph API. To get the URL, by using following expression, we can get the Teams URL. outputs('Send_an_HTTP_request')?['body']['weburl'] Hope this helps.