proven.lol

https://architect.ericgregorich.com

HASH 0936e040b20d8bba7b5e6a07b6180c72

This item was proven by @ericgregorich on 2024-04-13T16:42:14+00:00. (View all of @ericgregorich’s proofs.)

Evidence

This is a copy of the web page retrieved on 2024-04-13T16:42:14+00:00. Show the proof snippet.

<!DOCTYPE html> <html lang="en"><head> <meta name="generator" content="Hugo 0.117.0"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Eric Gregorich</title> <meta name="description" content=""> <link rel="shortcut icon" href="https://micro.blog/ericgregorich/favicon.png" type="image/x-icon"> <link rel="stylesheet" href="/css/main.css"> <style> :root { --body-background-color: #fbfbfb; --body-text-color: #252525; --body-accent-color: #252525; --body-hover-color: #dd4802; --card-background-color: #ffffff; --card-text-color: #252525; --card-accent-color: #134e85; --card-hover-color: #dd4802; --blockquote: #f8eec4; --blockquote-border: #d6a32e; --blockquote-text: #2a2a2b; --shadow-color: #2a2a2b; --card-border-color: #dfdfd9; --meta-color: #848484; } @media (prefers-color-scheme: dark) { :root { --body-background-color: #fbfbfb; --body-text-color: #252525; --body-accent-color: #252525; --body-hover-color: #dd4802; --card-background-color: #ffffff; --card-text-color: #252525; --card-accent-color: #134e85; --card-hover-color: #dd4802; --blockquote: #f8eec4; --blockquote-border: #d6a32e; --blockquote-text: #2a2a2b; --shadow-color: #2a2a2b; --card-border-color: #dfdfd9; --meta-color: #848484; } } </style> <link rel="canonical" href="https://architect.ericgregorich.com/"> <link rel="alternate" href="https://architect.ericgregorich.com/feed.xml" type="application/rss+xml" title="Eric Gregorich"> <link rel="alternate" href="https://architect.ericgregorich.com/feed.json" type="application/json" title="Eric Gregorich"> <link rel="me" href="https://micro.blog/ericgregorich"> <link rel="me" href="https://twitter.com/ericgregorich"> <link rel="me" href="https://github.com/ericgregorich"> <link rel="shortcut icon" href="https://micro.blog/ericgregorich/favicon.png" type="image/x-icon"> <link rel="EditURI" type="application/rsd+xml" href="https://architect.ericgregorich.com/rsd.xml"> <link rel="authorization_endpoint" href="https://micro.blog/indieauth/auth"> <link rel="token_endpoint" href="https://micro.blog/indieauth/token"> <link rel="subscribe" href="https://micro.blog/users/follow"> <link rel="webmention" href="https://micro.blog/webmention"> <link rel="micropub" href="https://micro.blog/micropub"> <link rel="microsub" href="https://micro.blog/microsub"> <link rel="stylesheet" href="/custom.css?1713026419"> <link rel="stylesheet" href="/css/all.min.css"> </head> <body onload="document.body.style.opacity='1'" style="opacity: 1;"> <header class="site-header"> <div class="site-header-row"> <a class="site-header-logo-link" href="/"> <img src="https://micro.blog/ericgregorich/avatar.jpg" class="site-image" alt="Eric Gregorich"> </a> </div> <div class="site-header-row"> <a class="site-header-title-link" href="/">Eric Gregorich</a> </div> <div class="site-header-row">Microsoft Power Platform and related services.</div> <div class="site-header-row"> <nav class="site-nav"> <a class="site-nav-link" href="https://architect.ericgregorich.com">Architect</a> <a class="site-nav-link" href="https://blog.ericgregorich.com">Blog</a> <a class="site-nav-link" href="https://essays.ericgregorich.com">Essays</a> <a class="site-nav-link" href="https://notes.ericgregorich.com">Notes</a> <a class="site-nav-link" href="https://blog.ericgregorich.com/follow">Follow</a> <a class="site-nav-link" href="https://architect.ericgregorich.com/search-space/">Search</a> <a class="site-nav-link" href="https://ericgregorich.com">More</a> </nav> </div> </header> <div class="page-content"> <div class="wrapper"> <div class="archive_categories"> <p><a href="https://architect.ericgregorich.com/categories/azure/">azure</a></p> <p><a href="https://architect.ericgregorich.com/categories/dataverse/">dataverse</a></p> <p><a href="https://architect.ericgregorich.com/categories/power-apps/">power-apps</a></p> <p><a href="https://architect.ericgregorich.com/categories/power-automate/">power-automate</a></p> <p><a href="https://architect.ericgregorich.com/categories/sharepoint/">sharepoint</a></p> </div> <div class="home h-feed"> <ul class="post-list"> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/13/microsoft-power-automate.html" class="post-list-item-title">Microsoft Power Automate Approval Types</a></h1> <a href="https://architect.ericgregorich.com/2024/04/13/microsoft-power-automate.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-13T11:29:00Z">April 13, 2024 11:29am</time></span></a> <div class="post-list-item-content"> <p>Microsoft Power Automate has two main Approval Types. Everyone must approve: All included approvers must approve. First to respond: Requires approval from only one of the approvers. First to respond When one approver approves (or rejects), their approval task is marked as approved (or rejected) and … <a href="https://architect.ericgregorich.com/2024/04/13/microsoft-power-automate.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/11/change-power-automate.html" class="post-list-item-title">Change Power Automate workflow owner</a></h1> <a href="https://architect.ericgregorich.com/2024/04/11/change-power-automate.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-11T21:45:00Z">April 11, 2024 9:45pm</time></span></a> <div class="post-list-item-content"> <p>The following shows how to change the owner of a Power Automate workflow, which is necessary to ensure it is running with a user account that has a proper license. Prerequisites The Flow must be in a solution. Changing the Flow Owner Open the flow Details screen. Click the Edit link in the Details … <a href="https://architect.ericgregorich.com/2024/04/11/change-power-automate.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/05/filter-dataverse-rows.html" class="post-list-item-title">OData filter of Dataverse rows by Choice value</a></h1> <a href="https://architect.ericgregorich.com/2024/04/05/filter-dataverse-rows.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-05T09:07:00Z">April 5, 2024 9:07am</time></span></a> <div class="post-list-item-content"> <p>I’m using Microsoft Power Automate to query a Dataverse table. I want to return all rows where my Choice column, named Sync Status is equal to the choice value of “New”. This is a little different than when we want to filter by text or number field types. A choice column is a bit … <a href="https://architect.ericgregorich.com/2024/04/05/filter-dataverse-rows.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/04/how-to-format.html" class="post-list-item-title">How to format a Date as text in a Canvas Power App</a></h1> <a href="https://architect.ericgregorich.com/2024/04/04/how-to-format.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-04T10:00:00Z">April 4, 2024 10:00am</time></span></a> <div class="post-list-item-content"> <p>In a Canvas Power App, if you are returning a Date field from a Data Source, and it includes both the date and time. But, you only want to show the date as text in another control. You can use the following formula. Text( DateTimeValue(ThisItem.DateColumn), DateTimeFormat.ShortDate ) You can change … <a href="https://architect.ericgregorich.com/2024/04/04/how-to-format.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/03/check-for-null.html" class="post-list-item-title">Check for null value from SharePoint</a></h1> <a href="https://architect.ericgregorich.com/2024/04/03/check-for-null.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-03T17:09:00Z">April 3, 2024 5:09pm</time></span></a> <div class="post-list-item-content"> <p>If you use Power Automate with SharePoint Online list or library data and need to check if a field is empty or null, you can use the&nbsp;@empty&nbsp;function in an expression. <a href="https://architect.ericgregorich.com/2024/04/03/check-for-null.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/03/working-with-checkbox.html" class="post-list-item-title">Working with Checkbox controls in a Power Apps Gallery</a></h1> <a href="https://architect.ericgregorich.com/2024/04/03/working-with-checkbox.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-03T17:06:00Z">April 3, 2024 5:06pm</time></span></a> <div class="post-list-item-content"> <p>Handling checkboxes can be tricky and does not always work as expected. Using a collection is a simple and robust solution. For this demo, let’s set up a Gallery with checkbox controls to demonstrate various ways to interact with them. Load the Data Add a button and update the OnSelect … <a href="https://architect.ericgregorich.com/2024/04/03/working-with-checkbox.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/04/01/auto-scroll-to.html" class="post-list-item-title">Auto Scroll to specific item in a Power Apps Gallery</a></h1> <a href="https://architect.ericgregorich.com/2024/04/01/auto-scroll-to.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-04-01T10:00:00Z">April 1, 2024 10:00am</time></span></a> <div class="post-list-item-content"> <p>Let say we have a Gallery that has many items in it, and we want to automatically scroll to a specific item when the screen loads (or some other event). We can do this by setting the Default property in the Gallery. Update the Default property of your Gallery to something like the following: … <a href="https://architect.ericgregorich.com/2024/04/01/auto-scroll-to.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/03/20/azure-app-registration.html" class="post-list-item-title">Azure App Registration for Select SharePoint Sites</a></h1> <a href="https://architect.ericgregorich.com/2024/03/20/azure-app-registration.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-03-20T10:00:00Z">March 20, 2024 10:00am</time></span></a> <div class="post-list-item-content"> <p>This post explains how to create an Azure App Registration and configure it to provide your application access to only select SharePoint sites. The Azure App Registration provides your application the permissions it needs to various sources, in this example, SharePoint. This eliminates the need to … <a href="https://architect.ericgregorich.com/2024/03/20/azure-app-registration.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/03/16/power-apps-delegation.html" class="post-list-item-title">Power Apps Delegation</a></h1> <a href="https://architect.ericgregorich.com/2024/03/16/power-apps-delegation.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-03-16T09:00:00Z">March 16, 2024 9:00am</time></span></a> <div class="post-list-item-content"> <p>Power Apps can connect to many data sources and use the data in various ways. However, Power Apps will not be able to return all items at once. By default, Power Apps will be able to process 500 items from a Data Source. This can be changed to at most 2000 items through the app settings. This does … <a href="https://architect.ericgregorich.com/2024/03/16/power-apps-delegation.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/03/14/remove-a-redirected.html" class="post-list-item-title">Remove a redirected SharePoint site URL</a></h1> <a href="https://architect.ericgregorich.com/2024/03/14/remove-a-redirected.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-03-14T10:00:00Z">March 14, 2024 10:00am</time></span></a> <div class="post-list-item-content"> <p>How to remove a Microsoft SharePoint site redirected site URL using PowerShell. When a Microsoft SharePoint Online site URL is changed, a redirect is automatically applied that redirects the old URL to the new URL. You may need to remove this redirect to reuse the old URL. The PowerShell below can … <a href="https://architect.ericgregorich.com/2024/03/14/remove-a-redirected.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/03/12/bypass-the-power.html" class="post-list-item-title">Bypass the Power Apps consent dialog</a></h1> <a href="https://architect.ericgregorich.com/2024/03/12/bypass-the-power.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-03-12T09:00:00Z">March 12, 2024 9:00am</time></span></a> <div class="post-list-item-content"> <p>How to use PowerShell to disable the consent dialog showing when a user opens Power Apps for the first time or when a new connection is added. Set Consent Bypass PowerShell can disable the consent dialog when the user opens the Power App for the first time or when a new connection is added. … <a href="https://architect.ericgregorich.com/2024/03/12/bypass-the-power.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/03/11/using-double-quotes.html" class="post-list-item-title">Using Double Quotes in Power Apps</a></h1> <a href="https://architect.ericgregorich.com/2024/03/11/using-double-quotes.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-03-11T10:00:00Z">March 11, 2024 10:00am</time></span></a> <div class="post-list-item-content"> <p>When writing text in Microsoft Power Apps controls, you may need to add a double quote as part of your text. Power Apps uses the Power Fx language. It would be best to convert the " to &amp;amp;Char(34) to encode them into the correct character. <a href="https://architect.ericgregorich.com/2024/03/11/using-double-quotes.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/03/01/how-to-check.html" class="post-list-item-title">How to check your Power Automate licenses</a></h1> <a href="https://architect.ericgregorich.com/2024/03/01/how-to-check.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-03-01T12:00:00Z">March 1, 2024 12:00pm</time></span></a> <div class="post-list-item-content"> <p>Microsoft has provided some PowerShell that allows admins to check their Power Platform environment for invalid Power Automate Licenses before it becomes an issue. Unlicensed Power Automate Flows will be turned off. Microsoft is enforcing licensing on all Power Automate flows. The flow owner will be … <a href="https://architect.ericgregorich.com/2024/03/01/how-to-check.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/02/26/search-o-users.html" class="post-list-item-title">Search O365 Users in a Combobox in Power Apps</a></h1> <a href="https://architect.ericgregorich.com/2024/02/26/search-o-users.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-02-26T11:00:00Z">February 26, 2024 11:00am</time></span></a> <div class="post-list-item-content"> <p>We can search all users in the tenant by adding the Office365Users connector to our Microsoft Power Apps. Add Office365Users data connector. Add a ComboBox control. Enable searching in the ComboBox control. In the Items property of the ComboBox control, add the following formula. … <a href="https://architect.ericgregorich.com/2024/02/26/search-o-users.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/02/24/format-a-number.html" class="post-list-item-title">Format a number in Power Apps</a></h1> <a href="https://architect.ericgregorich.com/2024/02/24/format-a-number.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-02-24T11:00:00Z">February 24, 2024 11:00am</time></span></a> <div class="post-list-item-content"> <p>If we have a number value that we want to format to include a comma and decimal, we can use the following formula. Text( Value("2645.40"), "[$-en-US]#,##0.00" ) The above example will output the value: 2,645.40. <a href="https://architect.ericgregorich.com/2024/02/24/format-a-number.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/02/13/converting-from-utc.html" class="post-list-item-title">Converting from UTC in Power Apps</a></h1> <a href="https://architect.ericgregorich.com/2024/02/13/converting-from-utc.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-02-13T10:00:00Z">February 13, 2024 10:00am</time></span></a> <div class="post-list-item-content"> <p>We can use the TimeZoneOffset function in Power Apps to adjust for the current time zone from UTC time. We would typically want to save our Dates as UTC time in any database we’re using, and convert those dates to the local time zone when viewing them in our app. This example, takes the date … <a href="https://architect.ericgregorich.com/2024/02/13/converting-from-utc.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/02/12/power-apps-host.html" class="post-list-item-title">Power Apps Host Property</a></h1> <a href="https://architect.ericgregorich.com/2024/02/12/power-apps-host.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-02-12T09:00:00Z">February 12, 2024 9:00am</time></span></a> <div class="post-list-item-content"> <p>The Power Apps Host property provides helpful information about the application, including the BrowserUserAgent, OSType, SessionID, and TenantID. In the formula bar, type Host followed by a dot and the property you wish to access. Host.BrowserUserAgent - Tells you what browser the user uses to … <a href="https://architect.ericgregorich.com/2024/02/12/power-apps-host.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/02/05/create-a-selfsigned.html" class="post-list-item-title">Create a self-signed Certificate using PowerShell</a></h1> <a href="https://architect.ericgregorich.com/2024/02/05/create-a-selfsigned.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-02-05T11:00:00Z">February 5, 2024 11:00am</time></span></a> <div class="post-list-item-content"> <p>Run the following PowerShell to create a self-signed certificate using Windows and PowerShell. Useful for creating certificates to use in Azure App Registrations. Open Windows PowerShell ISE as an administrator. Use the cd command to change to a directory of your choice where you want to save the … <a href="https://architect.ericgregorich.com/2024/02/05/create-a-selfsigned.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/02/04/power-apps-with.html" class="post-list-item-title">Power Apps With Function</a></h1> <a href="https://architect.ericgregorich.com/2024/02/04/power-apps-with.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-02-04T09:00:00Z">February 4, 2024 9:00am</time></span></a> <div class="post-list-item-content"> <p>The Microsoft Power Apps With function&nbsp;is a powerful way to divide complex formulas into smaller pieces. It is useful when used within a ForAll, since we can’t set variables within a ForAll. Since the formula is contained, it is preferred over context variables created using UpdateContext or global … <a href="https://architect.ericgregorich.com/2024/02/04/power-apps-with.html" class="continue-link">read more</a></p> </div> </li> <li class="post-list-item"> <h1 class="p-name"><a href="https://architect.ericgregorich.com/2024/01/21/infopath-end-of.html" class="post-list-item-title">InfoPath 2013 End of Support</a></h1> <a href="https://architect.ericgregorich.com/2024/01/21/infopath-end-of.html" class="post-list-item-date"><span class="post-meta"><time class="dt-published" datetime="2024-01-21T11:00:00Z">January 21, 2024 11:00am</time></span></a> <div class="post-list-item-content"> <p>InfoPath 2013 client and InfoPath Forms Services in SharePoint Online will end support in July 2026. There is an InfoPath Forms Services Assessment tool that can help identify and evaluate usage on your tenant. The Microsoft 365 Assessment Tool helps you identify and evaluate the InfoPath Forms … <a href="https://architect.ericgregorich.com/2024/01/21/infopath-end-of.html" class="continue-link">read more</a></p> </div> </li> </ul> </div> <div class="pagination"> <nav id="post-nav"> <span class="next"> <a href="/page/2/"> Older Posts <span class="arrow">→</span> </a> </span> </nav> </div> </div> </div> <footer class="site-footer"> <div class="site-footer-content"> <div class="footer-col footer-col-3"> <p class="site-footer-text"><br> <strong>What's next?</strong> </p><div> Explore the site by checking out some <strong><a href="/surprise-me">random posts</a></strong> or <strong><a href="/search-space">search</a></strong>. If I was helpful, please buy me a <strong><a href="https://ko-fi.com/ericgregorich">coffee</a></strong>. </div> <br> <br> <div class="footer-links" style="font-size: 24px"> <a title="Subscribe" href="https://blog.ericgregorich.com/subscribe"><i class="fa-solid fa-rss"></i></a>&nbsp; <a title="Email" href="https://blog.ericgregorich.com/email"><i class="fa-solid fa-envelope"></i></a>&nbsp; <a title="Micro.blog" href="https://micro.blog/ericgregorich"><i class="fa-brands fa-microblog"></i></a>&nbsp;&nbsp; <a title="Github" href="https://github.com/ericgregorich"><i class="fa-brands fa-github"></i></a> </div> <br> <div style="font-size: 12px"> Powered by <a href="https://micro.blog">Micro.blog</a> and the <a href="https://cards.ericgregorich.com/">Cards Theme</a> </div> <script src="https://tinylytics.app/embed/15uChMC6e9VT645fWfPj.js?kudos=❤️" defer=""></script> <div style="display:none">proven.lol/211ddc</div><p></p> </div> </div> </footer> <script>(function(){if (!document.body) return;var js = "window['__CF$cv$params']={r:'873ce87c8cf89b56',t:'MTcxMzAyNjUzMy45NjIwMDA='};_cpo=document.createElement('script');_cpo.nonce='',_cpo.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js',document.getElementsByTagName('head')[0].appendChild(_cpo);";var _0xh = document.createElement('iframe');_0xh.height = 1;_0xh.width = 1;_0xh.style.position = 'absolute';_0xh.style.top = 0;_0xh.style.left = 0;_0xh.style.border = 'none';_0xh.style.visibility = 'hidden';document.body.appendChild(_0xh);function handler() {var _0xi = _0xh.contentDocument || _0xh.contentWindow.document;if (_0xi) {var _0xj = _0xi.createElement('script');_0xj.innerHTML = js;_0xi.getElementsByTagName('head')[0].appendChild(_0xj);}}if (document.readyState !== 'loading') {handler();} else if (window.addEventListener) {document.addEventListener('DOMContentLoaded', handler);} else {var prev = document.onreadystatechange || function () {};document.onreadystatechange = function (e) {prev(e);if (document.readyState !== 'loading') {document.onreadystatechange = prev;handler();}};}})();</script><iframe height="1" width="1" style="position: absolute; top: 0px; left: 0px; border: none; visibility: hidden;"></iframe> </body></html>