<article class="post-12480 post type-post status-publish format-standard has-post-thumbnail category-power-platform tag-power-automate entry genesis-grid genesis-grid-1 genesis-grid-odd" aria-label="How to create Proper Case Strings in Power Automate"><header class="entry-header"><h2 class="entry-title"><a class="entry-title-link" rel="bookmark" href="https://www.tachytelic.net/2020/12/power-automate-proper-case/">How to create Proper Case Strings in Power Automate</a></h2> <p class="entry-meta"><time class="entry-time">December 2, 2020</time> by <span class="entry-author"><a href="https://www.tachytelic.net/author/paulie/" class="entry-author-link" rel="author"><span class="entry-author-name">Paulie</span></a></span> <span class="entry-comments-link"><a href="https://www.tachytelic.net/2020/12/power-automate-proper-case/#comments">4 Comments</a></span> </p></header><div class="entry-content"><a href="https://www.tachytelic.net/2020/12/power-automate-proper-case/"><img width="270" height="100" src="https://www.tachytelic.net/wp-content/uploads/Power-Automate-Proper-Case-1-270x100.png" class="grid-featured" alt="" loading="lazy" data-hero-candidate="" /></a><p>Sometimes strings in Power Automate need to be reformatted so that the first letter of each word is capitalized. This is know as "Proper Case". There is no function built in to perform this common task. PowerApps does have this function so I expect … <a href="https://www.tachytelic.net/2020/12/power-automate-proper-case/" class="more-link">[Continue reading] <span class="screen-reader-text">about How to create Proper Case Strings in Power Automate</span></a></p></div><footer class="entry-footer"><p class="entry-meta"><span class="entry-categories">Filed Under: <a href="https://www.tachytelic.net/category/power-platform/" rel="category tag">Power Platform</a></span> <span class="entry-tags">Tagged With: <a href="https://www.tachytelic.net/tag/power-automate/" rel="tag">Power Automate</a></span></p></footer></article><article class="post-12431 post type-post status-publish format-standard has-post-thumbnail category-power-platform tag-power-automate entry genesis-grid genesis-grid-2 genesis-grid-even" aria-label="Publish SharePoint data on a public website with Power Automate"><header class="entry-header"><h2 class="entry-title"><a class="entry-title-link" rel="bookmark" href="https://www.tachytelic.net/2020/11/power-automate-list-data-jquery-grid/">Publish SharePoint data on a public website with Power Automate</a></h2> <p class="entry-meta"><time class="entry-time">November 25, 2020</time> by <span class="entry-author"><a href="https://www.tachytelic.net/author/paulie/" class="entry-author-link" rel="author"><span class="entry-author-name">Paulie</span></a></span> <span class="entry-comments-link"><a href="https://www.tachytelic.net/2020/11/power-automate-list-data-jquery-grid/#comments">2 Comments</a></span> </p></header><div class="entry-content"><a href="https://www.tachytelic.net/2020/11/power-automate-list-data-jquery-grid/"><img width="270" height="100" src="https://www.tachytelic.net/wp-content/uploads/Power-Automate-jQuery-Grid-270x100.png" class="grid-featured" alt="" loading="lazy" /></a><p>In this post I am going to demonstrate how to collect data from a SharePoint list using Power Automate and publish it in a jQuery grid on any website. Many businesses store data in data sources that are easily accessible by Power Automate that might … <a href="https://www.tachytelic.net/2020/11/power-automate-list-data-jquery-grid/" class="more-link">[Continue reading] <span class="screen-reader-text">about Publish SharePoint data on a public website with Power Automate</span></a></p></div><footer class="entry-footer"><p class="entry-meta"><span class="entry-categories">Filed Under: <a href="https://www.tachytelic.net/category/power-platform/" rel="category tag">Power Platform</a></span> <span class="entry-tags">Tagged With: <a href="https://www.tachytelic.net/tag/power-automate/" rel="tag">Power Automate</a></span></p></footer></article><article class="post-12425 post type-post status-publish format-standard category-power-platform tag-power-automate entry genesis-grid genesis-grid-3 genesis-grid-odd" aria-label="Add st, nd, rd and th (ordinal) suffix to a number in Power Automate"><header class="entry-header"><h2 class="entry-title"><a class="entry-title-link" rel="bookmark" href="https://www.tachytelic.net/2020/11/power-automate-create-ordinal-number/">Add st, nd, rd and th (ordinal) suffix to a number in Power Automate</a></h2> <p class="entry-meta"><time class="entry-time">November 22, 2020</time> by <span class="entry-author"><a href="https://www.tachytelic.net/author/paulie/" class="entry-author-link" rel="author"><span class="entry-author-name">Paulie</span></a></span> <span class="entry-comments-link"><a href="https://www.tachytelic.net/2020/11/power-automate-create-ordinal-number/#comments">2 Comments</a></span> </p></header><div class="entry-content"><a href="https://www.tachytelic.net/2020/11/power-automate-create-ordinal-number/"><img width="270" height="100" src="https://www.tachytelic.net/wp-content/uploads/Power-Automate-Ordinal-Number-Flow-270x100.png" class="grid-featured" alt="" loading="lazy" /></a><p>Sometimes you need to create an ordinal number for use in an email or similar situation. Power Apps does not have any support for this type of number formatting but it can be created quite easily with an expression. The rules are as follows: st … <a href="https://www.tachytelic.net/2020/11/power-automate-create-ordinal-number/" class="more-link">[Continue reading] <span class="screen-reader-text">about Add st, nd, rd and th (ordinal) suffix to a number in Power Automate</span></a></p></div><footer class="entry-footer"><p class="entry-meta"><span class="entry-categories">Filed Under: <a href="https://www.tachytelic.net/category/power-platform/" rel="category tag">Power Platform</a></span> <span class="entry-tags">Tagged With: <a href="https://www.tachytelic.net/tag/power-automate/" rel="tag">Power Automate</a></span></p></footer></article><article class="post-12407 post type-post status-publish format-standard has-post-thumbnail category-power-platform tag-power-automate entry genesis-grid genesis-grid-4 genesis-grid-even" aria-label="Working with locked documents in Power Automate Flows"><header class="entry-header"><h2 class="entry-title"><a class="entry-title-link" rel="bookmark" href="https://www.tachytelic.net/2020/11/power-automate-locked-document/">Working with locked documents in Power Automate Flows</a></h2> <p class="entry-meta"><time class="entry-time">November 21, 2020</time> by <span class="entry-author"><a href="https://www.tachytelic.net/author/paulie/" class="entry-author-link" rel="author"><span class="entry-author-name">Paulie</span></a></span> <span class="entry-comments-link"><a href="https://www.tachytelic.net/2020/11/power-automate-locked-document/#comments">6 Comments</a></span> </p></header><div class="entry-content"><a href="https://www.tachytelic.net/2020/11/power-automate-locked-document/"><img width="270" height="100" src="https://www.tachytelic.net/wp-content/uploads/Locked-Files-Power-Automate-270x100.png" class="grid-featured" alt="" loading="lazy" /></a><p>If you are updating the status of a document in a Microsoft Power Automate flow that someone is already using, you will get this error: and it will return a HTTP Status code of 400: Below is a method that waits for the file to be free and … <a href="https://www.tachytelic.net/2020/11/power-automate-locked-document/" class="more-link">[Continue reading] <span class="screen-reader-text">about Working with locked documents in Power Automate Flows</span></a></p></div><footer class="entry-footer"><p class="entry-meta"><span class="entry-categories">Filed Under: <a href="https://www.tachytelic.net/category/power-platform/" rel="category tag">Power Platform</a></span> <span class="entry-tags">Tagged With: <a href="https://www.tachytelic.net/tag/power-automate/" rel="tag">Power Automate</a></span></p></footer></article><article class="post-12389 post type-post status-publish format-standard has-post-thumbnail category-power-platform tag-power-automate entry genesis-grid genesis-grid-5 genesis-grid-odd" aria-label="Easily convert Excel Dates to usable Power Automate Dates"><header class="entry-header"><h2 class="entry-title"><a class="entry-title-link" rel="bookmark" href="https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/">Easily convert Excel Dates to usable Power Automate Dates</a></h2> <p class="entry-meta"><time class="entry-time">November 15, 2020</time> by <span class="entry-author"><a href="https://www.tachytelic.net/author/paulie/" class="entry-author-link" rel="author"><span class="entry-author-name">Paulie</span></a></span> <span class="entry-comments-link"><a href="https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/#comments">1 Comment</a></span> </p></header><div class="entry-content"><a href="https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/"><img width="270" height="100" src="https://www.tachytelic.net/wp-content/uploads/Convert-Excel-Dates-to-usable-Power-Automate-Dates-270x100.png" class="grid-featured" alt="" loading="lazy" /></a><p>When you use the "List rows present in a Table" action in Power Automate to get data from Excel that contains dates, you might be surprised to see that the data in the date column is actually an integer and not a date. Take a look at this Excel … <a href="https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/" class="more-link">[Continue reading] <span class="screen-reader-text">about Easily convert Excel Dates to usable Power Automate Dates</span></a></p></div><footer class="entry-footer"><p class="entry-meta"><span class="entry-categories">Filed Under: <a href="https://www.tachytelic.net/category/power-platform/" rel="category tag">Power Platform</a></span> <span class="entry-tags">Tagged With: <a href="https://www.tachytelic.net/tag/power-automate/" rel="tag">Power Automate</a></span></p></footer></article><div class="archive-pagination pagination" role="navigation" aria-label="Pagination"><ul><li class="pagination-previous"><a href="https://www.tachytelic.net/page/6/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1" >« <span class="screen-reader-text">Go to</span> Previous Page</a></li> <li><a href="https://www.tachytelic.net/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1"><span class="screen-reader-text">Go to page</span> 1</a></li> <li class="pagination-omission"><span class="screen-reader-text">Interim pages omitted</span> …</li> <li><a href="https://www.tachytelic.net/page/5/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1"><span class="screen-reader-text">Go to page</span> 5</a></li> <li><a href="https://www.tachytelic.net/page/6/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1"><span class="screen-reader-text">Go to page</span> 6</a></li> <li class="active" ><a href="https://www.tachytelic.net/page/7/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1" aria-label="Current page" aria-current="page"><span class="screen-reader-text">Go to page</span> 7</a></li> <li><a href="https://www.tachytelic.net/page/8/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1"><span class="screen-reader-text">Go to page</span> 8</a></li> <li><a href="https://www.tachytelic.net/page/9/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1"><span class="screen-reader-text">Go to page</span> 9</a></li> <li class="pagination-omission"><span class="screen-reader-text">Interim pages omitted</span> …</li> <li><a href="https://www.tachytelic.net/page/34/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1"><span class="screen-reader-text">Go to page</span> 34</a></li> <li class="pagination-next"><a href="https://www.tachytelic.net/page/8/?ref=hexometer&amp&gppro-loggedout=1&gppro-preview=1" ><span class="screen-reader-text">Go to</span> Next Page »</a></li> </ul></div>