<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Shivam Shukla on Medium]]></title>
        <description><![CDATA[Stories by Shivam Shukla on Medium]]></description>
        <link>https://medium.com/@shivam-shukla?source=rss-94cd984048d9------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*2xZ3OZc8WKyTnyNNQmBxRg.jpeg</url>
            <title>Stories by Shivam Shukla on Medium</title>
            <link>https://medium.com/@shivam-shukla?source=rss-94cd984048d9------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 18:01:38 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@shivam-shukla/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Cracking the TOGAF® 10 Practitioner Exam: Core Mental Models, Tips & Tricks for Success Passing the…]]></title>
            <link>https://shivam-shukla.medium.com/cracking-the-togaf-10-practitioner-exam-core-mental-models-tips-tricks-for-success-passing-the-c24e595921ff?source=rss-94cd984048d9------2</link>
            <guid isPermaLink="false">https://medium.com/p/c24e595921ff</guid>
            <category><![CDATA[togaf10]]></category>
            <category><![CDATA[togaf-certification]]></category>
            <category><![CDATA[enterprise-architecture]]></category>
            <category><![CDATA[togaf]]></category>
            <dc:creator><![CDATA[Shivam Shukla]]></dc:creator>
            <pubDate>Mon, 22 Jun 2026 14:40:18 GMT</pubDate>
            <atom:updated>2026-06-22T14:40:18.369Z</atom:updated>
            <content:encoded><![CDATA[<h3>Cracking the TOGAF® 10 Practitioner Exam: Core Mental Models, Tips &amp; Tricks for Success Passing the TOGAF 10 Enterprise Architecture Practitioner exam</h3><p>When I first started diving deep into the TOGAF 10 scenario questions, I’ll admit I had doubts. If you look at the practice exams, the choices don’t look like typical multiple-choice questions. They all sound incredibly professional, they all use correct architectural terms, and they all look like something a smart consultant would say in a boardroom.</p><p>But behind the scenes, the exam board grades your answers on a gradient: 5 points (Perfect), 3 points (Good but flawed), 1 point (Over-engineered), and 0 points (Wrong phase/Banned approach).</p><p>The hardest part isn’t eliminating the bad answers — it’s defending your choices between the 3-pointer and the 5-pointer. Here is a real, no-nonsense look at the doubts I faced, the mistakes I almost made, and the mental filters that got me through.</p><h3>🧠 Mistake #1: The “Boil the Ocean” Modeling Trap (The 1-Point Answer)</h3><p>When a scenario asks you how to solve an operational issue — like a sudden spike in maintenance costs or a platform integration mess — our natural instinct is to say: “Let’s build a comprehensive, end-to-end current state model and map it completely to a new target state across all systems.”</p><ul><li>The Reality Check: In TOGAF 10, especially when you are operating at the Portfolio level, doing full baseline-to-target modeling for an entire enterprise estate just to answer a targeted cost or capability question is heavily penalized as a “Boil the Ocean” trap. It creates massive administrative overhead.</li><li>The Fix: Look for the approach that surgically targets the specific broken systems, information flows, or integration layers causing the actual pain described in the text. Don’t model the universe when a focused logical analysis is what’s required.</li></ul><h3>🔍 Mistake #2: Falling for Abstract Jargon over Real-World Anchors (The 3-Point vs. 5-Point Split)</h3><p>This was one of my biggest doubts during preparation. I would see an option that beautifully laid out abstract concepts like “focusing on logical application and data components to enable faster time-to-market.” It sounded exactly like a textbook answer, so I wanted to choose it.</p><ul><li>The Reality Check: These are often highly engineered theoretical distractors. They get you 3 points because the vocabulary is correct, but they miss the maximum score because they treat the problem like a generic classroom exercise.</li><li>The Fix: The true 5-point answer always anchors those logical components down to the specific, real-world platforms mentioned in the scenario (e.g., calling out how the data residency laws impact the third-party platformvs. the in-house platform). It applies theory to the actual bottleneck.</li></ul><h3>🧱 Mistake #3: Missing the Strict ADM Phase Boundaries</h3><p>The exam makers love to trick you by mixing deliverables across phases to see if you are paying attention to where you are standing in the Architecture Development Method (ADM) cycle.</p><ul><li>Phase A (Vision): You are strictly setting up the project boundaries, mapping out stakeholder motivations, and updating the viewpoint library to communicate clearly. If an option tells you to immediately run deep capability gap and impact assessments here, it’s a Phase Skip Trap — those belong later.</li><li>Phase B (Business Architecture): The core pillars are strictly Business Capabilities, Value Streams, Organization Mapping, and Information Mapping. If an option drifts into generic corporate talk like “processes, layouts, and business locations” without anchoring to capabilities and value streams, it drops straight to 0 points.</li><li>Phase C (Information Systems): If a scenario explicitly states that the Business Architecture review is completed, watch out for options that want to regress backward to ask stakeholders for new business capability priorities. Keep the forward momentum moving into logical application and data components.</li></ul><h3>🛠️ Quick Strategy Tips for Exam Day</h3><ol><li>Read the Actual Question First: Don’t get overwhelmed by the massive block of background text in the scenario. Scroll straight to the very bottom, read the specific question the team leader is asking (e.g., “How do you plan to set up the project?” or “How will you address the motivation to reduce costs?”), and then read the scenario with that exact filter in mind.</li><li>Filter Out the Dictator: Eliminate any option where the architect acts as an absolute dictator, unilaterally setting priorities or forcing a specific technical solution before a consensus vision is built. The 5-pointer almost always positions you as a neutral facilitator who uses trade-offs to build stakeholder alignment.</li><li>Trust Your Engineering Intuition: If an option feels like it’s just dumping a massive pile of unnecessary paperwork on a team instead of addressing the foundational root cause of the problem, trust your gut. It’s likely a distractor.</li></ol><p>At the end of the day, TOGAF isn’t about memorizing acronyms; it’s about learning how to build sustainable, structured foundations so that when the business wants to innovate quickly, the architecture actually holds up.</p><p>Best of luck to everyone preparing for their journey — stay focused on the phase boundaries, keep your scope tight, and you’ll clear it easily!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c24e595921ff" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Dataflows in Power BI]]></title>
            <link>https://shivam-shukla.medium.com/dataflows-in-power-bi-62b791b0d8c3?source=rss-94cd984048d9------2</link>
            <guid isPermaLink="false">https://medium.com/p/62b791b0d8c3</guid>
            <category><![CDATA[cdm]]></category>
            <category><![CDATA[powerplatform]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[dataflow]]></category>
            <dc:creator><![CDATA[Shivam Shukla]]></dc:creator>
            <pubDate>Sun, 21 Feb 2021 06:01:19 GMT</pubDate>
            <atom:updated>2021-02-21T06:26:21.408Z</atom:updated>
            <content:encoded><![CDATA[<p>This article is the first part of the Dataflows discussion series which focuses on a brief introduction and core concepts.</p><h4>What is Dataflows?</h4><p><em>“It is a cloud-based offering from Microsoft that allows ingesting, cleansing, transforming, integrating, data from a large variety of sources and maps it into a single schema within Power BI Services, directly in the browser.”</em></p><p><em>“Dataflows are an enterprise-focused data prep solution, enabling an ecosystem of data that are ready for consumption, reuse, and integration.” — Microsoft</em></p><h4>Why dataflows?</h4><p>The Power BI dataflows capability is designed to overcome following existing limitations of data prep in the Power BI Desktop and allow large-scale, complex, and reusable data preparation to be done directly within the Power BI service.</p><ol><li>Data once ingested in the Power BI dataset gets locked within the dataset and there is no way to reuse the data or the logic in multiple datasets.</li><li>Power BI datasets can not be connected or leverage the data processing technologies such as Azure Databricks.</li><li>Power query in the Power BI datasets does not support complex transformation at scale and transformations are not designed for incremental updates (while Power BI datasets can be incrementally updated, the same doesn’t apply to the transforms).</li></ol><h4>Dataflows Architecture</h4><p>Dataflows are created using Power Query, <em>a powerful and friendly transformation tool already familiar to tens of millions of Excel and Power BI users</em>, and are designed to work with massive amounts of data, both transactional and observational, stored in the Azure Data Lake Storage (gen 2) and are designed to be accessed by Azure data services.</p><p>In the diagram ahead, we can see that dataflows are providing the <strong>single source of the truth</strong> by forcing report creators to connect to the dataflows, rather than connecting directly to the underlying data source systems.</p><figure><img alt="Dataflows as single source of the truth" src="https://cdn-images-1.medium.com/max/1024/1*xtXal-bh7OW6gc0y9wzP7A.png" /><figcaption>Dataflows in Power BI</figcaption></figure><h4>How it can add value to your organization?</h4><p>There are numerous ways dataflows add value but I have listed a few key reasons as follows:</p><ol><li>It provides more control over data access and allows us to prevent users from having direct access to the underlying data sources which reduces the load to the underlying systems, and gives administrators <strong>finer control of when the systems get loaded from refreshes.</strong></li><li>It has a revolutionary <strong>model-driven calculation engine</strong> that can handle the most complex data preparation challenges in a timely and cost-effective manner within the Power BI Services.</li><li>It supports the <a href="https://docs.microsoft.com/en-us/common-data-model/"><strong>Common Data Model (CDM)</strong></a> — a set of standard business entities such as Account, Product, Lead, and Opportunity and enables easy mapping between any data in any shape into CDM standard entities(tables).</li><li>It provides complete <strong>native integration with the rest of the Power BI</strong> system such as datasets, dashboards, and reports.</li><li>It is designed from the ground up to work with massive amounts of data, both transactional and observational, <strong>stored in the ADLSg2</strong> (Azure Data Lake Storage Gen 2), and to be accessible by multiple Azure data services and applications.</li><li>It allows Power BI to easily work with large volumes of observational data that is directly deposited to the data lake by various IoT, logs, and telemetry applications. Since Power BI sits directly above ADLSg2, this observational data can be mounted directly and used in dataflows without requiring any data movement.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/632/1*kCQm6YGbD5LROTzr40qH8Q.png" /><figcaption>Dataflows with different Azure Services</figcaption></figure><blockquote>As of now, we have discussed what is dataflows? why to use dataflows? and seen how does it add value to your existing Microsoft BI stack. Let’s dive into how to get started with the dataflows?</blockquote><h4>How to Create your first Dataflow?</h4><p>Dataflows are available for both Power BI Pro and Power BI Premium offerings. There are differences in the capabilities of the two product offerings as mentioned in the following grid.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0XhXxZdBn15DcFcPLQpJWA.png" /><figcaption>Dataflows features in Power BI Pro Vs Premium</figcaption></figure><p>Here is a detailed article available on the official Microsoft website to <a href="https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create"><em>Create a Dataflow</em></a><em> using the following different ways, I strongly recommended following the said instructions to create your very first dataflow.</em></p><ul><li><a href="https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-define-new-entities">Create a dataflow using define new entities</a></li><li><a href="https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-linked-entities">Create a dataflow using linked entities</a></li><li><a href="https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-a-computed-entity">Create a dataflow using a computed entity</a></li><li><a href="https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-importexport">Create a dataflow using import/export</a></li></ul><h4>How to use Dataflow?</h4><p>Typically, we connect to the Power BI dataflows from Power BI Desktop and use it to create BI datasets the same way they use SQL Server tables or other sources of data as shown in the following image.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1019/1*zbmusBuakZvLzHzBN4s_iw.png" /></figure><p>On successful authentication, It will list down all the workspaces having dataflows and we can select the required dataflows to start building reports and dashboards.</p><p>Logically, dataflows are at bottom of the stack, preparing data to feed the datasets, which in turn are serving the various visualization artifacts of Power BI — dashboards and reports as shown here in the following image.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/401/1*BDyRTIvx7MWkm0d4vmOuhg.png" /><figcaption>Power BI information hierarchy</figcaption></figure><h3>Conclusion</h3><p>With Dataflows in place, you can directly use Power BI to perform ETL, create impeccable reports and dashboards, with the help of Power Query, Robust Calculation Engine, and Power BI Services.</p><p>Dataflows handle the most complex data preparation challenges for users through its revolutionary model-driven calculation engine, cutting the cost, time, and expertise required for such activities to a fraction of what they otherwise would be!</p><p>Hoping that this information helps, please comment for any feedback or questions and as always Happy to share, Happy Learning, Cheers !!!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=62b791b0d8c3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using Regular Expressions(RegEx) in Power BI]]></title>
            <link>https://shivam-shukla.medium.com/using-regular-expressions-regex-in-power-bi-82c83f8afb70?source=rss-94cd984048d9------2</link>
            <guid isPermaLink="false">https://medium.com/p/82c83f8afb70</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[regular-expressions]]></category>
            <category><![CDATA[r]]></category>
            <category><![CDATA[regex]]></category>
            <dc:creator><![CDATA[Shivam Shukla]]></dc:creator>
            <pubDate>Sun, 30 Aug 2020 17:13:09 GMT</pubDate>
            <atom:updated>2020-08-30T17:41:22.142Z</atom:updated>
            <content:encoded><![CDATA[<p>Power BI does not have any native functions in the Power query to perform any RegEx operations so far. Hers is an <a href="https://ideas.powerbi.com/ideas/idea/?ideaid=1395c308-7f92-4321-8e35-6cd04d7108bf"><em>Idea</em> </a>submitted to Microsoft which you can use to vote for highlighting this feature.</p><p>In this article, I will be sharing a few approaches to give you a fair idea about how you can use RegEx in Power BI.</p><p><strong><em>What </em></strong><em>is </em><strong><em>R</em></strong><em>eg</em><strong><em>E</em></strong><em>x?</em></p><p>A regular expression (<strong><em>R</em></strong><em>eg</em><strong><em>E</em></strong><em>x</em>)is a sequence of characters that define a search pattern. Usually, such patterns are used by string-searching algorithms for “find” or “find and replace” operations on strings, or for input validation. It is a technique developed in theoretical computer science and formal language theory. —<em> </em><a href="https://en.wikipedia.org/wiki/Regular_expression"><em>Wikipedia</em></a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*knT1cibHf--xgo38ROIurQ.png" /><figcaption>Regular Expression Pattern</figcaption></figure><p><strong><em>Why </em></strong><em>needed?</em></p><p>It is widely used in <a href="https://en.wikipedia.org/wiki/Extract,_transform,_load"><em>ETL </em></a>(<strong>E</strong>xtract, <strong>T</strong>ransform, <strong>L</strong>oad) operations across industries. With the RegEx enabled system,You can perform various pattern-based filtering on the large volume of the dataset and filtered out the unwanted data to make it more meaningful.</p><p>There are a wide range of operations which we can be performed using Regular Expressions such as searching or replacing a String based on a specific pattern, say</p><blockquote>If we want to filter out all the rows with numerical values from the alphanumeric type of data? or</blockquote><blockquote>If we want to check if the E-mail ID column contains the right formatted E-mail IDs? or</blockquote><blockquote>If we want to extract the numbers starting from 9 and ends with 0.</blockquote><p><strong><em>How </em></strong><em>to do that?</em></p><p>We can use ‘R’ or ‘Python’ scripts within the Power Query to perform the RegEx Operation on the dataset. Here are a few examples that can help you in understanding this concept.</p><p><strong>Business Case</strong>: To scan all the alphanumerical column to find any numerical values or any month description present in any of the rows.</p><p><em>Solution using R:</em></p><p><em>Prerequisite: Make sure that you have ‘R’ installed on your machine, if not, please download it from </em><a href="https://cran.r-project.org/bin/windows/base/"><em>here</em></a><em>.</em></p><p>Step1- Connect to the data source and click on the Transform button in the Power Bi desktop, Go to Transform(from Home Button) -&gt; Run R Script to open the R script editor.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/1*fgs_7BcOldm6k-iMmjjg1w.png" /><figcaption>R Script Editor in Power BI</figcaption></figure><p>Step 2- Run the following script which scans the column named Expression based on the defined Pattern and create another column named as “isValid” with the Boolean type of the value, True/False.</p><p><em># ‘dataset’ holds the input data for this script</em></p><p><em>#define a Pattern as per your need</em></p><p><em>pattern &lt;- c(“[0123456789]”,”jan”,”feb”,”mar”,”apr”,”may”,”jun”,”jul”,”aug”,”sep”,”oct”,”nov”,”dec”)</em></p><p><em>#created a function which reads the above pattern and add them all using a OR(|) separator and do the search ignoring the case sensitivity.</em></p><p><em>isFound &lt;- function(x) {grepl(paste(pattern, collapse=”|”), as.character(x), ignore.case=TRUE)}</em></p><p><em>#Calling the isFound function and returning the output</em></p><p><em>output &lt;- within(dataset,{isValid=isFound(dataset$Expression)})</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/1*pp9-FqhO-iRdIln_CkWrFQ.png" /><figcaption>R Script Output</figcaption></figure><p><strong>Business Case:</strong> Checking if E-mail IDs are correctly formatted.</p><p><em>Solution Using R:</em></p><p>Step1- remains the same as mentioned above.</p><p>Step2- Run the following R script which scans the column named Emails based on the defined Pattern and create another column named as “isValidEmail” with the Boolean type of the value, True/False.</p><p><em># ‘dataset’ holds the input data for this script<br>isValidEmail &lt;- function(x) {<br> grepl(“\\&lt;[A-Z0–9._%+-]+@[A-Z0–9.-]+\\.[A-Z]{2,}\\&gt;”, as.character(x), ignore.case=TRUE)<br>}<br>output &lt;- within(dataset,{ValidEmail=isValidEmail(dataset$Email)})</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qJlbT-8BAkyjvu6Hkl-TnA.png" /><figcaption>R Script output</figcaption></figure><p>I hope you got a fair idea about how to use <strong>R</strong>eg<strong>E</strong>x in the Power BI. Please leave a comment for any feedback or any clarification needed.</p><p>Thank you!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=82c83f8afb70" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Get Started with Power Automate(Hands-on)- Part2]]></title>
            <link>https://shivam-shukla.medium.com/get-started-with-power-automate-hands-on-part2-a45d50ecff08?source=rss-94cd984048d9------2</link>
            <guid isPermaLink="false">https://medium.com/p/a45d50ecff08</guid>
            <category><![CDATA[powerapps]]></category>
            <category><![CDATA[microsoft-flow]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[microsoft-power-automate]]></category>
            <dc:creator><![CDATA[Shivam Shukla]]></dc:creator>
            <pubDate>Sun, 09 Aug 2020 13:02:14 GMT</pubDate>
            <atom:updated>2020-08-30T17:40:36.850Z</atom:updated>
            <content:encoded><![CDATA[<h3>Getting Started with Power Automate(Hands-on)- Part2</h3><p>This article is in continuation of <a href="https://medium.com/@shivam_connect/power-automate-microsoft-flow-part-1-796711578e24">Part1</a> where I tried to give you a brief introduction about the Power Automate and illustrated few use cases to enable a clearer understanding of its functioning. In this article, I will give you a brief idea about how to get started with your first Power automate project along with a few real-time use cases hands-on.</p><h4><strong><em>How to Get started with Power Automate?</em></strong></h4><p>For the first time users, Please check the Signup <em>process mentioned </em><a href="https://docs.microsoft.com/en-us/power-automate/sign-up-sign-in"><em>here</em></a><em>. O</em>nce set up, there are two ways to access the power automate portal:</p><p><em>1.Using Microsoft Office Portal:</em></p><p>a. Navigate to the <a href="https://www.office.com/">https://www.office.com/</a> and sign in with your organization account (e.g. @&lt;yourcompany.com&gt;), After successful sign-in, you will land on the Office home page.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/561/1*fn5whz_FXxQwV_7a7Wm4Lw.png" /><figcaption>Office home Page</figcaption></figure><p>b. You can search for Power Automate under the List of Apps and navigate to the portal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/463/1*JtdLXu-VnZ6jQTiiitkg4Q.png" /><figcaption>Power Automate</figcaption></figure><p><em>2. Using Direct access to the Power Automate URL:</em></p><p>a. Navigate to the <a href="https://flow.microsoft.com/">https://flow.microsoft.com/</a> and sign-in with your organization account.</p><p>b. After Successful login, you will land on the Power Automate Home screen.</p><p>Either way, you will land on the Power Automate home page screen which should look like as shown here in the picture.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/494/1*Pa9RM-cyLErE7FVEstCpgg.png" /><figcaption>Power Automate Home Screen</figcaption></figure><p>To get started, You can use existing Templates available on the home screen. You can also search related keywords in the search box which will fetch out all the available templates for you. For e.g. Let’s assume you want to create something related to SQL Server, search SQL Server in the search box and you will be presented with the list of all available templates which you can use and even customize them as per the requirements.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/504/1*PmfFAN_LIeS-j1_coF3xfg.png" /><figcaption>SQL Server Related Templates</figcaption></figure><h4><strong><em>Hands-on</em></strong></h4><p>Let’s understand this in detail with a few of the following real-time use cases.</p><p><strong><em>Flow1 - Writeback to the Database from an Excel File:</em></strong></p><p>Idea: With this flow, we are trying to create an automated process that will trigger when an excel gets uploaded in the share point directory and does the writeback on the database table. As a pre-requisite, we are assuming you have access to SharePoint.</p><p>Steps :</p><p>1. Navigate to the Power Automate Home Page, click on create and select Automated flow and search ‘SharePoint’ in the ‘Choose your flow’s trigger’ box and select ‘When a file is created in a folder’.</p><p>2. Locate your SharePoint director to upload a file, this will act as the trigger for this task.</p><p>Let’s add a few actions to this trigger:</p><p>3. <em>Get the rows from this excel file</em>, click on the Next Step button and search for Excel Online (Business) and select the ‘List row Present in a Table’ and locate your excel file by filling up the details related to location, Document Library, File and Table Name, which will be used to access the excel file and fetch the rows.</p><p>4. <em>Writeback to the database</em>, click on the Next Step button and search for SQL Server and select the ‘Insert row (v2)’ and provide the SQL Server connection details(Server Name, Database, and Table Name).</p><p>5. Once it verifies the connection details, it will list out all the Columns available in the table, you need to map these columns with the Excel Source Columns. As you click on the value section of each column, a dynamic content box will pop-up with the list of Excel column names which you can select one by one and map them to the corresp[onding Target Table Columns.</p><p>Once done, your flow should look like as shown in the diagram with a Trigger in the start followed by two actions, List rows present in a table and apply to each step(which is a kind of a loop to read excel rows one by one and insert into the database).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/353/1*sFrYy6BYzVm4eGve02URrg.png" /><figcaption>Writeback to Database</figcaption></figure><p>You are all set, sit tight, and see the magic of the flow 😉 by uploading a file on the selected SharePoint Directory.</p><p><strong><em>Flow2 - Writeback from the Database to an Excel File:</em></strong></p><p>Idea: With this flow, we are trying to create an automated process that will trigger when an excel gets uploaded in the share point directory and does the writeback on the Excel file at Sharepoint from the Database. As a prerequisite, we are assuming you have access to SharePoint.</p><p>Steps:</p><p>Navigate to the Power Automate Home Page, click on create and select Automated flow and search ‘SharePoint’ in the ‘Choose your flow’s trigger’ box and select ‘When a file is created in a folder’.</p><p>2. Locate your SharePoint director to upload a file, this will act as the trigger for this task.</p><p>Let’s add a few actions to this trigger:</p><p>3. <em>Get the rows from the database, </em>click on the Next Step button and search for SQL Server and ‘Get rows (V2)’ and provide the connection details(Server Name, Database, Table).</p><p>4. <em>Writeback to an Excel</em>, click on the Next Step button, and search Excel Online (Business) and select ‘Add row into a table’ action and locate excel from the SharePoint directory.</p><p>5. it will list out all the Columns available in the Excel, you need to map these columns with the Columns available in the database Table. As you click on the value section of each column, a dynamic content box will pop-up with the list of Database Table column names which you can select one by one and map them to the corresp[onding Target Excel Table Columns.</p><p>You are all set, sit tight, and see the magic of the flow 😉 by uploading a file on SharePoint Directory.</p><p><strong><em>Flow3 - Sending an automated E-mail notification on detecting special keys words in a Tweet</em></strong></p><p>There is a predefined template available and we can use it as is <a href="https://us.flow.microsoft.com/en-us/galleries/public/templates/f35577e025e611e7881e9718cfad4b56/get-a-push-notification-on-tweet-with-a-certain-keyword/">here</a></p><p><strong><em>Flow4 - Stored procedure call</em></strong></p><p>Idea: With this flow, We want to create a process that will either manually or automatically(using Power Apps) will call a defined stored procedure on the dataset and pass the required parameters.</p><p>Steps:</p><p>Navigate to the Power Automate Home Page, click on create and select manual(Instant) and Select Manual trigger a flow.</p><ol><li>This will create a Manual trigger.</li></ol><p>Let’s add a few actions to this Trigger:</p><p>2. Click on the Next Step button and search for SQL Server and select the ‘Execute Stored Procedure (V2)’ and fill in the server connection details (Server Name, Database, Table).</p><p>3. If you are calling to the parameterized stored procedure, then there are two ways to pass the parameter a. Passing the hardcode value of the parameter or b. Make it dynamic by calling the flow within the Power Apps button click and pass the object value to the stored procedure.</p><p>Here is the stepwise demo available for calling Stored Procedure based Microsoft flow within Power Apps <a href="https://www.youtube.com/watch?v=qb9Sloxw8wc">here</a></p><p>Once done, you are all set for this flow as well. Let’s run it and see.</p><p><strong><em>Flow5 - Analyzing Survey Data Using Microsoft Forms:</em></strong></p><p>Idea: With this flow, We want to set up an automated process that will help us to analyze the survey response data over Power BI dashboards. I understood this with the very detailed demo available on youtube <a href="https://www.youtube.com/watch?v=-qei9MS_8Ic">here</a> which will help you to do the setup to achieve this functionality.</p><p><strong><em>Note:</em></strong></p><p>Please hit the clap button, if these hands-on exercises helping you and giving a clearer picture of the power automate and its functionality, and share your feedback.</p><p>Happy to share, Happy Learning, Cheers !!!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a45d50ecff08" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power Automate(Microsoft Flow)- Part 1]]></title>
            <link>https://shivam-shukla.medium.com/power-automate-microsoft-flow-part-1-796711578e24?source=rss-94cd984048d9------2</link>
            <guid isPermaLink="false">https://medium.com/p/796711578e24</guid>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[microsoft-flow]]></category>
            <category><![CDATA[microsoft-power-automate]]></category>
            <dc:creator><![CDATA[Shivam Shukla]]></dc:creator>
            <pubDate>Wed, 05 Aug 2020 18:37:17 GMT</pubDate>
            <atom:updated>2020-08-30T17:40:13.073Z</atom:updated>
            <content:encoded><![CDATA[<h3>Getting Started with Power Automate(Concepts)-Part1</h3><p>This article is the first part of the Power Automate discussion series which focuses on giving you a brief introduction about Power Automate. For hands-on exercises, Please check out the second article in the series <a href="https://medium.com/@shivam_connect/get-started-with-power-automate-hands-on-part2-a45d50ecff08">here</a></p><p><strong><em>What is Power Automate?</em></strong></p><p>It is a Cloud-based SaaS(Software as a service)offering from Microsoft which allows you to automate various workflow-related tasks by just a few clicks.</p><p><em>“Power Automate is an online workflow service that automates actions across the most common apps and services.” - </em><a href="https://docs.microsoft.com/en-us/learn/modules/get-started-flows/1-introduction"><em>Microsoft</em></a></p><p><strong><em>How does it work?</em></strong></p><p>In simple words, you may take Power Automate as a tool that does certain actions based on the defined Trigger.</p><p>This Trigger can be a manual(an Instant), an automated event, a scheduled event, UI Flow , Business Process flow. Instant event is something which requires human intervention i.e. you go to the portal and execute the defined flow whereas Automated event executes on its own when it detects certain events such as posting of a new Tweet on <em>Tweeter o</em>r Addition of a new File in a Share point/One drive Directory or any other data-driven system alerts etc. Scheduled flows are created for the tasks which require automation on scheduled events such as sending e-mails on a daily batch load on the database. UI Flows are created for desktop and Web applications that do not have APIs available for automation and Business Process flows are created for tasks such as business approvals, service requests, etc.</p><p>In the diagram ahead, you will get a basic understanding of the two different flows where the left-hand side is based on the manual Trigger while the right-hand side is the automated one.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ITiYdPibHiV7LYK29cd4Xw.png" /><figcaption>Manual Vs Automated Trigger</figcaption></figure><p><strong><em>How it can add value to your organization?</em></strong></p><p>Well, the following uses(which I will be covering in detail in my next article) of the Power Automate will enable a clearer understanding of its functioning.</p><p>We can easily connect Power Automate with many native Microsoft and a few non-Microsoft applications and create flows to perform various automated actions as per the requirement, say -</p><p>· We can connect to the dataset using defined database connectors and send e-mail notifications to the desired recipients on your behalf on completion of a certain Batch load.</p><p>· We can call Stored-Procedures and perform DML( data manipulation language) operations such as Insertion/Deletion/Update on the database tables based on certain conditions.</p><p>· We can call Power Automate flow within Power Apps to perform writeback operations on related Tables and even do the bulk data upload on the table using an Excel file as a source.</p><p>· We can send e-mails on detecting any important sales lead on Dynamic365 or Salesforce.</p><p>· We can analyze Survey Data - you can create feedback/quiz surveys on Microsoft Forms which can be embedded into the Power BI for further Survey Data Analysis.</p><p>· We can Instantly respond to high-priority notifications or emails.</p><p>· We can Copy all email attachments to your OneDrive for Business account.</p><p>· We can Collect data about your business and share that information with your team.</p><p>· We can create an Automated approval workflow.</p><h4><strong><em>Conclusion</em></strong></h4><p>With Microsft Power Automate, We get enough flexibility to create customized workflows as per the business need. This is a very powerful tool that helps in addressing various real-time complex business problems without even writing large pieces of code. It is a subscription-based service that requires a license to be purchase either at the user level or at the flow level which you can find <a href="https://flow.microsoft.com/en-us/pricing/">here</a>.</p><p>If the license is not the bottleneck for you then you must go and explore the powerful capabilities of the Power Automate. (<em>you can always start with the 1-month free trial)</em></p><p>Happy to share, Happy Learning, Cheers !!!</p><p><em>References</em></p><ul><li><a href="https://docs.microsoft.com/en-us/learn/modules/get-started-flows/">Get started with Power Automate - Learn</a></li><li><a href="https://docs.microsoft.com/en-us/power-automate/getting-started">Get started with Power Automate - Power Automate</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=796711578e24" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>