In this blog we will see how to add Search Box in Canvas App Step 1 –  Add text box in your screen. Hint text – Search Step 2 – Select Gallery and on items of the Gallery write your query Syntax – Search(DataSource,InputText.text,Attributename) for example – Search(‘Safety Checklists’,SearchBox.Text,”mc_name”) Output – Hope this helps !

Power Virtual Agents empower everyone from business users to developers to easily create and maintain bots using a guided, no-code graphical interface. For Steps to creating a Simple Bot visit: https://www.cloudfronts.in/how-to-create-a-bot-using-power-virtual-agents/ Let’s talk about Bot Lifecycle Create a bot PVA helps create bots using simple graphical interface, you do not need to be an expert or developer to develop the basic conversation bots using PVA. Get starter topics to build upon (FAQs, Sites,etc) You can directly use your existing FAQ pages and Sites in PVA and the AI will help create topics and bots from the same. Author topics with NL, Slot extraction, variables. Bots developed with PVA provide flexibility to add variables and conditions. Integrate Bot with backend APIs using Power Automate PVA can connect to your systems using Power Automate and perform actions. Publish bot to BF Channels Bots can be made easily accessible by publishing them to various channels available in PVA. You can add the bots to MS Teams, to your websites and even mobile. Monitor  bot performance and improve In the Business Summit 2020, Omar Aftab  and Cleber Mori  from Microsoft, provided customer examples of Power Virtual Agents: Government of India has been using it in its mygov.in Site Coca-Cola has PVA Bots for its Employees. MIAMI Dolphins uses PVA for Support and Sales Functions Also, the demo example showed how a bot can help increase your productivity with minimal efforts. Example: Get To do list from MS Planner The Bot with help of PVA will get all your to do list tasks from MS Planner. This bot was integrated with MS Teams and used Power Automate to connect with MS Planner. Booking slots in Calendar. This bot integrated in MS teams, with help of Power Automate will connect with Outlook Calendar. The Bot will initially ask the day of which available slots are needed. It will then ask to select from the available slots and ask to provide a topic for the task. Once the details are provided it will block that slot in your Calendar. Conclusion: Power Virtual Agents have great potential to increase productivity and reduce human efforts.

Power BI has some new features and Future Promises for Modern Enterprise applications in Business.

Dashboard is created to get a brief overview of your report by pinning visuals to an Existing dashboard or to a new dashboard. But sometimes it might be required to pin all the visuals of your page in the report to your dashboard. This blog will guide you through how this can be achieved.

Instead of viewing dashboard and report on Power BI Web Service, we can directly view it in CRM. We need to publish the Power BI dashboard to our CRM Environment. This Blog will guide you through it can be done.

This Blog will show you how you can Install and locate your Plugins in XRM new interface.

Introduction : Power Virtual Agents help us build simple and easy bots which can be integrated with websites, Microsoft teams, etc. Here are the steps to create a bot using PVA. Login to your environment in https://powervirtualagents.microsoft.com/en-us/ The pop up for create new bot will be visible, name the bot and create. Go to Topics Follow the numbers sequence in the below screenshot for the steps. After you click go to Authoring canvas, you can add messages, actions or call flows. This is where you write the responses and actions of your BOT, Topic Checker displays errors if any. You can test the Bot by clicking on “Test Your bot”, left bottom of the browser.You can check the working and update the bot topic  while testing by enabling the “Track between topics”. Conclusion: Publish the bot and click on demo website to the actual working of your Bot

Introduction: FAQ’s are meant to provide easy answers to User questions, but not always will the user like to read the entire FAQ page, in such situations we can provide the users with a BOT to answer their queries. This can be done using Power virtual Agents. Follow this simple steps to create your bot. 1) Login to Power Virtual Agents and go to topics 2) Go to Suggest topics 3) Paste the weblink of FAQ page, click add and then Start. 4) Once we get all the suggested topics, click add to existing to make it an existing topic. 5) Once added to existing, turn the topic on and test your bot. Conclusion: You can further embed the bot with your website and users will find it easy to access the bot instead of reading the FAQ page.

Introduction: This blog will guide you through how you can schedule your Pipeline in ADF with the help of scheduled trigger. The Time is crucial when you schedule your Pipeline. Go through all the steps to avoid the common mistake which you might make. Step 1: Click on Trigger and select “New/Edit”. Step 2: Click on “New”. Step 3: Select Type = “Scheduled”. Set the Start Date (UTC) and Time Recurrence to 1 Week(s) and Select the required Day(s). Step 4: Click on OK and Publish the changes. Step 5: The Time that you must enter here is in UTC, so convert the local time at which you want to schedule to UTC and set it accordingly. Use the following link to convert it. https://www.prokerala.com/travel/timezones/time-converter.php

In this blog we will learn how to delete duplicates records from a table in SQL Server. Let’s create a sample table for the demo. Step 1: Create temporary table called tmpTable as follows DECLARE @tmpTable TABLE(EmpID INT IDENTITY(1, 1), EName VARCHAR(50)) Step 2: Insert some record into the tmpTable table. INSERT INTO @tmpTable(EName) VALUES (‘Ricky’) INSERT INTO @tmpTable(EName) VALUES (‘Ricky’) INSERT INTO @tmpTable(EName) VALUES (‘Ricky’) INSERT INTO @tmpTable(EName) VALUES (‘Lloyd’) INSERT INTO @tmpTable(EName) VALUES (‘Lloyd’) INSERT INTO @tmpTable(EName) VALUES (‘Lloyd’) INSERT INTO @tmpTable(EName) VALUES (‘Jack’) Step 3: write SQL query from the tmpTable table Select * from @tmpTable The below screenshot shows the output of the query There are duplicate rows (1,2,3) and (4,5,6) for the Employee that have the same Employee name. To delete the duplicate rows from the SQL Server, you follow these steps Find duplicate rows using GROUP BY clause or ROW_NUMBER() or RANK() function. Use DELETE statement to remove the duplicate rows. Method 1: Find the maximum employee id from the table using GROUP BY function and delete those record that are not present in main table. DELETE FROM @tmpTable WHERE EmpID NOT IN ( SELECT MAX(tmp.EmpID) as [MaxEID] FROM @tmpTable as tmp GROUP BY tmp.EName ) Method 2: Using the common table expression (CTE) to delete duplicate rows: ;WITH tblTest AS ( SELECT EmpID , ROW_NUMBER() OVER (PARTITION BY EName ORDER BY EmpID) AS [RowNumber] FROM @tmpTable ) DELETE FROM tblTest WHERE RowNumber > 1 In this statement First, the CTE uses the ROW_NUMBER() function to find the duplicate rows specified by values in the EName columns. Then, the DELETE statement deletes all the duplicate rows but keeps only one occurrence of each duplicate group. Method 3: We can also delete duplicate row using RANK() as shown below : DELETE FROM @tmpTable WHERE EmpID IN ( SELECT a.EmpID FROM ( SELECT tmp.* , RANK() OVER (PARTITION BY EName ORDER BY EmpID) as [Rank] FROM @tmpTable as tmp ) as a WHERE a.Rank > 1 ) I hope this will help you.