Congratulations!

[Valid Atom 1.0] This is a valid Atom 1.0 feed.

Recommendations

This feed is valid, but interoperability with the widest range of feed readers could be improved by implementing the following recommendations.

Source: http://feeds2.feedburner.com/TechTrainingNotes

  1. <?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-6074070440029916342</id><updated>2024-04-19T15:40:12.267-04:00</updated><category term="SharePoint"/><category term="SharePoint 2010"/><category term="SharePoint Site Owner"/><category term="SharePoint 2013"/><category term="SharePoint Administration"/><category term="SharePoint Development"/><category term="Office 365"/><category term="PowerShell"/><category term="SharePoint Customization"/><category term="Content Editor Web Part Tricks"/><category term="SharePoint Online"/><category term="SharePoint 2016"/><category term="SharePoint User Group"/><category term="SharePoint Branding"/><category term="SharePoint Governance"/><category term=".Net"/><category term="SharePoint Search"/><category term="SharePoint Certification"/><category term="SharePoint Saturday"/><category term="Certification"/><category term="PowerShell User Group"/><category term="SharePoint Events"/><category term="Microsoft Office 2010"/><category term="SQL Server"/><category term="SharePoint Security"/><category term="Book Review"/><category term="SharePoint Training"/><category term="CSS"/><category term="InfoPath"/><category term="SharePoint Power User"/><category term="C#"/><category term="SharePoint Designer"/><category term="TOC"/><category term="Visual Studio"/><category term="Azure"/><category term="Microsoft Office 2007"/><category term="SharePoint Calendar"/><category term="SharePoint Surveys"/><category term="SharePoint Workflow"/><category term="Windows"/><category term="Off Topic"/><category term="SharePoint Task List"/><category term="Silverlight"/><category term="ASP.NET"/><category term="Power BI"/><category term="SharePoint REST API"/><category term="Welcome"/><category term="Power Query"/><category term="SharePoint 2019"/><category term="SharePoint Excel Services"/><category term="SharePoint Links List"/><category term="Visio"/><category term="Wiki Library"/><category term="CSOM"/><category term="MVC"/><category term="Middleware"/><category term="OneDrive"/><category term="PerformancePoint"/><category term="PowerShell Saturday"/><category term="SharePoint Access Services"/><category term="SharePoint Validation Formula"/><category term="Teams"/><category term="Windows 10"/><title type='text'>Mike Smith&#39;s Tech Training Notes  SharePoint, PowerShell and .Net!</title><subtitle type='html'>SharePoint, PowerShell, .Net and other stuff I spend too much time on...&#xa;&#xa;</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://techtrainingnotes.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>626</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-8269422989947403546</id><published>2022-03-18T19:14:00.002-04:00</published><updated>2022-03-19T21:52:49.661-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".Net"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.NET"/><category scheme="http://www.blogger.com/atom/ns#" term="C#"/><category scheme="http://www.blogger.com/atom/ns#" term="Middleware"/><title type='text'>ASP.NET Core Middleware to Update Response Body</title><summary type="text">I needed a quick way to update a mix of static HTML files and Razor views to change a message common to a lot of pages. In the example here I will update the Copyright message in HTML pages.As usual I searched the web and found many examples, none that worked the way I needed (or worked at all!), but I did find an assortment of &quot;bits&quot; scattered throughout StackOverflow that helped me build a </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=8269422989947403546' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/8269422989947403546'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/8269422989947403546'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2022/03/aspnet-core-middleware-to-update.html' title='ASP.NET Core Middleware to Update Response Body'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/a/AVvXsEg4bpTWDDRMDoVXZKstpMHd-qN-dGilKNCQGiKEmW75TQIz54VVbE0w_29KyMxqm3MhlCftZtPAvNSo8cXwWM9kGBLThORjvDZRHOU5Ars78Wdph-W0G3wvA611JF92vAlQQAMCKm7RJtdaIKtJrmK98WrnZs9Y18nczHv-L5D6zjLwDQELWCHU0xVzCA=s72-c" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-3901654803314625674</id><published>2021-07-09T18:32:00.002-04:00</published><updated>2021-07-09T18:32:53.244-04:00</updated><title type='text'>Power BI Books</title><summary type="text">I am often asked for book recommendations in my classes. Book choices are a personal thing that varies based on your learning style. So, I rarely recommend any particular book. The books that follow are books that I really like and recommend.Storytelling with Data: A Data Visualization Guide for Business Professionals
  2.  
  3.  
  4.  
  5. This is not a Power BI book. Before you create a report, you should know</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=3901654803314625674' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/3901654803314625674'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/3901654803314625674'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2021/07/power-bi-books.html' title='Power BI Books'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-1038094472777321606</id><published>2020-08-04T15:30:00.003-04:00</published><updated>2020-08-05T16:43:17.334-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PowerShell"/><title type='text'>Merging JSON files using PowerShell</title><summary type="text">Let&#39;s say you have a directory full of JSON files and you need to merge them into a single file.Emp1.json&amp;nbsp;&amp;nbsp;&amp;nbsp; {&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &quot;Name&quot;:&amp;nbsp; &quot;Mike&quot;,&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &quot;ID&quot;:&amp;nbsp; 123,&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &quot;Status&quot;:&amp;nbsp; &quot;Active&quot;&amp;nbsp;&amp;nbsp;&amp;nbsp; }Emp2.json&amp;nbsp;&amp;nbsp;&amp;nbsp; {&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=1038094472777321606' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/1038094472777321606'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/1038094472777321606'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2020/08/merging-json-files-using-powershell.html' title='Merging JSON files using PowerShell'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-3246520060273640036</id><published>2020-08-03T19:39:00.002-04:00</published><updated>2021-01-06T21:29:52.536-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".Net"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.NET"/><category scheme="http://www.blogger.com/atom/ns#" term="C#"/><category scheme="http://www.blogger.com/atom/ns#" term="PowerShell"/><title type='text'>How to count lines of code using PowerShell</title><summary type="text">I&#39;ve got a project... scattered through a number of folders are a bunch of C# files. How many lines of code do I have? (Bragging rights you know...)You could open the project in Visual Studio and use the Analyze, Calculate Code Metrics. But that requires Visual Studio, and does not give me all the options I want. (But in many ways is better! Lines by file and by method are available there.)I </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=3246520060273640036' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/3246520060273640036'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/3246520060273640036'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2020/08/how-to-count-lines-of-code-using.html' title='How to count lines of code using PowerShell'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-5165147620667744781</id><published>2020-04-25T20:13:00.000-04:00</published><updated>2020-04-25T20:14:38.680-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PowerShell"/><title type='text'>PowerShell: When does zero equal one?  (Length property of a Directory)</title><summary type="text">
  6. You learn the most interesting things when teaching a class, especially when an off the cuff demo goes wrong.
  7.  
  8. During a simple demo of a calculated or derived column I did this:
  9.  
  10. For files, the output was as expected:
  11.  
  12.  
  13. But for directories it returned this:
  14.  
  15.  
  16. While the FileInfo object does have a Length property, the DirectoryInfo object does not. So what should we expect when both files and </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=5165147620667744781' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/5165147620667744781'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/5165147620667744781'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2020/04/powershell-when-does-zero-equal-one.html' title='PowerShell: When does zero equal one?  (Length property of a Directory)'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-1259332206083029599</id><published>2020-04-01T12:59:00.000-04:00</published><updated>2020-04-01T13:34:19.945-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="OneDrive"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="Teams"/><title type='text'>SharePoint vs. Teams vs. OneDrive</title><summary type="text">&lt;!--[if gte mso 9]&gt;
  18.  Normal
  19.  0
  20.  
  21.  
  22.  
  23.  
  24.  false
  25.  false
  26.  false
  27.  
  28.  EN-US
  29.  X-NONE
  30.  X-NONE
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42.  MicrosoftInternetExplorer4
  43.  
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51.  
  52.  
  53.  
  54.  
  55.  
  56. &lt;![endif]--&gt;&lt;!--[if gte mso 9]&gt;
  58.  
  59.  
  60.  
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76.  
  77.  
  78.  
  79.  
  80.  
  81.  
  82.  
  83.  
  84.  
  85.  
  86.  
  87.  
  88.  
  89.  
  90.  
  91.  
  92.  
  93.  
  94.  
  95.  
  96.  
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105.  
  106. </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=1259332206083029599' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/1259332206083029599'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/1259332206083029599'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2020/04/sharepoint-vs-teams-vs-onedrive.html' title='SharePoint vs. Teams vs. OneDrive'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-5413607346282948304</id><published>2019-07-22T21:55:00.000-04:00</published><updated>2019-07-22T21:55:57.431-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Customization"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Validation Formula"/><title type='text'>SharePoint Date Validation Formula to Prevent Selecting Holidays</title><summary type="text">
  107. We often want to prevent the selection of certain days when users enter tasks or events into SharePoint lists.
  108.  
  109.  
  110. I have over 100 Calculated Column and Validation formulas in my book!&amp;nbsp;
  111.  
  112.  
  113.  
  114. Block weekends
  115.  
  116. This formula is quite simple and uses the Excel WEEKDAY formula to test the day of the week. WEEKDAY assigns a number to each day using a &quot;scheme&quot;. The scheme I&#39;ll use here is &quot;2&quot; as it puts</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=5413607346282948304' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/5413607346282948304'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/5413607346282948304'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/07/sharepoint-date-validation-formula-to.html' title='SharePoint Date Validation Formula to Prevent Selecting Holidays'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-7062905558713717133</id><published>2019-07-20T22:38:00.002-04:00</published><updated>2019-07-20T22:39:06.189-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Power BI"/><category scheme="http://www.blogger.com/atom/ns#" term="Power Query"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><title type='text'>Power BI - Convert a Column into a Comma Delimited list.</title><summary type="text">
  117. When grouping data have you ever wanted to keep a summary of the details? Maybe as a comma delimited list as a single column?
  118.  
  119. I&#39;ve put together a sample project here that takes projects and their tasks and groups them by project and summarizes each project by summing project hours and by creating a comma delimited list of tasks.
  120.  
  121. Here&#39;s the source data. It happens to be from a SharePoint list </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=7062905558713717133' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/7062905558713717133'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/7062905558713717133'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/07/power-bi-convert-column-into-comma.html' title='Power BI - Convert a Column into a Comma Delimited list.'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-3330337878685808813</id><published>2019-07-20T14:23:00.004-04:00</published><updated>2019-07-20T14:23:45.043-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".Net"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.NET"/><category scheme="http://www.blogger.com/atom/ns#" term="MVC"/><title type='text'>The controller for path &#39;/&#39; was not found or does not implement IController #VisualStudio #MVC</title><summary type="text">
  122.  
  123.  
  124.  
  125.  
  126. The controller for path &#39;/&#39; was not found or does not implement IController
  127.  
  128. Some error messages are no help at all!
  129.  
  130.  
  131.  
  132.  
  133.  
  134.  
  135. When running in Debug mode Visual Studio reports:
  136.  
  137.  
  138.  
  139. An exception of type &#39;System.Web.HttpException&#39; occurred in System.Web.dll but was not handled in user code.
  140.  
  141. Additional information: Execution of the child request failed. Please examine the InnerException for more </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=3330337878685808813' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/3330337878685808813'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/3330337878685808813'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/07/the-controller-for-path-was-not-found.html' title='The controller for path &#39;/&#39; was not found or does not implement IController #VisualStudio #MVC'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn-N8a4kXNTD2HZf9i1ksSc_J8E2bPZLrSx2fdZBs2krf-vkfk9LFSNUzlkxZG2BXBeUrd4bFRF1_yfZn9p3Ilnlt8ow3yjSge1041vr0L8DVLOuTKCttpYQW3sV6Z34N-vDW-8g1pRycE/s72-c/image001-762865.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-2815856998490631280</id><published>2019-07-01T17:33:00.000-04:00</published><updated>2019-07-31T12:41:48.256-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Content Editor Web Part Tricks"/><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Customization"/><title type='text'>Dynamic Images in SharePoint Document Sets</title><summary type="text">One of the cool features of Document Sets is that you can customize the &quot;home
  142. page&quot; of the Document Set by adding or editing its Content Type&#39;s home page web
  143. parts. The default page includes an image web part that can be customized with
  144. your choice of image. The only problem here is that the image is then used for
  145. all Document Sets created from this Content Type. Here&#39;s the default &quot;home
  146. </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=2815856998490631280' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2815856998490631280'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2815856998490631280'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/07/dynamic-images-in-sharepoint-document.html' title='Dynamic Images in SharePoint Document Sets'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-2532685685817893191</id><published>2019-04-30T19:17:00.001-04:00</published><updated>2019-04-30T19:22:04.493-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Power BI"/><category scheme="http://www.blogger.com/atom/ns#" term="Power Query"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><title type='text'>SharePoint.Tables – Power BI – Power Query M Functions</title><summary type="text">
  147. The Microsoft DOCS article for SharePoint.Tables says &quot;Returns a table containing a row for each List item found at the specified SharePoint list url.&quot; While this sounds like it returns list &quot;Items&quot;, it actually returns a list of Lists. It also reads like the URL is supposed to point to a list. Instead, it should point to the site or subsite.
  148. If this was a typical DOCS article, I&#39;d click the </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=2532685685817893191' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2532685685817893191'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2532685685817893191'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/04/sharepointtables-power-bi-power-query-m.html' title='SharePoint.Tables – Power BI – Power Query M Functions'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-2109236683168709290</id><published>2019-04-29T13:41:00.001-04:00</published><updated>2019-04-29T14:04:06.660-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="Power BI"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint REST API"/><title type='text'>Three Ways to Load SharePoint Data into Power BI and Excel</title><summary type="text">
  149. Power BI includes a connector/wizard for SharePoint lists that makes is easy to load list content. It works great, but has a shortcoming or two. It first retrieves a list of all of the lists, and then it retrieves all of the list content… even if you only need a small subset of the data.
  150. In this little article I&#39;ll show these approaches:
  151.  
  152. Using the Wizards
  153. Writing your own &quot;M&quot; formulas
  154. Using </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=2109236683168709290' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2109236683168709290'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2109236683168709290'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/04/three-ways-to-load-sharepoint-data-into.html' title='Three Ways to Load SharePoint Data into Power BI and Excel'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-8275599730530444709</id><published>2019-03-16T14:24:00.001-04:00</published><updated>2019-03-16T14:29:40.679-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Administration"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>SharePoint Validation Formula Tip – Don&#39;t Use IF!</title><summary type="text">
  155. I often see questions about SharePoint validation formulas in the online forums that include IF statements to return True or False. Something like this:
  156.  
  157. &amp;nbsp;&amp;nbsp;&amp;nbsp; =IF(&amp;nbsp; someCondition , True, False&amp;nbsp; )
  158. &amp;nbsp;&amp;nbsp;&amp;nbsp; =IF( Amount &amp;gt; 100, True, False )
  159. &amp;nbsp;&amp;nbsp;&amp;nbsp; =IF( AND( State = &quot;OH&quot;, Amount&amp;gt;100 ), True, False )
  160.  
  161.  
  162. The IF is simply not needed!
  163. Simply replace </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=8275599730530444709' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/8275599730530444709'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/8275599730530444709'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2019/03/sharepoint-validation-formula-tip-dont.html' title='SharePoint Validation Formula Tip – Don&#39;t Use IF!'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhljU29gUO6hlClpvvGuI7WaiWfl_J_sxl5ValdVC72CxbZqUcmWWmXalD2kkVJp2uBH0wc3rNHmg0Z5WuFzMuCojlKXM8HEOtKxeSeOnCGv3eotR7BpbCpQH2gL0IUBc2AIUVBxRK8F8Vx/s72-c/valform1.png" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-2018965652558589967</id><published>2018-10-30T21:11:00.001-04:00</published><updated>2018-10-30T21:30:12.804-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2019"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Customization"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>SharePoint Calculated Columns – Convert a Month Name to a Number</title><summary type="text">Here are three solutions for when you have a column with a three letter abbreviation of a month name, and you want the month number,
  164. Each of the following assume that you have a &quot;Single Line of Text&quot; or &quot;Choice&quot; column named &quot;Month&quot;.
  165.  
  166. A long IF statement:IF([Month]=&quot;JAN&quot;,1,
  167.  IF([Month]=&quot;FEB&quot;,2,
  168.    IF([Month]=&quot;MAR&quot;,3,
  169.      IF([Month]=&quot;APR&quot;,4,
  170.        IF([Month]=&quot;MAY&quot;,5,
  171.          IF([Month]=&quot;</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=2018965652558589967' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2018965652558589967'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2018965652558589967'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/10/sharepoint-calculated-columns-convert.html' title='SharePoint Calculated Columns – Convert a Month Name to a Number'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-QS0BM8mlruI/W9kBRxvYr8I/AAAAAAAADmo/MEHiABhUfsso-oft-H3PA7QLKDQPdfU7QCHMYCw/s72-c/MonthNumber_thumb?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-7840829176412644491</id><published>2018-10-15T15:22:00.001-04:00</published><updated>2018-10-17T20:52:10.622-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2019"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Customization"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Development"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>SharePoint Calculated Columns and Validation Formulas – The Book!</title><summary type="text">Available on Amazon!
  172. It only took me a year… and it grew from a little booklet to over 200 pages… but its finally done!
  173.  
  174. Bought the book? Post any questions, bugs, typos and suggestions to this blog post!
  175. Everything you need to know about SharePoint formulas for SharePoint 2010 to 2019 and SharePoint Online / Office 365!
  176. This book is for the SharePoint “power user” who needs a better </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=7840829176412644491' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/7840829176412644491'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/7840829176412644491'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/10/sharepoint-calculated-columns-and.html' title='SharePoint Calculated Columns and Validation Formulas – The Book!'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-no_-NNJkzDs/W8fZOWzzv_I/AAAAAAAADmA/XvSkH3S-YcQ3a1AfWnxfGo5x2VOW6vLdQCHMYCw/s72-c/image%255B4%255D?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-4422752941503310298</id><published>2018-09-06T17:22:00.001-04:00</published><updated>2018-09-06T17:27:37.032-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>SharePoint Dates are Always Date AND Time</title><summary type="text">A Quick SharePoint Date Tip!When you create a Date column you have the choice of Date and Date &amp;amp; Time.
  177. &amp;nbsp;&amp;nbsp;&amp;nbsp; Note the keyword “Format” in that option. Even if you select “Date Only”, your users can still type, or copy and paste, a date and a time and it will be stored as a date and time. But… only the date will be displayed.
  178. Times are a Fraction of a DateTimes are represented </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=4422752941503310298' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/4422752941503310298'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/4422752941503310298'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/09/sharepoint-dates-are-always-date-and.html' title='SharePoint Dates are Always Date AND Time'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-wlL3WnV2M80/W5GaicC880I/AAAAAAAADlQ/j7zowpptSsMAbVwEDMURGqLFSbq2jICZACHMYCw/s72-c/image_thumb%255B6%255D?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-242759307660973860</id><published>2018-04-20T23:59:00.001-04:00</published><updated>2018-04-21T00:12:30.546-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>The Mysterious Semicolon in SharePoint Search</title><summary type="text">Discoveries:A semicolon in a search is the same as the keyword &quot;AND&quot;.
  179. You cannot uniquely find text that contains a semicolon. (such as ABC;DEF)
  180. A semicolon used as data in a checkbox enabled Choice column causes data and search problems.If you have more info, or know of an escape character for “;” please post a note to this article!&quot;;&quot; equals &quot;AND&quot;?If I were to search a SharePoint list for &quot;</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=242759307660973860' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/242759307660973860'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/242759307660973860'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/04/the-mysterious-semicolon-in-sharepoint.html' title='The Mysterious Semicolon in SharePoint Search'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-YB-JSM30vvc/Wtq3JM7-3WI/AAAAAAAADjM/FtPxaohvnD4WlvYaqibpyujsfNeyk-obwCHMYCw/s72-c/image_thumb%255B24%255D_thumb?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-6317248025841142702</id><published>2018-04-07T13:52:00.001-04:00</published><updated>2018-04-07T13:58:11.367-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>SharePoint TEXT() Function Bug for Scientific Notation</title><summary type="text">In Excel you can use the TEXT function to display very large and very small numbers in scientific notation.
  181. TEXT([Number],&quot;0.00E+00&quot;)
  182. Due to a bug in SharePoint Calculated Columns, the TEXT function adds some extra zeros to the end of the formatted number.
  183. Here’s a workaround…Assuming you want the equivalent of TEXT([Number],&quot;0.00E+00&quot;)=LEFT(TEXT(Number,&quot;0.00E+00&quot;),6) &amp;amp;
  184. TEXT(MID(TEXT(</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=6317248025841142702' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/6317248025841142702'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/6317248025841142702'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/04/sharepoint-text-function-bug-for.html' title='SharePoint TEXT() Function Bug for Scientific Notation'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-HmCVwAlSKCE/WskFPRGa-VI/AAAAAAAADiU/XBkdUP4RdwwZ6FjavgEWgcBplzilSTahQCHMYCw/s72-c/image_thumb%255B4%255D%255B1%255D_thumb?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-1401573288721032172</id><published>2018-03-29T20:40:00.001-04:00</published><updated>2018-10-18T14:31:15.102-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Customization"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>Shorter SharePoint Calculated Column OR Statements</title><summary type="text">Tested in SharePoint 2010, 2013, 2016 and Online.Available on Amazon!
  185.  
  186.  
  187.  
  188. Array ConstantsExcel will often let you use an array of values where you would normally use a range of cells.The Excel version:=VLOOKUP( [StatusCode],  {&quot;a&quot;,&quot;Active&quot;;&quot;i&quot;,&quot;Inactive&quot;;&quot;c&quot;,&quot;Closed&quot;},  , 2, 0 )
  189. .csharpcode, .csharpcode pre
  190. {
  191. font-size: 15px !important;
  192. color: black;
  193. font-family: consolas, &quot;Courier New&quot;, </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=1401573288721032172' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/1401573288721032172'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/1401573288721032172'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/03/shorter-sharepoint-calculated-column-or.html' title='Shorter SharePoint Calculated Column OR Statements'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-u_9GbsT6fao/W8jRcbsDTYI/AAAAAAAADmM/6EcaUA-xZhskZ-gIlwyBoOEfes3DEn7rQCHMYCw/s72-c/image%255B4%255D%255B3%255D?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-2757395259015869510</id><published>2018-03-26T14:28:00.001-04:00</published><updated>2018-03-28T13:33:22.977-04:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Customization"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Power User"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>Adding Fractions (1/4) to SharePoint Calculated Columns</title><summary type="text">(The following works SharePoint 2010, 2013, 2016, SharePoint Online, and most likely, 2019!)0, 1/8, 1/4, 3/8, 1/2, 5/8, 3/4, and 7/8
  194.  
  195.  
  196.  
  197. This is a sample from my soon to be published book “SharePoint Calculated Columns and Validation Formulas”. If you would like to see a lot more about what you can do with Calculated Columns, and maybe win a free book, attend my session at SharePoint Cincy 2018 </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=2757395259015869510' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2757395259015869510'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2757395259015869510'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/03/adding-fractions-14-to-sharepoint.html' title='Adding Fractions (1/4) to SharePoint Calculated Columns'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-sM8KRyTpVTI/Wrk7yVRughI/AAAAAAAADgk/OdfdlsLSjw0ZGgSjnRhfbAdzEraV9Hc-QCHMYCw/s72-c/image_thumb%255B7%255D?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-439693946269009389</id><published>2018-03-08T12:57:00.001-05:00</published><updated>2018-03-08T12:57:07.004-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>Adding Roman Numerals to SharePoint</title><summary type="text">
  198. In a Calculated Column
  199. Assuming an integer in a numeric column named the &quot;TheNumber&quot;, just add this equation to a Calculated Column:
  200. &amp;nbsp;&amp;nbsp;&amp;nbsp; =ROMAN(TheNumber)&amp;nbsp;&amp;nbsp;
  201. You can also select alternate formats:
  202. &amp;nbsp;&amp;nbsp;&amp;nbsp;
  203. See: https://support.office.com/en-us/article/ROMAN-function-D6B0B99E-DE46-4704-A518-B45A0F8B56F5
  204.  
  205. In a Page, Content Editor Web Part or a Rich Text </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=439693946269009389' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/439693946269009389'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/439693946269009389'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/03/adding-roman-numerals-to-sharepoint.html' title='Adding Roman Numerals to SharePoint'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/-p1vwF6cfD9I/WqF5aK5NFDI/AAAAAAAADfo/VPsKG0nxeTUEQk-ykbYednCgj94YvKvOQCHMYCw/s72-c/image_thumb%255B6%255D?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-6631184773864940261</id><published>2018-03-07T22:49:00.001-05:00</published><updated>2018-03-07T23:08:46.221-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2010"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>A SharePoint Calculated Column for all 50 States (workarounds for nested IF limits!)</title><summary type="text">
  206. Just in case you might ever need a formula to convert state abbreviations into state names…
  207.  
  208. You will need 50 nested IFs,
  209.  
  210. but SharePoint 2007 and 2010 only allows 7, and 2013 and later only allows 19.
  211. You will need a little more than 1300 characters in the formula,
  212.  
  213. but SharePoint 2007 and 2010 only allow 1024. (2013 and later are around one billion!)
  214. The trick for the IFs is to only nest 19 </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=6631184773864940261' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/6631184773864940261'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/6631184773864940261'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/03/a-sharepoint-calculated-column-for-all.html' title='A SharePoint Calculated Column for all 50 States (workarounds for nested IF limits!)'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-4981961453338960924</id><published>2018-02-18T15:26:00.001-05:00</published><updated>2018-02-18T15:51:06.835-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Administration"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>Numbers are Being Added to My SharePoint List Internal Names</title><summary type="text">When you create a list or library, the name you enter becomes both the internal name (used in the url), and the display name. When you rename a list, only the display name is changed. If you later create a new list with the same name as a renamed list’s original name, the new list’s internal name will have a number added.Here are the steps to show what&#39;s happening:Create a new Custom list and </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=4981961453338960924' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/4981961453338960924'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/4981961453338960924'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/02/numbers-are-being-added-to-my.html' title='Numbers are Being Added to My SharePoint List Internal Names'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://lh3.googleusercontent.com/--JuNWvx-kfw/WonhcICm0sI/AAAAAAAADfQ/dwIiuipifQUrALM8z6wn2rxwbDlbQLr7ACHMYCw/s72-c/image_thumb%255B3%255D?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-2427917966488000154</id><published>2018-02-15T14:44:00.001-05:00</published><updated>2018-02-15T14:47:35.599-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PowerShell"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2013"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Administration"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Search"/><title type='text'>Run SharePoint 2013 and 2016 Search Reports from PowerShell</title><summary type="text">Updated to include IDs for SharePoint 2016!&amp;nbsp;&amp;nbsp; Original article here.  Update! Need these reports for every site collection in the farm? See Part 2: http://techtrainingnotes.blogspot.com/2015/04/run-sharepoint-2013-search-reports-from_21.html  In my Search Administration class I stress that admins should dump the search reports on a regular basis as the data is only kept in detail for 14</summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=2427917966488000154' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2427917966488000154'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/2427917966488000154'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/02/run-sharepoint-2013-and-2016-search.html' title='Run SharePoint 2013 and 2016 Search Reports from PowerShell'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6074070440029916342.post-4060821999666511874</id><published>2018-01-23T23:23:00.001-05:00</published><updated>2018-01-23T23:30:38.158-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Office 365"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint 2016"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Online"/><category scheme="http://www.blogger.com/atom/ns#" term="SharePoint Site Owner"/><title type='text'>SharePoint 2016 Durable Links</title><summary type="text">
  215. I recently had a question in class about “Durable Links”. I did a search of the Microsoft sites to find anything official on SharePoint 2016 “Durable Links”, and basically only found a beta vintage blog article.
  216.  
  217. https://blogs.technet.microsoft.com/wbaer/2015/09/22/durable-links-in-sharepoint-server-2016-it-preview/
  218. While I did find a number of other blog articles from the beta period, mostly </summary><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=6074070440029916342&amp;postID=4060821999666511874' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/4060821999666511874'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6074070440029916342/posts/default/4060821999666511874'/><link rel='alternate' type='text/html' href='http://techtrainingnotes.blogspot.com/2018/01/sharepoint-2016-durable-links.html' title='SharePoint 2016 Durable Links'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7TFONk045TxvUkxQYG5umyDN_ATWWCpRP3u7wwhWGyUflFqGPUXcN8juy6GPp34H0KydtRj_Je5uUPBPYMwqQuTZWGtkQsX3EV4ckcWEj_oJsEWIkJgCMKkp4ZzvTX0bGOI5afOA-V3gF/s72-c/DurableLink.png" height="72" width="72"/><thr:total>0</thr:total></entry></feed>

If you would like to create a banner that links to this page (i.e. this validation result), do the following:

  1. Download the "valid Atom 1.0" banner.

  2. Upload the image to your own server. (This step is important. Please do not link directly to the image on this server.)

  3. Add this HTML to your page (change the image src attribute if necessary):

If you would like to create a text link instead, here is the URL you can use:

http://www.feedvalidator.org/check.cgi?url=http%3A//feeds2.feedburner.com/TechTrainingNotes

Home · About · News · Docs · Terms

 
Copyright © 2002-9 Sam Ruby, Mark Pilgrim, Joseph Walton, and Phil Ringnalda