<?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 Beril on Medium]]></title>
        <description><![CDATA[Stories by Beril on Medium]]></description>
        <link>https://medium.com/@berilevliyaoglu?source=rss-84e212136806------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*phxcClV6ucCwWbqsOB27cA.jpeg</url>
            <title>Stories by Beril on Medium</title>
            <link>https://medium.com/@berilevliyaoglu?source=rss-84e212136806------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 02:57:36 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@berilevliyaoglu/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[Real-World Lessons from My First Global Power Apps Implementation]]></title>
            <link>https://medium.com/@berilevliyaoglu/real-world-lessons-from-my-first-global-power-apps-implementation-8749922a608d?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/8749922a608d</guid>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[powerapps]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[powerplatform]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Thu, 28 Aug 2025 08:28:19 GMT</pubDate>
            <atom:updated>2025-08-28T08:28:19.873Z</atom:updated>
            <content:encoded><![CDATA[<h4>How I tackled time zones, location handling, and daily data management in a global Power Apps project</h4><h4><strong>📝 Overview</strong></h4><p>Hi everyone! For a little context, I’m a Power Platform developer with 3 years of experience, focused on Power Apps, Power Automate, RPA, and Power Pages. After working as a consultant for various clients, I recently joined a global company as a <em>Digital Transformation Analyst.</em></p><h4>This article shares the experience of building a presence tracking app used across multiple international office locations. The app, deployed on dedicated tablets at each office entrance, enables employees to check in and out for emergency readiness purposes.</h4><p>Rather than focusing on technical implementation details, this post highlights the key challenges faced during development — such as handling time zone differences, simplifying user experience across offices, and maintaining accurate daily data — and the practical solutions used to overcome them. The goal was to keep the system centralized, lightweight, and easy to maintain, while ensuring the data remains reliable and context-aware in a multi-country setup.</p><h4><strong>🧩 Project Background &amp; Requirements</strong></h4><p>In my first project at the company, I was tasked with developing a simple office attendance app using Power Apps and SharePoint. The goal was to develop a tablet-based registration solution for the entrances of offices in different countries. Everyone entering or exiting — whether internal staff or external visitors — would log their information to help maintain an accurate presence list, particularly useful in case of emergencies.</p><h4><strong>🔎 Context</strong></h4><p>Although the app interface is entirely in English (so multi-language support wasn’t necessary), we had another important requirement: we didn’t want to maintain separate copies of the app or SharePoint lists for each office location. Instead, we aimed to centralize everything through a <strong>single app</strong> and a <strong>single SharePoint list</strong>, making the solution easier to maintain and update across all offices.</p><h4><em>This centralized setup also brought clear </em><strong><em>cost advantages</em></strong><em>. Since all offices share a single app and list, we avoided multiplying Power Apps license usage and the administrative overhead that comes with managing separate environments. Fewer apps to deploy means fewer licenses to consume, and a single maintenance path ensures that both support time and overall operational costs remain low.</em></h4><h4><strong>📌 Challenge #1: Simplifying Location Handling in a Distributed Deployment</strong></h4><p>The centralized approach introduced a usability challenge. When the app is launched, the user must select the office location so that the relevant presence list can be displayed by filtering the SharePoint list on a location column, and all check-in/check-out entries are correctly logged. However, since the app is deployed on fixed tablets at each office (with no lock screen or user login), repeatedly asking users to select the office location every time the app reloads would create unnecessary friction. We needed a better way to persist the location without sacrificing simplicity or adding maintenance overhead.</p><h4><strong>💡 Solution: Persisting Location Selection with Device Caching</strong></h4><p>To avoid prompting users to select their office location every time the app is loaded, we decided to <strong>store the location selection in the device’s cache</strong>. This way, the selection popup would only appear when a change was explicitly needed.</p><h4><strong>🛠️ Implementation</strong></h4><p>To achieve this, I explored Power Apps functions like <strong>SaveData, LoadData, and ClearData</strong> — which surprisingly have very little usage examples in the Power Apps community. These functions allow you to save data locally on the device:</p><ul><li>SaveData stores a collection in the cache,</li><li>LoadData retrieves it,</li><li>and ClearData removes it when needed.</li></ul><p>While experimenting, I discovered a few quirks. Most notably, <strong>these functions don’t work in Studio mode</strong>. You can only properly test them in <em>Play mode</em> (after the app is published) or on a mobile device. This limitation led to repeated cache-related errors while working in Studio — but once I understood why they were happening and that they wouldn’t affect the live app, I learned to ignore them. (Not gonna lie — I used to have an irrational need to clear <em>every</em> Studio error before I could move on 😅).</p><p>I should mention one more time that this post is more of an experience share than a technical tutorial, so I won’t go deep into the implementation. But honestly, sometimes the most valuable thing isn’t knowing the exact syntax — <strong>it’s knowing what’s possible</strong> (Shoutout to ChatGPT, the mighty assistant).</p><h4><strong>🛠️ Architecture</strong></h4><p>Here is a simplified view of the SharePoint list and the PowerApps focused on office location caching.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/552/1*ZSWoTX_TaGL4jhkoLZgHPw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*AEjEIJEyOjXUcRKqsUu11g.png" /></figure><h4><strong>📌 Challenge #2: Handling Local Timestamps in a Global App</strong></h4><p>The app is used in offices across multiple countries, and it logs each user’s <strong>entry time</strong> by creating a record in a SharePoint list. Initially, I relied on SharePoint’s built-in Created column to capture this. However, I soon realized a major flaw: SharePoint stores this timestamp in a fixed time zone, not in the <strong>user’s local time</strong>. As a result, the recorded entry times were misleading or even unusable for local reporting and operational needs.</p><h4><strong>💡 Solution: Adding a Custom Timestamp for Accurate Logging</strong></h4><p>To address this, I added a custom column named Created_STR (labeled as Entry Time in the diagram above) to the SharePoint list. This column stores the exact <strong>local time</strong> when a user enters the office, as perceived by their device. This approach ensures that each entry log reflects the correct time in that user’s country — which is especially critical for safety records, auditing, and operational coordination.</p><h4><strong>🛠️ Implementation</strong></h4><p>In the Power Apps patch function, I used the Now() function to get the current time from the user’s device and converted it into a formatted string:</p><pre>Created_STR: Text(Now(), &quot;[$-en-US]mm/dd/yyyy hh:mm&quot;)</pre><h4><strong>📌 Challenge #3: Time Zone-Specific Automation for Daily Reset</strong></h4><p>To ensure the emergency presence list stays accurate and up to date, we clear the SharePoint records every morning. Before doing so, if any employee has not logged their exit, we want to send them a reminder email explaining the importance of accurate exit logs — especially since this data could be critical during an emergency.</p><p>The challenge was that this reset needed to happen at <strong>6:00 AM local time in each country</strong>. The simplest option would have been to create <strong>separate Power Automate flows</strong> for each country and set them to run at 6:00 AM based on their time zone. However, this approach would increase maintenance efforts and lead to duplication.</p><h4><strong>💡 Solution: Centralized Flow with Dynamic Time Zone Check</strong></h4><p>To avoid maintaining multiple flows, we created a <strong>single centralized Power Automate flow</strong>. Instead of running at a fixed local time, the flow is triggered <strong>every hour</strong>. Each time it runs, it checks which countries currently have <strong>6:00 AM in their local time zone</strong>.</p><p>Only for those countries, the flow proceeds to:</p><ul><li>Send reminder emails to employees who didn’t log their exits the day before.</li><li>Clear the presence records in SharePoint.</li></ul><p>This approach significantly reduces overhead and ensures the logic stays in one place while still respecting local time zone requirements.</p><h4><strong>🛠️ Implementation</strong></h4><p>The Power Automate flow is scheduled to run <strong>every hour</strong>. Instead of relying on fixed schedules for each country, it dynamically determines which countries are currently at <strong>6:00 AM local time</strong>.</p><p>First, we get the current UTC hour and calculate the <strong>target offset</strong> that would make the local time 6:00 AM, using:</p><pre>sub(6, variables(&#39;intUtcHour&#39;))</pre><p>Then we are getting items from the RegionalTimeSettingsList to be able to get the group with the target offset.</p><figure><img alt="European countries with the same rule for DST are grouped together." src="https://cdn-images-1.medium.com/max/800/1*gWpeME9U60iomy829R2xkQ.jpeg" /><figcaption>European countries with the same rule for DST are grouped together.</figcaption></figure><p>For each item in the list, we first check whether the group observes Daylight Saving Time (DST). If it does, we then verify whether the current date falls within the DST period. When it does, the DST offset value for that group is applied. Otherwise, the standard offset value is used.</p><p>After determining the accurate offset for the group, we compare it with the target offset calculated at the beginning. If they match, we proceed by sending emails to employees in each country of that group who have not logged their exits, and then clear all records to ensure a fresh start for the new day.</p><p>Additionally, to keep the <strong>RegionalTimeSettings</strong> list updated with the current year’s DST start and end dates, we use a separate Power Automate flow. This flow is scheduled to run once a year on January 1st and dynamically calculates the DST period based on the defined rules:</p><ul><li><strong>Europe</strong></li></ul><p>DST starts on the last Sunday of March:</p><pre>addDays(concat(utcNow(&#39;yyyy&#39;), &#39;-03-31&#39;), sub(0, dayOfWeek(concat(utcNow(&#39;yyyy&#39;), &#39;-03-31&#39;))))</pre><p>ends on the last Sunday of October.</p><pre>addDays(concat(utcNow(&#39;yyyy&#39;), &#39;-10-31&#39;),sub(0, dayOfWeek(concat(utcNow(&#39;yyyy&#39;), &#39;-10-31&#39;))))</pre><ul><li><strong>United States</strong></li></ul><p>DST starts on the second Sunday of March</p><pre>addDays(concat(utcNow(&#39;yyyy&#39;), &#39;-03-01&#39;),add(7, sub(0, dayOfWeek(concat(utcNow(&#39;yyyy&#39;), &#39;-03-01&#39;)))))</pre><p>ends on the first Sunday of November.</p><pre>addDays(concat(utcNow(&#39;yyyy&#39;), &#39;-11-01&#39;),sub(0, dayOfWeek(concat(utcNow(&#39;yyyy&#39;), &#39;-11-01&#39;))))</pre><p>Finally, here is a flowchart that brings all the pieces together and illustrates how the entire process works end to end:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Onp1WugMl4lfyRMGb61KWg.png" /></figure><blockquote>This project was a valuable learning experience in managing global app deployments with diverse requirements, teaching me how to balance user experience, technical complexity, and maintainability in a multinational context. I hope these insights help others facing similar challenges — thanks for reading!</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8749922a608d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power Automate Tips: Detect Modified Columns and Retrieve Old Values in Sharepoint]]></title>
            <link>https://medium.com/@berilevliyaoglu/power-automate-tips-detect-modified-columns-and-retrieve-old-values-in-sharepoint-b5085cf3f540?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/b5085cf3f540</guid>
            <category><![CDATA[microsoft-power-automate]]></category>
            <category><![CDATA[sharepoint]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[microsoft-power-platform]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Fri, 02 Aug 2024 20:33:23 GMT</pubDate>
            <atom:updated>2024-08-02T20:33:23.291Z</atom:updated>
            <content:encoded><![CDATA[<blockquote>In this article, I have curated three solutions from different sources, as they often form part of a single scenario and are frequently needed together. Please note that these solutions are not my own, but rather my representation and organization of them. The links of the sources used are in the end of the article. Thank you for reading.</blockquote><h4>Detect Modified Columns</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/1*HUuKSQJ9WmpFY46Vms0Skg.png" /></figure><p>The <strong>“When an item or a file is modified”</strong> trigger activates whenever an item or a file is changed in a specific list or library on the destination site. The trigger provides dynamic content for the item that triggered the flow. However, it doesn’t offer detailed information about the specific changes made. Since it only gives us the updated version of the item, we cannot see the previous version or identify which specific columns were altered.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/617/1*2lYGos9v45LR4pyb6szWUg.png" /></figure><p>To obtain detailed information about the modifications, you should use the <strong>“Get changes for an item or file (properties only)” </strong>action after the “When an item or a file is modified” trigger. This action provides what has changed and what was the old value. After selecting the site address, list or library name, and ID from the trigger outputs, you should also fill in the “Since” field with the “Trigger Window Start Token.”</p><p>To better understand the solution, it’s important to know what “Trigger Window Start Token” and “Trigger Window End Token” represent.</p><blockquote>Triggers check for whether the trigger action has occurred within specific time periods. The <strong>“Trigger Window Start Token” </strong>indicates the last time the flow was checked, while the <strong>“Trigger Window End Token”</strong> marks the time of the current flow check.</blockquote><p>In this context, the “Trigger Window Start Token” provides the last version of the item before it was modified.</p><p>This action outputs <strong>“Has Column Changed”</strong> tokens as a boolean (true or false) for each column. For example, if you want your flow to run only when a specific column is modified, you can use this action to check if that column has changed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/571/1*owZ2z8h3P7lrq0xcjbfhNA.png" /></figure><p>Now you know which column has changed, but you don’t know the previous value of the column before it changed.</p><h4>Retrieve Old Values</h4><p>SharePoint keeps track of changes by storing different versions of lists. This means every modification is saved as a new version of the list. In our case, we can retrieve the current version and version number of a SharePoint list from the trigger outputs and use an HTTP request to get a list of all version numbers.</p><p><strong>There are two ways of getting the previous value using version numbers.</strong></p><h4><strong>1. Using the “Get changes for an item or file (properties only)” action</strong></h4><p>We’ve talked about the action and “Trigger Window Start Token” providing the last version of the item before it got modified. So we have the version number that we need.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/617/1*2lYGos9v45LR4pyb6szWUg.png" /></figure><p>We will use the “Send an http request to Sharepoint” action for fetching all the version numbers of the updated list item.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/595/1*0k0rp9z0s8nhK5m8LN8FAQ.png" /></figure><p>· <strong>Uri:</strong> _api/web/lists/getByTitle(‘Your_list_name’)/items(triggerOutputs()?{List Item ID from Step 1)/versions</p><p><em>you can select the ID from the dynamic contents.</em></p><p>· <strong>Headers:</strong></p><p>Key: Accept</p><p>Value: application/json; odata=nometadata</p><p>After you filled in the action, you can do a test run because we will use the JSON payload in the next action. Copy the JSON payload output.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/1*lxzhHAF4TPXqUEF602zPgQ.png" /></figure><p>Use “Body” of the “Send an http request to Sharepoint” action and click on “Generate from sample”. Paste the JSON payload from the previous output and click done.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/846/1*tO5Y7EYv1uUMn6ABaavcrg.png" /></figure><p>Fill in the “From” field with the value obtained from the “Parse JSON” action. Use the VersionLabel from the JSON payload and select the “Since Version Label” from the dynamic contents of the “Get changes for an item or file (properties only)” action.</p><p>Next, you can set a variable with your desired value. I am using the “first” function to avoid the “apply to each” control. This expression gives me the previous value in the “BuddyId” column before the item was modified.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*uOm1CMeiA9gA_iyymZmehg.png" /></figure><h4>2. <strong>Without using the “Get changes for an item or file (properties only)” action</strong></h4><p>In this solution, the “Get changes for an item or file (properties only)” action is not necessary because we will obtain the current version number from the trigger outputs. To detect the previous value of the column, subtract 1 from the version number. This approach requires using a set of string functions due to the format of the version numbers, which follow a major.minor structure.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*JiQSmSW1YL-yaClJ4Wr1wg.png" /></figure><p>To split the major and minor version numbers, use this expression:<br><strong> int(first(split(triggerOutputs()?[‘body/{VersionNumber}’],’.’)))</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*X5mrQ9p8sDioIcaB6Me06Q.png" /></figure><p>Subtract 1 from the major version number with this expression: <strong>sub(outputs(‘Get_the_current_version_number’),1)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*zrwmthvw0xcCty_VWgTBWA.png" /></figure><p>Generate the previous version number by concatenating with the minor version number using this expression: <strong>concat(outputs(‘Get_the_previous_version_number’),’.0&#39;)</strong></p><p>Now, the rest is the same with the first solution. Fetch all the version numbers using the HTTP request, and filter the array using your previous version number.</p><p>Solutions are from:</p><p><a href="https://uncommonsolutions.hashnode.dev/trigger-power-automate-flow-when-a-specific-column-of-a-sharepoint-list-item-is-modified">https://uncommonsolutions.hashnode.dev/trigger-power-automate-flow-when-a-specific-column-of-a-sharepoint-list-item-is-modified</a></p><p><a href="https://dev.to/thebernardlim/power-automate-get-previous-value-of-updated-sharepoint-list-item-1kcb">https://dev.to/thebernardlim/power-automate-get-previous-value-of-updated-sharepoint-list-item-1kcb</a></p><p><a href="https://manueltgomes.com/microsoft/powerautomate/how-to-get-previous-versions-in-sharepoint/">https://manueltgomes.com/microsoft/powerautomate/how-to-get-previous-versions-in-sharepoint/</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b5085cf3f540" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power Automate Tips: Tracked Properties]]></title>
            <link>https://medium.com/@berilevliyaoglu/power-automate-tracked-properties-04f8d20e4b74?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/04f8d20e4b74</guid>
            <category><![CDATA[power-automate-flow]]></category>
            <category><![CDATA[microsoft-power-platform]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <category><![CDATA[microsoft]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Wed, 15 May 2024 07:11:52 GMT</pubDate>
            <atom:updated>2024-08-01T12:25:03.044Z</atom:updated>
            <content:encoded><![CDATA[<p>In a Power Automate flow, some actions may be highly time-sensitive, meaning that the output could change depending on the step’s execution time. If you want to exactly know when your flow step is executed, and want to track the time passed between the executions of two steps, you can use “tracked properties”.</p><p>This is not the only use-case for tracked properties, however it is the most common way of how power automate developers utilize it. You can think of any other usages of the feature, by considering:</p><ul><li>Tracked properties are hidden away from the inputs/outputs sections.</li><li>Tracked properties as “key-value” pairs are output all together as a JSON.</li><li>Syntax for receiving the output JSON is, <strong><em>actions(‘NameOfTheAction’)?[‘TrackedProperties’]</em></strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*wIs3FF8aotlcd3OxX9tjiQ.png" /><figcaption>go to settings of the action</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/866/1*1qg3o44_rCty07RNnoVc8A.png" /><figcaption>you can use expressions, strings, numbers, json (which makes nested json) for the value</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/578/1*o58hmA7luuLbpI8ks05DFQ.png" /><figcaption>you can access the json by using actions function</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/884/1*hOqkEh16jp2abz3qG-V1Iw.png" /><figcaption>sample output</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=04f8d20e4b74" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Exploring Microsoft Copilot: Features in Power Platform from the Perspectives of Beginner and…]]></title>
            <link>https://medium.com/@berilevliyaoglu/exploring-microsoft-copilot-features-in-power-platform-from-the-perspectives-of-beginner-and-0501cf86aa5c?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/0501cf86aa5c</guid>
            <category><![CDATA[ai-assistant]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[microsoft-power-platform]]></category>
            <category><![CDATA[microsoft-copilot]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Tue, 14 May 2024 11:37:05 GMT</pubDate>
            <atom:updated>2024-05-14T11:47:42.616Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Exploring Microsoft Copilot: Features in Power Platform from the Perspectives of Beginner and Expert Users</strong></h3><h4>Low-code meets AI assistance.</h4><blockquote>Copilot is simplifying low code technology in the Power Platform even further. The preview features of Copilot in the Power Platform provide a clear indication of where the platform’s future is headed, highlighting its direction towards enhanced usability and efficiency with Copilot’s assistance.</blockquote><blockquote>The latest Copilot features in Power Platform are helping beginners start coding with low-code solutions, while also exciting advanced users about the platform’s future.</blockquote><p>As of May 2024, I find that Copilot assistance in Power Platform may adequately supports citizen developers but some features fall short for advanced developers. Let’s go through some of the Copilot features in Power Apps, Power Automate, and Power Pages to evaluate them from the perspectives of both inexperienced and skilled users.</p><h3>Power Apps</h3><h4>Build apps through conversation</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/896/0*W9VcZbcwLpiOURlV.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-conversations-create-app">https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-conversations-create-app</a></figcaption></figure><p>In order to use this feature, you need Dataverse in your environment, which may not be the case for beginners who wants to explore Power Apps without license (free account), since <strong>Dataverse is a premium feature</strong>. <em>However, there is a </em><strong><em>30-day Power Apps trial plan</em></strong><em> that allows exploring all the Power Apps capabilities including Dataverse. Furthermore, anyone with a work or school email address can sign up for the </em><strong><em>Power Apps Developer Plan</em></strong><em>, which again includes Dataverse.</em></p><p>The feature suggests a Dataverse table for the described app, which is highly beneficial for users unfamiliar with Dataverse or databeses. <strong>It also benefits advanced users by streamlining the initialization phase, saving time and effort.</strong> Moreover, users can request <strong>meaningful sample data</strong>, which creates an optimal environment for development and test. Once the table is prepared, users can click the “create app” button to view the provided template for the described app. This template serves as an <strong>excellent starting point for beginners</strong>, offering guidance compared to starting with a blank canvas.</p><h4>Continue editing your app with Copilot</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/0*sr-zSiR-qLxn-TDW.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-edit-app">https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-edit-app</a></figcaption></figure><p>In my opinion, this feature primarily benefits beginners. While editing the app, Copilot assistance with controls is currently limited to inserting them with the described properties. Given that Power Apps is a low-code tool where controls are typically dragged and dropped onto a screen, the feature doesn’t add much value in its current state.</p><blockquote>To be useful for all users, I believe we should be able to request assistance not only for properties but also for events. I am guessing that we’ll see this feature soon, considering Copilot is already assisting with Power Fx formulas.</blockquote><p>Other scenarios and commands that you can ask Copilot to perform include adding a new screen using a template, navigating screens with buttons, and bulk editing. While these abilities show promise, they may not be compelling enough to attract experienced users.</p><h4>Create Power Fx Formulas with Copilot</h4><p>This feature enables users to ask Copilot to explain a written formula in the FX formula bar and generate commented formulas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/988/1*snwjFM40ZbKGaIkbtuj6dQ.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-formulas-formulabar">https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-formulas-formulabar</a></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hAYpPe130PWE9yhlM3agqQ.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-formulas-formulabar">https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/ai-formulas-formulabar</a></figcaption></figure><p><strong>I’ve found that formula explanation works well and is highly advantageous for all users, from beginners to experts. </strong>For advanced users, as the number of screens and controls increase, it gets difficult to remember all of the functionalities given with the FX formulas. One way to avoid this difficulty is adding meaningful comments in the formula bar during development. And another available way is to use copilot’s formula explanation feature. <strong>I’ve seen some developers adding these formula explanations as a comment in the formula bar, which combines the two method for increasing the readability.</strong></p><p><strong>I think beginners to Power Apps and Power FX will find comment-generated formulas particularly useful.</strong> As you gain more experience with Power FX, I believe writing the code directly becomes faster than explaining it in natural language. Personally, I don’t feel a current need for this feature, but I’m excited about its future potential.</p><h3>Power Automate</h3><p>Copilot generates a flow based on the user’s description and continues to edit it as the user provides instructions.<strong> I believe Copilot and its features align best with Power Automate since the product’s primary goal is automation.</strong></p><p>Describing a flow and having Copilot to provide the necessary trigger and actions saves inexperienced developers from the task of searching for the right triggers and actions for their flows.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*cYaVBJkeOSJLmfpvLAnehA.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-automate/get-started-with-copilot">https://learn.microsoft.com/en-us/power-automate/get-started-with-copilot</a></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*9I9TmaL4vBUzRJTd46guXw.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-automate/get-started-with-copilot">https://learn.microsoft.com/en-us/power-automate/get-started-with-copilot</a></figcaption></figure><h3>Power Pages</h3><p>In my opinion, Copilot shows its greatest potential in Power Pages compared the other products. In Power Pages, Copilot can be explored in unique areas such as AI-generated codes (different from Power FX formulas) and content generation, distinguishing it from other Power Platform products.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*ANuBzCJU7HnBsi2swbRGxg.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/getting-started/create-site-copilot">https://learn.microsoft.com/en-us/power-pages/getting-started/create-site-copilot</a></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*zPh4cKMo_NDv-LLZqSNjRg.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/getting-started/create-page-copilot">https://learn.microsoft.com/en-us/power-pages/getting-started/create-page-copilot</a></figcaption></figure><p>Similar to how Copilot is used on Power Apps and Power Automate, it enables the creation of a site from a description and allows for editing of web pages during development. Editing a page with Copilot also offers creating an AI generated form which will minimize the user effort, similar to what Copilot does with Dataverse table creation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rPDoCpak-ROj6Edadmbucw.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/getting-started/add-form-copilot">https://learn.microsoft.com/en-us/power-pages/getting-started/add-form-copilot</a></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*13ejwcyGxL4qfWGtpAntvQ.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/getting-started/add-form-copilot">https://learn.microsoft.com/en-us/power-pages/getting-started/add-form-copilot</a></figcaption></figure><p>One of the features I really like about Copilot in Power Platform is its ability to <strong>add AI-generated text to webpages</strong>. This feature is a lifesaver for developers because it takes away the hassle of coming up with meaningful text for the webpage. After describing the required text, it is possible to adjust the text’s tone and length, or to ask Copilot to rewrite. <strong>This is one of those features that developers of all experience levels will surely appreciate.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*7QgmewYrc679RwIfPukLgw.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/getting-started/add-text-copilot">https://learn.microsoft.com/en-us/power-pages/getting-started/add-text-copilot</a></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*1Ee2-CZWj51wphqxJ6FsoA.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/getting-started/add-text-copilot">https://learn.microsoft.com/en-us/power-pages/getting-started/add-text-copilot</a></figcaption></figure><p>Some shared features between Power Apps and Power Pages include the capability to incorporate custom Copilots generated from Copilot Studio (which will be the focus of the upcoming article) into both canvas apps and Power Page sites. Additionally, Copilot can provide answers to development-related question using Bing search.</p><p>The final feature in Power Pages, <strong>AI-generated code using Copilot, is a real treasure for experienced Power Pages developers</strong>. While Power Pages is a low-code tool primarily for creating external-facing websites, it also caters to professional web developers by allowing them to use HTML, JS, and CSS codes via Visual Studio Code. Leveraging Copilot assistance within Visual Studio Code significantly enhances efficiency in advanced Power Pages development.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*QNyraC7DbvcztKGNNZirbg.png" /><figcaption><a href="https://learn.microsoft.com/en-us/power-pages/configure/add-code-copilot">https://learn.microsoft.com/en-us/power-pages/configure/add-code-copilot</a></figcaption></figure><blockquote>I’m enthusiastic about the platform’s future, as I believe low-code technology provides an ideal environment for leveraging AI assistance to its fullest potential.</blockquote><blockquote>These are all my personal thoughts and observations as an experienced Power Platform developer. Thank you for taking the time to read them.</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0501cf86aa5c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Exploring Microsoft Copilot: Free vs. Licensed Usage]]></title>
            <link>https://medium.com/@berilevliyaoglu/exploring-microsoft-copilot-free-vs-licensed-usage-4a324908c7cb?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/4a324908c7cb</guid>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[copilot-pro]]></category>
            <category><![CDATA[copilot-studio]]></category>
            <category><![CDATA[microsoft-copilot]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Fri, 26 Apr 2024 08:44:13 GMT</pubDate>
            <atom:updated>2024-04-26T08:44:13.426Z</atom:updated>
            <content:encoded><![CDATA[<blockquote><em>For detailed pricing information and documentation on subscription plans, please visit Microsoft’s official website.</em></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/578/1*NTE6gMkDQldEFu8-fcxCBA.png" /></figure><p>Microsoft announced Microsoft Copilot as “your everyday AI companion.” Similar to what we’ve experienced with ChatGPT, you can visit <a href="http://copilot.microsoft.com/">copilot.microsoft.com</a> to experience the generative AI.</p><blockquote>· <strong>How is it different from ChatGPT?</strong></blockquote><blockquote>· <strong>What are differences between Copilot, Copilot Pro, Copilot for Microsoft 365?</strong></blockquote><h4>ChatGPT and Copilot both offer free and licensed usage. However, the difference lies in the fact that Copilot’s free plan includes some features that are only included in ChatGPT’s licensed plan.</h4><p>· The free plan of ChatGPT gives you access to GPT-3.5 language model, while Copilot’s free plan provides access to the GPT-4 language model. It is important to note that currently, Copilot is the only free option to experience GPT-4.</p><p>· The free plan of Copilot gives you the opportunity create images with DALL-E 3, while it is included in the licensed plan of ChatGPT.</p><p>· Copilot is connected to internet whether you use free or licensed plan. By using Microsoft Edge Browser, you can interact with the Copilot sidebar, allowing you to have conversation about the website you are currently visiting. Nevertheless, browsing feature (internet connection) is available only on the licensed plan of ChatGPT.</p><p>On the other hand, <strong>the free plan of Copilot</strong> comes with limitations regarding total chats per day, turns per chat, image generation boosts, uploads per day, and file size limits per upload. Apart from these specific numerical restrictions, free plan users also experience lower priority compared to licensed users during peak times, resulting in decreased response speeds.</p><p>· <strong>Total chats per day </strong>indicates each new chat you start with the “new topic” button. You can start 300 new chats a day using free plan.</p><p>· A <strong>chat turn</strong> indicates a prompt and its response. You can have 30 chat turns per chat.</p><p>· <strong>“Boosts”</strong> is a feature which accelerates image creation. In personal account, you can still create images without boosts but much more slower. In work/school account, you can not create images until the boosts replenish the next day. 15 boosts replenish each day in free plan.</p><h4>You can sign in to Copilot using either a personal Microsoft account or a work/school Microsoft account.</h4><p>If you sign in with a work/school account, you will have a commercial data protected Copilot session, ensuring that prompts and responses are not saved or used to train underlying large language models. In this mode, the sidebar, including the Chats and Plugins sections, is not available due to the restrictions on storing recent chat history or sending data to external providers for work/school accounts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4zJHmeSmXRyMOOVQV1O_Gw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qO_nXHlh9gTzrivjMNEPrA.png" /></figure><h4><strong>Subscriptions: Copilot Pro vs Copilot for Microsoft 365</strong></h4><p>Copilot Pro is designed for individual users while, Copilot for Microsoft 365 is suitable for business users, being only available to enterprises.</p><p><strong>The Copilot Pro license</strong> offers priority access to GPT-4 and GPT-4 Turbo, ensuring faster responses. It is integrated with several Microsoft 365 apps including Word, Excel, PowerPoint, and Outlook; <em>but not Microsoft Teams. </em>Additionally, the Copilot Pro License provides users with 100 daily boosts with Designer, enabling the creation of AI images using DALL-E 3.</p><p>On the other hand, <strong>Copilot for Microsoft 365</strong> is introduced as “your AI assistant at work”, integrated seamlessly with Microsoft Teams, Word, Outlook, PowerPoint, Excel, Edge for Business, and other Microsoft 365 apps. It utilizes enterprise data grounding, connecting directly to business data, empowering users to inquire about stored tenant data securely while also providing commercial data protection. Moreover, Copilot for Microsoft 365 license includes Copilot Studio, enabling the creation of custom Copilots.</p><blockquote>Speaking of which, the next article will be about <strong>Copilot Studio and Copilot in Power Platform</strong>. Thanks for reading and stay tuned for the next one!</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4a324908c7cb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A Quick Look at Microsoft Power Automate’s 2023 Release Wave 2]]></title>
            <link>https://medium.com/@berilevliyaoglu/a-quick-look-at-microsoft-power-automates-2023-release-wave-2-a14ba02a6b9b?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/a14ba02a6b9b</guid>
            <category><![CDATA[rpa-tools]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <category><![CDATA[power-automate-desktop]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Mon, 18 Sep 2023 08:12:48 GMT</pubDate>
            <atom:updated>2023-09-18T08:12:48.322Z</atom:updated>
            <content:encoded><![CDATA[<p>Let’s take a look at what’s new and planned for Power Automate in 2023 release wave 2 plan, which includes features that are going to be released from October 2023 through March 2024.</p><h4>Cloud Flows</h4><p><strong>Monitor performance for cloud and desktop flow activities:</strong></p><p>This planned feature is going to significantly help admins, makers, marketers and analysts of Power Automate within an organization. Assume that you have many cloud and desktop flows implemented for departmental needs in your organization. With this feature, you are going to have a central consolidated view to monitor and understand the executions across cloud and desktop flows. Meaning that, you are going to have valuable insights about success and failure rates, top errors and their trends etc.</p><p>This feature reminded me of a narrowly-focused version of Center of Excellence (CoE) particularly in terms of monitoring capabilities. Center of Excellence in Microsoft terminology represents a concept for organizations to align around business goals by maintaining governance and control. A CoE team is responsible from observing the overall Power Platform performance and accordingly setting strategies to achieve business goals. In this aspect, we can say that this new feature of Power Automate can give a similar but specialized experience of Center of Excellence.</p><p><strong>Manage bulk abandoned cloud flows:</strong></p><p>An abandoned cloud flow represents a flow previously developed by a user who is no longer an employee. This feature provides an easily manageable way to handle abandoned flows in bulk. Previously, admins have to manually report and reassign the flows individually. Now, they can perform these maintenance operations in bulk with lower effort.</p><p><strong>Run a cloud flow for more than 30 days per invocation:</strong></p><p>Previously, a triggered cloud flow could run 30 days at most. If it would take more than 30 days, it would be best to divide it to multiple cloud flows which would individually complete running in less than 30 days. Now with this feature; triggered cloud flows can run for longer than 30 days, meaning that developers don’t need to divide the requirement into multiple flows. Hence, the feature simplifies the design and testing experience.</p><p><strong>Use your own encryption key for encrypting data at-rest for existing environments:</strong></p><p>Previously, an encryption key from Azure Key Vault to encrypt an environment was only allowed if the environment doesn’t have running Power Automate flows. With this feature, you can use your own encryption key before or after you start using Power Automate.</p><h4>Desktop Flows</h4><p><strong>UI automation — Simulate actions:</strong></p><p>UI automation will now have two execution modes; auto and simulated. Auto mode is the one that is currently being used, which takes UI elements to be visible on the screen and requires physical steps including mouse and keyboard actions. With this feature, users will be able to use their desktop while the automation is running because simulated mode doesn’t require physical interactions. The UI automation actions will be performed in the background without needing mouse and keyboard.</p><p><strong>Inspect a UI element:</strong></p><p>It is now easier to discover all UI elements of a window and create custom selectors with the new inspect view. Microsoft also announced UISpy which is a sub-app for Power Automate Desktop where you can test UI actions. Note that this is the first feature that is in public preview in release wave 2 (see the screenshots below taken from learn.microsoft.com).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/649/1*29pvbTS9C_warOTvMXi9bw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/513/1*5znBKTCCQnfRqjeSOu2wGw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/544/1*5obC4d_t3K0bopfEln3Z1Q.png" /></figure><p><strong>Automate web in Citrix and RDP virtual desktops:</strong></p><p>With the Power Automate agent for virtual desktops, users already could automate processes on virtual desktops. However, a known issue was Citrix and RDP automations didn’t support web automation actions earlier. Microsoft’s offered workaround for this issue was treating web components as desktop UI elements. With this feature, Microsoft announces that Power Automate desktop will support web automation scenarios that are applied in virtual desktops.</p><p><strong>Edit variable values during debugging:</strong></p><p>Debugging takes time and patience especially in automated processes where you have to wait the scenario to be completed to clearly see what’s wrong, and run once again to see if your solution helped the failing situation. Microsoft came up with this beautiful feature that the developers are now will be able to edit variable fields when the flow is being debugged or paused.</p><p><strong>Improve screen handling for UI elements:</strong></p><p>This feature is going to bring a more user-friendly pane to manage captured UI elements where you can create, merge, or split screens and save your UI elements under them according to your needs.</p><p>Resources:</p><p><a href="https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave2/power-automate/planned-features">New and planned features for Power Automate, 2023 release wave 2</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a14ba02a6b9b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A Quick Look at Microsoft Power Automate’s 2023 Release Wave 1]]></title>
            <link>https://medium.com/@berilevliyaoglu/a-quick-look-at-microsoft-power-automates-2023-release-wave-1-364cc5bafe16?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/364cc5bafe16</guid>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[rpa-tools]]></category>
            <category><![CDATA[power-automate-desktop]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Thu, 07 Sep 2023 11:14:22 GMT</pubDate>
            <atom:updated>2023-09-07T11:19:33.224Z</atom:updated>
            <content:encoded><![CDATA[<p>Microsoft typically publishes 2 release plans for a year; shares the key dates, investment areas, and new features with their estimated public preview and general availability dates. I will be showing you which planned features have been realized in release wave 1 (from April 2023 through September 2023).</p><p>As Power Automate developers, we should stay informed about these upcoming features to avoid unnecessary complications in our implementations. Knowing which features will be available soon will enhance our vision when designing both cloud and desktop flows.</p><h4>Cloud Flows</h4><p><strong>Generate expressions from examples:</strong> Using examples when formatting data makes a lot easier to generate expressions. You can provide an example value and a desired output to receive the expression needed for the specific formatting.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/581/1*HROTIlfK0J_n5-RefhxiEw.png" /><figcaption><strong>Generate expressions from examples.</strong></figcaption></figure><p><strong>Service principal application users can own and run flows:</strong> Previously, a user couldn’t enable flows that service principals own because the connections that flows use couldn’t be shared with service principals. With this feature, connections can be shared with service principal accounts, allowing you to enable flows that service principal accounts own.</p><p><strong>Environment picker provides enhanced environment information: </strong>With this update, the environment picker provides filters that display platform roles. With the platform roles available, makers can easily identify their roles and then connect to the environments to which they have permissions.</p><h4>Desktop Flows</h4><p><strong>Create desktop flow connections without passwords (public preview).</strong></p><p><strong>Connectivity troubleshooter in Power Automate for desktop (public preview).</strong></p><p><strong>Use troubleshooter for UI automation (public preview).</strong></p><p><strong>Improved runtime error messages for Excel actions.</strong></p><p><strong>Run flows with keyboard shortcuts: </strong>Developers can now set up keyboard shortcut to trigger local attended desktop flows.</p><p><strong>Use web automation to access cross-domain iframes.</strong></p><p><strong>Validate the selectors of UI elements: </strong>Developers can now test the selector and see if the selector can find the target UI element on the screen.</p><figure><img alt="Validate the selectors of UI elements" src="https://cdn-images-1.medium.com/max/980/1*FOVSVEF_HRwOa-bd4RsCLQ.png" /><figcaption><strong>Validate the selectors of UI elements.</strong></figcaption></figure><p><strong>Fix the selector of a UI element: </strong>In case of capturing dynamic UI elements, selectors can fail if the UI element is no longer the same as at the time of capturing. With this feature, developers can capture a UI element multiple times using a wizard, and Power Automate for desktop will compare all captured selector information and suggest a new one that is more dynamic and robust.</p><p><strong>Use updated actions pane.</strong></p><p><strong>Utilize performance improvements.</strong></p><p><strong>Manage work queues for Power Automate (public preview): </strong>Developers can now create, maintain, and control prioritized work queues. You can monitor the performance of the work queues and respond to business exceptions. Work queues support cloud flows, desktop flows and APIs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/1*oX1aGxNV10JrgmKfeD_pSw.png" /><figcaption><strong>Manage work queues for Power Automate (public preview).</strong></figcaption></figure><p><strong>Use custom actions in Power Automate desktop (public preview): </strong>You can create custom actions through a publicly available SDK. Users are now able to browse using feeds to custom created functionality in the form of packages.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/581/1*2EMxiW6C75-0IMkdtCjopw.png" /><figcaption><strong>Use custom actions in Power Automate desktop (public preview).</strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/759/1*hff3Hx-qKMJiCNj52wm5tw.png" /><figcaption><strong>Use custom actions in Power Automate desktop (public preview).</strong></figcaption></figure><h4>Copilot for Power Automate:</h4><p><strong>Flows created with natural language can now understand parameters (public preview).</strong></p><p><strong>Use Copilot in Power Automate cloud flows designer (public preview): </strong>Now it is possible to not just describe a flow to create, but also improve them with AI-driven conversations in designer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/639/1*JipYTr3k_KkBP2RptzYNIw.png" /><figcaption><strong>Use Copilot in Power Automate cloud flows designer (public preview).</strong></figcaption></figure><p>The mentioned new features in the article are accessible to Microsoft Power Automate developers, but additional planned features from release plan 1 are not yet available. To find information on these planned features and their estimated publishing dates, you can check the link: <a href="https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/power-automate/planned-features"><strong>https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/power-automate/planned-features</strong></a></p><p>Resources:</p><p><a href="https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/power-automate/planned-features"><strong>https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/power-automate/planned-features</strong></a></p><p><a href="https://d365demystified.com/2022/10/17/format-data-by-examples-in-a-flow-preview-power-automate/"><strong>https://d365demystified.com/2022/10/17/format-data-by-examples-in-a-flow-preview-power-automate/</strong></a></p><p><a href="https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/power-automate/use-copilot-power-automate-cloud-flows-designer"><strong>https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/power-automate/use-copilot-power-automate-cloud-flows-designer</strong></a></p><p><a href="https://learn.microsoft.com/en-us/"><strong>https://learn.microsoft.com/en-us/</strong></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=364cc5bafe16" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Choosing the Right Tool: Power Automate vs. Power Automate Desktop]]></title>
            <link>https://medium.com/@berilevliyaoglu/choosing-the-right-tool-power-automate-vs-power-automate-desktop-656bff6b985f?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/656bff6b985f</guid>
            <category><![CDATA[roboticprocessautomation]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[rpa-tools]]></category>
            <category><![CDATA[power-automate-desktop]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Tue, 22 Aug 2023 07:56:54 GMT</pubDate>
            <atom:updated>2023-08-22T08:39:00.816Z</atom:updated>
            <content:encoded><![CDATA[<p>Power Automate is one of five Power Platform products, which we took a brief look at on my previous article “Microsoft Power Platform: Definitive Guide”. I realized that Power Automate often sparks a common confusion due to its diverse range of abilities distributed within different components. If you also have a general idea about the capabilities but not quite sure about its applications and different cases of uses, you should keep reading this article.</p><p>In this article, I am aiming to end this confusion by explaining the distinct features of Power Automate and Power Automate Desktop. While talking about these two tools, I will also explain some key concepts to provide you a comprehensive perspective.</p><p>· Please note that the features discussed in this article might change in upcoming releases. It is important to be aware that Power Platform is undergoing rapid development and enhancement, so it’s recommended to stay updated with the latest information.</p><p>According to Microsoft Power Automate documentation you can create cloud flows, desktop flows, or business process flows using the tool.</p><p><strong>By using Power Automate:</strong></p><ul><li>You can create a cloud flow.</li><li>You can create a business process flow (you can also create a business process flow from Power Apps).</li><li>You can not create a desktop flow, but you can trigger a desktop flow from a cloud flow.</li></ul><p><strong>By using Power Automate Desktop:</strong></p><ul><li>You cannot create a cloud flow.</li><li>You cannot create a business process flow.</li><li>You can create a desktop flow.</li></ul><h4>Power Automate — Cloud Flows:</h4><p>Cloud flow is a cloud-based automation service. It enables users to create and automate workflows that connect various applications and services via connectors. By using Power Automate, you can access to 500+ cloud connectors. If you are not satisfied with any of the connectors, you can build a custom connector by using APIs.</p><p>In Power Automate, you’ll find a plenty of cloud flow templates that are ready to use with just a few adjustments to cater to your specific needs.</p><p>Cloud flow uses a trigger-action model, where you define a trigger (an event that initiates the workflow) and subsequent actions (tasks performed in response to the trigger).</p><ul><li>In an <strong>automated cloud flow</strong>, you are allowed to choose a trigger event that would initate the flow.</li><li>In an <strong>instant cloud flow</strong>, trigger is usually set to a button click, meaning that you can initiate the flow manually as needed.</li><li>In a <strong>scheduled cloud flow</strong>, you choose when and how often the flow would run without the need of a trigger event.</li></ul><h4>Power Automate Desktop — Desktop Flows:</h4><p>Power Automate Desktop is a desktop application that allows users to implement RPA (Robotic Process Automation). Before diving into the details of desktop flows, let’s first discuss RPA, as it is the primary focus of this tool.</p><p><strong>RPA (Robotic Process Automation):</strong></p><ul><li>RPA is a technology that involves the use of robots to automate routine and repetitive tasks. It enables users to create automation scripts that mimic human interactions with desktop applications.</li><li>RPA bots can navigate through various software interfaces, extract information from a source, copy and paste data, and so many other activities to perform a specific task.</li><li>RPA technology can free up human employees from performing mundane tasks, therefore, enabling them to focus on more strategic and creative aspects of their roles.</li></ul><p>In this context, the biggest difference between Power Automate and Power Automate Desktop appears more clear. <em>Power Automate Desktop is an RPA tool while Power Automate focuses on cloud automation with connectors.</em></p><p>Using Power Automate Desktop flow designer; you can drag-and-drop prebuilt actions to create a flow, or you can record your routine so that the tool captures the actions. UI automation is one of key features of dekstop flows, which has the capabilities of mimicking mouse clicks, keyboard inputs, etc.</p><p>Using desktop flows, you can automate tasks on web, desktop, and even legacy ERP systems while cloud flows only automate tasks on cloud.</p><p>Now that we learned the key features of both tools, let’s summarize the separate abilities of each.</p><ul><li>Power Automate is a cloud-based service, while Power Automate Desktop needs installing to run on your local machine.</li><li>Power Automate rely more on trigger events, while Power Automate Desktop doesn’t specifically need a trigger event because it is designed to run whenever its needed.</li><li>Power Automate requires internet connection to run a flow, while Power Automate Desktop does not.</li><li>Power Automate Desktop enables users to implement RPA, while Power Automate does not. Power Automate cannot perform UI automation actions.</li><li>Power Automate can perform an automation task, only if the target application has a pre-built connector or has an API for a custom connector. Power Automate Desktop can automate tasks on applications with no APIs (typically desktop and legacy applications).</li></ul><p>I used my best abilities to help you understand the distinct capabilities of Power Automate and Power Automate Desktop. I hope it would be beneficial for those who wants to begin an adventure on automation, with these awesome Microsoft tools.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=656bff6b985f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Microsoft Power Platform: Definitive Guide]]></title>
            <link>https://medium.com/@berilevliyaoglu/microsoft-power-platform-definitive-guide-1-aab5e8adf831?source=rss-84e212136806------2</link>
            <guid isPermaLink="false">https://medium.com/p/aab5e8adf831</guid>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[power-platform-training]]></category>
            <category><![CDATA[dataverse]]></category>
            <category><![CDATA[power-platform-developers]]></category>
            <category><![CDATA[microsoft]]></category>
            <dc:creator><![CDATA[Beril]]></dc:creator>
            <pubDate>Tue, 15 Aug 2023 14:22:17 GMT</pubDate>
            <atom:updated>2023-08-18T10:20:03.426Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello, I’m Beril 😊 I am a software engineer who is working with Power Platform tools to create smart solutions for businesses. I have PL-900: Power Platform Fundamentals, PL-100: Power Platform App Maker Associate certificates and I am currently studying for PL-500: Power Automate RPA Developer exam. I am experienced in Power Apps, Power Automate Desktop, and Power Pages.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/627/1*sZAXvKDjn2_6I48wt1FsvQ.png" /><figcaption>Figure from learn.microsoft.com</figcaption></figure><p>In this article, we are going to take a brief look at what Power Platform is offering us. The product family consists of <strong>Power Apps, Power Automate, Power BI, Power Pages, and Power Virtual Agents</strong>. You must heard of at least one of these products if you are interested in technology trends. These products are game-changer for businesses who need smart ways to create and utilize apps, understand data, automate tasks, and connect with customers.</p><p>The silver lining is, you don’t need to be a software developer to start your journey on Microsoft Power Platform. In fact, the environment is highly suitable for a citizen-developer to generate smart business solutions for their own business. <em>I will often provide beneficial terminology to help you follow the article better.</em> A <strong>citizen-developer</strong> is a person who is not a software developer, but is creating smart business solutions by using low-code/no-code tools. In this manner, Microsoft Power Platform allows its users to create functional applications with minimal or no prior coding knowledge. And if you are a software developer, master these products and be creative! 😊</p><p>Let’s begin by getting to know the products of the family.</p><p>· <strong>Power BI</strong>: Power BI is a business intelligence tool that allows users to connect their data sources and receive valuable insights from it. It displays the attractive data visuals in a user-friendly designed environment. You can create reports, dashboards and real-time data stream with Power BI for your business.</p><p>· <strong>Power Apps:</strong> Power Apps enables the users to build custom apps for business needs in a low-code development environment. There is two types of apps that you can create; canvas apps and model-driven apps. If you are prioritizing the UI/UX design of your app, a canvas app provides customizable design options for users. If you are prioritizing the data, a model-driven app is more suitable for working with data-models. You can create both web and mobile applications by using Power Apps. Note that these applications are typically for internal-use. Meaning that the app should be utilized by your company’s employees. If you are looking something for external-use, you should maybe check Power Pages.</p><p>· <strong>Power Automate: </strong>Power Automate helps you to create workflows by connecting different apps, services, and data sources. The main goal is reducing the workload of employees by automating the repetitive tasks, so that the employee can actually focus on more strategic and value-added activities. In Power Automate, there is three types of cloud flows that you can use according to your need; <strong>automated flows, instant flows, and scheduled flows</strong>.</p><p>The three different types of flows differentiates in terms of when and how the flow is going to start running. In automated flows, the flow is triggered by the occurence of a specific event. Instant flows are often used for immediate actions so they run with an instant click of a button. Scheduled flows, as the name suggests, run with a schedule. For instance, you can set a scheduled flow to run every 2 hours.</p><p>Power Automate provides a good selection of cloud flow templates with high number of connectors. You should definitely check them out if you are new to workflows. Other than cloud flows, there is desktop flows that you can utilize by installing Power Automate Desktop. Desktop flows are for building RPA (Robotic Process Automation) processes. If you don’t have prior RPA knowledge, Power Automate Desktop might not be the most suitable choice for a citizen-developer. I will be talking more about Power Automate Desktop in my future articles.</p><p>·<strong> Power Virtual Agents:</strong> Power Virtual Agents enable you to create AI-powered chatbots without data science or any development expertise. It is again a suitable development environment for a citizen-developer like the rest of the Power Platform products are offering. The chatbot can answer frequently asked questions, and even can resolve issues requiring a more complex conversation. Chatbots can also perform an action by calling a Power Automate flow.</p><p>·<strong> Power Pages</strong>: Power Pages is the newest product of the family. You can design, configure, and publish websites with very low time and effort. After you publish a website, you can also watch and evaluate the analytics for strengthening user engagement. As a citizen-developer, you can utilize the templates and ready-to-use components. If you are a developer, you can add custom codes to your website to make it more custom. I will be also talking more about Power Pages in my future articles.</p><p>Now that we are familiar with the products, let’s take a look at Power Platform features; <strong>Data connectors, AI Builder, and Dataverse.</strong></p><p>·<strong> Data Connectors: </strong>Data connectors connect applications, data, and devices in the cloud. Microsoft have over 600 connectors that you can use while working with the Power Platform products. You can also build a custom connector if you want to call an API, services, or sytems that aren’t prebuilt. We can think connectors as bridges that carries information from a source to target environment.</p><p>· <strong>AI Builder:</strong> AI builder lets you easily create and train your own AI models, or use prebuilt models. You can utilize these models on your Power Apps and Power Automate implementations. Some of the prebuilt AI models that are ready to use are; sentiment analysis, text recognition, invoice processing, etc.</p><p>· <strong>Dataverse: </strong>Dataverse is a data platform that you can store, manage, and model data. Preferring dataverse for your Power Platform applications provides you a consistent and secure data platform. Dataverse offers a standardized data schema and a set of built-in tables that can be customized to match specific needs of your organization.</p><p><strong>Dataverse Table Types:</strong></p><p>· <strong>Standard Tables </strong>are the pre-built tables in Dataverse. You can find common used tables from a good variety of options and you can tailor them according to your needs. Note that, tables can be tagged as standard if they are part of a managed solution but marked as customizable.</p><p>· <strong>Managed Tables </strong>are part of a managed solution and typically are not customizable.</p><p>· <strong>Unmanaged (Custom) Tables</strong> are the tables you create directly within the Dataverse, or imported as a part of an unmanaged solution.</p><p><em>Terminology Break:</em> In the context of Microsoft Power Platform, <strong>a solution</strong> refers to a packaged collection of components that are going to be managed, transported, and deployed together.</p><p><strong>Power Platform Admin Center:</strong> Power Platform admin center is the portal where administrators can manage and monitor Dataverse and Power Platform products. You can access environment settings, billing, policies etc. from here. Note that products have their own admin centers for further settings and options such as; Power BI admin portal, Power Pages portal management etc.</p><p><strong>Microsoft 365 Admin Center:</strong> Microsoft 365 admin center provides a comprehensive admin portal where you can manage user accounts, security settings, licenses etc.</p><p><em>Terminology Break:</em> <strong>An environment</strong> is basically a workspace where you can perform activities we talked about. Each environment has its own set of permissions, security settings, and resources including separate Dataverses. This separation makes you prepare well-set workspaces for your projects’ requirements in a single tenant.</p><p><em>Quick Tip:</em> Over time, a few Power Platform tools’ name have changed. So, if you are looking for a solution in communities and blogs, try searching both new and old names. For instance; Dataverse (Common Data Service), Power Pages (Power Apps Portal), Power Automate (Flow).</p><p>We have talked briefly about the products and features of Power Platform, as a kick-off of this series. I will be telling you more about my personal experiences on the Power Platform tools by diving deeper into the products. See you next time! 😊</p><p>References:</p><ul><li><a href="https://www.freecodecamp.org/news/microsoft-power-platform-fundamentals-certification-pl-900/">freeCodeCamp.org</a></li><li><a href="https://learn.microsoft.com/en-us/training/powerplatform/">learn.microsoft.com</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=aab5e8adf831" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>