Unlocking Efficiency: A Beginner’s Guide to RPA Desktop Flows in Power Automate
Inkey Solutions, December 13, 20242153 Views
As per the beginner’s knowledge, RPA (Robotic Process Automation) Desktop flows, also known as UI flows, are a feature within Microsoft Power Automate that allows users to automate repetitive tasks on their Windows desktop or web applications. Desktop flows are part of the broad Power Automate platform, providing a solution for automating processes that involve… Continue reading Unlocking Efficiency: A Beginner’s Guide to RPA Desktop Flows in Power Automate
Read moreHow to Populate Prefix in AutoNumber fields based on conditions in Dynamics 365 Sales
Inkey Solutions, December 10, 2024873 Views
Maintaining organized and meaningful data is crucial for effective management and analysis. AutoNumber fields are a popular solution for generating unique identifiers, but sometimes a simple numeric sequence isn’t enough. By adding prefixes based on specific conditions, you can enhance the context of your data, making it easier to identify and categorize records briefly. In… Continue reading How to Populate Prefix in AutoNumber fields based on conditions in Dynamics 365 Sales
Read moreHow to use Low-No Code Plugin using Data verse accelerator in dynamics 365
Inkey Solutions, December 6, 20241015 Views
As everybody knows, in Dataverse, if we need to do anything that is not available in OOTB functionality and crucial to implement, we need to use plugin. To write a plugin, we need to write a code to mitigate our functionalities. But now, we do have another option available that will help us to create… Continue reading How to use Low-No Code Plugin using Data verse accelerator in dynamics 365
Read moreHow to run OOTB Report and send emails with pdf attachments using Power Automate.
Inkey Solutions, December 3, 2024855 Views
These days a speedy-paced business environment and efficient reporting equipment are crucial. Dynamics 365 is a powerful CRM and ERP answer that offers robust reporting capabilities. However, exporting those reports in a consumer-friendly format, like PDF, can on occasion be difficult. Fortunately, Power Automate gives a streamlined way to automate this method. In this blog,… Continue reading How to run OOTB Report and send emails with pdf attachments using Power Automate.
Read moreSplit the Text files using ADF Pipelines
Inkey Solutions, November 29, 2024603 Views
Requirements: If the file size of an Excel file exceeds the specified criteria, we need to address the following: The Excel file contains multiple sheets, and these sheets contain inter-related data. We utilize SQL Views to retrieve data from these sheets using the “Get Data” activity in Excel. Although we can split the Excel file… Continue reading Split the Text files using ADF Pipelines
Read moreHello world!
WebSiteAdmin, November 29, 2024259 Views
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
Read moreHow Microsoft Power BI Services are Better Than Excel: An Informative Guide for Business Owners and Beginners
WebSiteAdmin, November 26, 20241108 Views
For many years, Microsoft Excel has been a trusted tool for managing data, creating charts, and performing calculations. It’s often one of the first tools people reach for when working with numbers and has a special place in nearly every business. However, as businesses grow, so does the need for more powerful tools. Enter Microsoft… Continue reading How Microsoft Power BI Services are Better Than Excel: An Informative Guide for Business Owners and Beginners
Read morePaper to Power App: Creating a Canvas App in D365 CRM from a Hand-Drawn Sketch
WebSiteAdmin, November 19, 2024605 Views
Power Apps, known for its low-code/no-code capabilities, now offers the ability to create complete apps from an image. Sometimes, the best way to design an app starts with something as simple as a pen and paper. Whether you’re in a meeting, brainstorming with your team, or just working through ideas on your own, sketching out… Continue reading Paper to Power App: Creating a Canvas App in D365 CRM from a Hand-Drawn Sketch
Read moreThe Benefits of Moving to Microsoft Fabric: What Every Leader Should Know
WebSiteAdmin, November 15, 2024701 Views
As the digital world continues to evolve, business leaders face constant pressure to make technology decisions that will position their organizations for success. One of the most critical decisions today is choosing the right data and analytics platform—one that is flexible, secure, cost-effective, and built for the future. Microsoft Fabric has emerged as a powerful,… Continue reading The Benefits of Moving to Microsoft Fabric: What Every Leader Should Know
Read moreHow Microsoft Fabric Helps You Make Data-Driven Decisions Without the Tech Jargon
WebSiteAdmin, November 12, 2024427 Views
In today’s fast-paced business world, making decisions backed by data is essential. But for many decision-makers, accessing useful insights can be challenging because data tools often require technical expertise. This is where Microsoft Fabric steps in. Microsoft Fabric is a data analytics platform designed to make understanding and using data easy for everyone—especially those who… Continue reading How Microsoft Fabric Helps You Make Data-Driven Decisions Without the Tech Jargon
Read more5 Ways Microsoft Fabric Can Improve Your Business Operations
WebSiteAdmin, November 8, 2024415 Views
In today’s fast-paced business world, efficiency, informed decision-making, and seamless collaboration are key to staying competitive. Microsoft Fabric, a modern data platform, brings all these benefits together by unifying analytics, storage, and collaboration in one place. Here’s how Microsoft Fabric can positively impact your business operations and empower your team, even if you aren’t tech-savvy.… Continue reading 5 Ways Microsoft Fabric Can Improve Your Business Operations
Read moreThe Real Cost of Data Silos: Why Microsoft Fabric is Essential for Unified Data Access
WebSiteAdmin, November 5, 2024427 Views
In today’s fast-paced world, data is at the heart of business success. Whether you’re running a small business or a global corporation, your data has the potential to unlock valuable insights, drive smarter decisions, and keep you one step ahead of the competition. However, many companies face a common but critical roadblock that keeps their… Continue reading The Real Cost of Data Silos: Why Microsoft Fabric is Essential for Unified Data Access
Read moreWhy Business Central is the Smarter Choice for Financial Control and Cost Management
WebSiteAdmin, October 29, 2024416 Views
In today’s fast-paced business world, financial control and cost management are at the core of every successful company. Without a clear view of finances, businesses can find themselves overspending, missing financial opportunities, or struggling to compete. Microsoft Dynamics 365 Business Central is a powerful tool that’s helping businesses make smarter financial decisions, save money, and… Continue reading Why Business Central is the Smarter Choice for Financial Control and Cost Management
Read moreWhy Business Central’s Features Go Beyond Basic Accounting Solutions
WebSiteAdmin, October 25, 2024423 Views
When businesses consider upgrading their accounting software, they often look for a solution that manages their finances smoothly, keeps their records accurate, and complies with tax regulations. Microsoft’s Business Central offers all of that—and so much more. But why does Business Central stand out, especially for companies looking for more than just accounting software? Let’s… Continue reading Why Business Central’s Features Go Beyond Basic Accounting Solutions
Read moreTop 5 Growing Pains of Small Businesses and How Business Central Solves Them
WebSiteAdmin, October 22, 2024715 Views
Growing a small business is an exciting journey, but with growth comes challenges, or what many call “growing pains.” These growing pains can hold businesses back if they’re not addressed properly. Fortunately, tools like Microsoft Dynamics 365 Business Central (BC) can help ease these struggles and set businesses up for long-term success. In this blog… Continue reading Top 5 Growing Pains of Small Businesses and How Business Central Solves Them
Read moreHow Power BI Mobile Keeps You Connected to Your Business Data from Anywhere
WebSiteAdmin, October 18, 2024366 Views
In today’s fast-paced business world, staying informed is more important than ever. Whether you’re managing a team, overseeing multiple projects, or making critical decisions, having quick and easy access to your business data can make all the difference. That’s where Power BI Mobile comes in. It’s a powerful tool that keeps you connected to your business… Continue reading How Power BI Mobile Keeps You Connected to Your Business Data from Anywhere
Read moreStreamlining Team Collaboration with Power BI: Shared Dashboards and Reports
WebSiteAdmin, October 15, 2024636 Views
In today’s fast-paced business environment, effective collaboration among team members is essential for making informed decisions. One powerful tool that can enhance collaboration is Power BI by Microsoft. In this guide, we’ll explore how Power BI can streamline team collaboration through shared dashboards and reports, even for those who may not be tech-savvy. Why Use… Continue reading Streamlining Team Collaboration with Power BI: Shared Dashboards and Reports
Read moreReal-Time Data Monitoring with Power BI: How to Make Data-Driven Decisions Faster
WebSiteAdmin, October 11, 2024896 Views
In today’s fast-paced business environment, timely decisions are crucial. Whether it’s responding to market shifts, managing operations, or improving customer satisfaction, staying on top of your data can give you a significant edge. But how can you make sure you’re seeing the most up-to-date information, and how can you turn that into action? That’s where… Continue reading Real-Time Data Monitoring with Power BI: How to Make Data-Driven Decisions Faster
Read moreHow to render lookup as dropdown in Powerpage
WebSiteAdmin, October 1, 20241913 Views
In today’s digital landscape, creating user-friendly interfaces is essential, especially when building applications using Microsoft Power Portal. One common requirement is to render lookup fields as dropdown menus, enabling users to select from a predefined set of values. This functionality enhances the user experience by making data entry more intuitive and efficient. In this blog,… Continue reading How to render lookup as dropdown in Powerpage
Read moreDiscover the Magic of Q&A Visual in Power BI!
WebSiteAdmin, September 27, 2024834 Views
Imagine being able to ask your data questions as easily as you’d ask a colleague, and in seconds, getting the answers neatly organized in the form of charts, graphs, or tables. so That’s the beauty of Power BI’s Q&A Visual! It’s like chatting with your data, no technical know-how required. Curious how it works? Let’s… Continue reading Discover the Magic of Q&A Visual in Power BI!
Read moreUse Power Automate to get Name and Email Address in Outlook Online
WebSiteAdmin, September 27, 20242518 Views
This Power Automate Flow fetches Name and Email-address of the Person/(s) mentioned in the ‘From’, ‘To’, ‘CC’, ‘BCC’ mappings of the Outlook Online for a user-defined time-period i.e., Start Date and End Date and outputs the data in a Notepad .txt file in Outlook Online to a specific user-defined person email. What are the input… Continue reading Use Power Automate to get Name and Email Address in Outlook Online
Read moreInvoker’s Connection in Power Automate
WebSiteAdmin, September 24, 20241355 Views
We’ve been using Power Automate extensively to automate operations in Dynamics 365 using the Dataverse connectors. Also, working with connectors in Microsoft Dataverse, using a connection reference is generally a good practice. However, there’s an exception: if you want to perform a Dataverse operation in the context of the person who triggers the flow (the… Continue reading Invoker’s Connection in Power Automate
Read moreIntroduction to Data Science in Microsoft Fabric
WebSiteAdmin, September 10, 2024588 Views
As an end-to-end SaaS Microsoft Fabric multiple workloads or components including Data Science. In this blog we will explore how Microsoft Fabric can be used to empower users with end-to-end data science workflows to enrich data and extracts business insights. What is Data Science? Data Science has become a popular term and buzzword in many… Continue reading Introduction to Data Science in Microsoft Fabric
Read moreManaging Posting Restrictions on Sales/Purchase Document According to various users in MS Dynamics 365 Business Central
WebSiteAdmin, September 6, 20241178 Views
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to manage posting restrictions on sales and purchase documents according to various users is pivotal for ensuring data integrity and financial control within organizations. Requirement: How can we effectively… Continue reading Managing Posting Restrictions on Sales/Purchase Document According to various users in MS Dynamics 365 Business Central
Read moreComparing Business Central and QuickBooks: A Comprehensive Overview
WebSiteAdmin, September 2, 2024501 Views
Choosing the right accounting software is crucial for managing finances and operations efficiently. Two popular options are Microsoft Business Central and Intuit QuickBooks. While both offer robust features, they cater to different business needs. Here’s a comparison highlighting their key differences and why Business Central might be a better fit for growing enterprises. Target Audience… Continue reading Comparing Business Central and QuickBooks: A Comprehensive Overview
Read moreHow to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central
WebSiteAdmin, August 30, 20241593 Views
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central. Prerequisites Access to… Continue reading How to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central
Read morePower BI vs. Tableau: A Comprehensive Comparison
WebSiteAdmin, August 30, 2024791 Views
Choosing the right data visualization tool is essential for any business aiming to make data-driven decisions. Power BI and Tableau are two of the most popular options available, each with its own set of strengths. This article provides a concise comparison to help you determine which tool might best suit your needs, highlighting areas where… Continue reading Power BI vs. Tableau: A Comprehensive Comparison
Read moreCancel Multiple Posted Sales Invoices using Job Queue in MS Dynamics 365 Business Central using AL Code
WebSiteAdmin, August 21, 2024924 Views
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to Cancel Multiple Posted Sales Invoices in a batch using Job Queue in Business Central. A job queue in Microsoft Dynamics 365… Continue reading Cancel Multiple Posted Sales Invoices using Job Queue in MS Dynamics 365 Business Central using AL Code
Read moreCopying Excel files from source to destination in Excel format using ADF Pipeline
WebSiteAdmin, August 16, 20242068 Views
As Azure Data Factory (ADF) does not offer Excel as a sink option, an alternative method is required to copy Excel files using ADF pipelines. Implementation Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field list to include… Continue reading Copying Excel files from source to destination in Excel format using ADF Pipeline
Read moreCreating a Custom Job Queue to create Sales order from Purchase order in MS Dynamics 365 Business Central using AL Code
WebSiteAdmin, August 13, 20241460 Views
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to create a custom job queue to create Sales order from Purchase order in Business Central. A job queue in Microsoft Dynamics… Continue reading Creating a Custom Job Queue to create Sales order from Purchase order in MS Dynamics 365 Business Central using AL Code
Read moreDynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF
WebSiteAdmin, August 2, 20241415 Views
The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data activity in Azure Data Factory (ADF) pipeline. Implementation: Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field… Continue reading Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF
Read moreHow to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code
WebSiteAdmin, July 30, 20241325 Views
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code. Integrating Power Automate Flows… Continue reading How to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code
Read morePublic Transport and Information Technology
WebSiteAdmin, July 19, 2024466 Views
Public transport forms the blood vessels of a city with its citizens forming the precious life blood. They transport their precious cargo just like blood vessels in a body keeping the city alive and thriving. Any kind of disruption brings the city to a painful and grinding halt. While proper processes and experience can and… Continue reading Public Transport and Information Technology
Read moreArchiving Projects (Jobs) in Microsoft Dynamics 365 Business Central
WebSiteAdmin, July 16, 2024664 Views
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to archive projects (jobs) which can help keep your workspace organized and efficient. With archiving capabilities, users can manage their project data effectively, benefiting from audit trails and version… Continue reading Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central
Read moreMicrosoft Power BI consulting: Introduction to the new Button Slicer
WebSiteAdmin, July 3, 2024879 Views
The Power BI has introduced a new button slicer which resembles somewhat to the custom slicer, i.e., the Chiclet slicer. In this blog, as a part of Microsoft Power BI consulting we are going to explore this new button slicer. In the current report, we have imported the sample dataset i.e., Financials dataset, upon which… Continue reading Microsoft Power BI consulting: Introduction to the new Button Slicer
Read moreDynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code
WebSiteAdmin, June 27, 2024891 Views
Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to get linked Sales order’s data in Assembly Order. This customization can be used for businesses that deal with complex assembly processes and… Continue reading Dynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code
Read moreMicrosoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).
WebSiteAdmin, June 19, 20241173 Views
In this blog, we are going to explore the new feature to use the Calculation Groups using Power BI Desktop and Microsoft Power BI Services through Microsoft Power BI consulting. Currently, we are making use of the Sample dataset i.e., Financials dataset in Power BI. Also, we have created a Date table starting from minimum… Continue reading Microsoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).
Read moreDynamics 365 Business Central
WebSiteAdmin, June 10, 2024469 Views
Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to link Dimensions to a custom table and its Pages in D365 Business Central. Prerequisites Access to a Microsoft Dynamics 365 Business Central… Continue reading Dynamics 365 Business Central
Read morePower Automate: Track Multiple Microsoft Survey Forms Responses
WebSiteAdmin, June 4, 20241622 Views
In the realm of Microsoft Forms and Power Automate integration, “When a new response is submitted” connector serves as a reliable tool for triggering actions upon the submission of a single form response. However, a notable limitation arises when attempting to capture responses from multiple Microsoft Forms simultaneously. Considering this challenge, there emerges a need… Continue reading Power Automate: Track Multiple Microsoft Survey Forms Responses
Read moreMicrosoft Power BI Consulting: Unleashing the Power of Generative AI
WebSiteAdmin, May 28, 2024788 Views
In the ever-evolving landscape of data analytics and reporting, Microsoft continues to raise the bar with innovative solutions. One such groundbreaking feature is the integration of generative AI into its reporting platform, Power BI. With the Premium Capacity subscription, users can now harness the capabilities of Copilot to effortlessly create and modify reports with just… Continue reading Microsoft Power BI Consulting: Unleashing the Power of Generative AI
Read more