Generated by All in One SEO Pro v5.0.0.1, this is an llms.txt file, used by LLMs to index the site.

# westerdale.blog

A Microsoft Consultant's Journey, On The Road to Collaboration

## Sitemaps

- [XML Sitemap](https://westerdale.blog/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Posts](https://westerdale.blog/posts/)
- [Resize the C Disk Partition to create a Dev Drive](https://westerdale.blog/resize-the-c-disk-partition-to-create-a-dev-drive/) - A Dev Drive using ReFS offers an alternative to NTFS. However, unmovable files can block resizing the C: drive when creating a Dev Disk.
- [Child Cloud Flow Exception and Response Handling Part 1](https://westerdale.blog/cloud-flow-exception-and-response-handling-part-1/) - Use Power Automate: parent and child cloud flows to build scalable solutions, delegating reusable tasks like document creation to child flows.
- [Connect Power BI Desktop to Azure SQL Edge or SQL Server 2019 on Docker](https://westerdale.blog/connect-power-bi-desktop-to-azure-sql-edge-on-docker/) - On a Windows 11 machine, I recently connected Power BI Desktop to both Azure SQL Edge and SQL Server 2019, hosted on Docker. By running these servers locally, you avoid connecting to the cloud and certain Azure hosting subscription charges, e.g. Pay-AS-You-Go, when testing TSQL scripts or creating visuals in Power BI. This post explains
- [The Attempted operation is prohibited because it exceeds the SharePoint List View threshold](https://westerdale.blog/attempted-operation-exceeds-sharepoint-list-view-threshold/) - If you are building Canvas Apps with screens that browse SharePoint Online Lists containing over 5000 items; you should be mindful of how you configure these Lists and the impact on Filter, Search, LookUp , Sort ( single columns only) and SortByColumns functions. This saltatory lesson became apparent when a client asked me to troubleshoot
- [Restart or re-enable your flows with PowerShell and Microsoft 365 CLI](https://westerdale.blog/restart-or-re-enable-your-flows-with-powershell-and-microsoft-365-cli/) - There are occasions, when you want to restart failed flow (Power Automate) runs or enabling (turning on) flows, after a solution deployment. You can do either of these tasks manually in the web browser or better still create repeatable scripts, combining PowerShell Cmdlets and the commands from the CLI for Microsoft 365. Microsoft 365 CLI
- [Power Apps Survival Guide: Naming Standards](https://westerdale.blog/power-apps-survival-guide-naming-standards/) - This post covers a suggested naming standard that will help to aid consistency and maintainablity when working on Power Apps. If you adopt the suggested three character prefix, you limit how much you need to type but still be able to distingish each control. You can also incorporate more expressive styles when naming Screen controls
- [Use a JSON Formatter to view Power Automate Action Outputs.](https://westerdale.blog/use-a-json-formater-to-view-power-automate-action-outputs/) - Want a better way to view the output in a Power Atomate trigger action such as SharePoint: when an item is created and easily determine a property value? This post will show how you can have nicely formatted JSON output with a simple extension in Edge Chromium. In the right hand Edge Chromium menu locate
- [Power APP: How to fix the BAD SOURCE Connector Exception](https://westerdale.blog/power-app-how-to-fix-the-bad-source-connector-exception/) - A short post covering how to resolve the {"Status": 400, "message":Bad Data Source.\r\n inner exception: Not a valid data source...} , should encouter this in a Power App connected to a backend SQL Server Express 2017 virtual machine (VM), using a shared SQL Server Connector . We noticed the issue after we sucessfully provisioned the
- [Online Sizing Matters!](https://westerdale.blog/online-sizing-matters/) - When migrating content from SharePoint on-premises to SharePoint Online, one of the key considerations is the space allocation for your organisation's tenant. This is a short post covering how this is calculated, the other service allocations and ways of managing or maximising the total allocation based on the services included in you license plans. So
- [Microsoft 365 Roadmap: As Product Pages](https://westerdale.blog/microsoft-365-roadmap-as-product-pages/) - The Microsoft 365 Roadmap gives us all the ability to stay up to date with the features or changes being developed, rolled out and launched within Microsoft 365. Please see Understanding Office 365 Release Cadence to explain when a feature might be deployed in your tenant. Using the web user interface (UI) you can focus on
- [Enabling the PowerShell ISE Experience on VSCode](https://westerdale.blog/enabling-the-powershell-ise-experience-on-vscode/) - You might well be thinking of replacing the Windows PowerShell Integrated Scripting Environment (ISE) , now that Microsoft has announced they have stopped actively developing it. Indeed, on Episode 160 of the Microsoft 365 Developer Podcast : Dev tools that make IT Pros smarter; Matthew McDermott, MVP (@MatthewMcD) spoke about the productivity gains offered PowerShell
- [Enable MFA for Users with Office 365 E3 and E5 Licenses](https://westerdale.blog/enable-mfa-for-users-with-office-365-e3-and-e5-licenses/) - It is a good idea to enable multi-factor authentication (MFA) for all users on your Office 365 tenant. The good news is there are a number of available versions of Azure multi-factor authentication depending on your requirements and available budget. This post covers the options for enabling MFA for users with just Office 365 E3
- [Walsgrave Rides 2019-2020](https://westerdale.blog/walsgrave-rides-2019/) - The Walsgrave Wanderers Joined the "Walsgrave Wanderers" for a nice ride after work. The guys are helping me up my average speed and also the time to get over those accursed hills! I will keep a log of these rides over a series of weekly posts. The 2019 Rides Nhilo and I went out for
- [Cycle Live Nottingham 2019: 75 Miles](https://westerdale.blog/cycle-live-nottingham-2019-75-miles/) - [ngg src="galleries" ids="13" display="pro_blog_gallery"]
- [Set Up App-Only Access To Your Tenant to solve (401) Unathorized Errors](https://westerdale.blog/set-up-app-only-access-to-your-tenant-to-solve-401-unathorized-errors/) - Setting up an App-only principal in SharePoint Online is documented in Grant Access using SharePoint App-Only This post highlights how this approach can resolve: "Unauthorized (401) errors", running tenant level PnPComandlets such as Set-PnPStorageEntity , under an global admin account with multi-factor authorisation (MFA) enforced. The remote server returned an error: 401 Unauthorized AdviceStore securely
- [Ride London 100](https://westerdale.blog/ridelondon-100/) - I am fundraising for Dementia UK by 100 miles as part of Ride London 100. This charity is especially close to my heart because dementia is a condition my late father suffered with. To this end, I have a fundraising page on Virgin just giving which you can access by clicking on image below. I wish
- [The Padgate to Belmont Circuliar ride](https://westerdale.blog/the-padgate-to-belmont-circuliar-ride/) - Just under 50 miles with 2500ft of climbing, taking in lots of my morning and afternoon commuting roads. It will be a bit busy till you get out of Leigh, but after that you hit some nice roads round Lostock, Belmont and back through Haigh. It takes in one of the Ironman climbs (but
- [Ironman UK 2018 One Lap](https://westerdale.blog/ironman-uk-2018-one-lap/) -  This is another decent training ride from Danny and it is one loop of the Ironman, Bolton, 2-loop bike course to take place on Sunday 15/07/2018. On the day, it’s twice around, plus and out and with the back leg, makes it 112 miles in total. However, this one loop ride still encompasses two climbs of
- [Split 2018](https://westerdale.blog/spit-2018/) - the Great Beaches Kastelet Beach can be reached by taxi or better still simply walk from along the costal path which starts just boyond the Town Hall and through Zovancac Playground. [ngg_images source="galleries" container_ids="3" display_type="photocrati-nextgen_basic_imagebrowser" ajax_pagination="0" order_by="sortorder" order_direction="ASC" returns="included" maximum_entity_count="500"] Day trip to Krka National Park [ngg_images source="galleries" container_ids="5" display_type="photocrati-nextgen_basic_imagebrowser" ajax_pagination="0" order_by="sortorder" order_direction="ASC"

## Pages

- [](https://westerdale.blog/) - westerdale.blog - A Consultant's Journey, on The Road to Collaboration....
- [Experience and Skills](https://westerdale.blog/experience-and-skills/) - Power Platform consultant with experience delivering canvas & model-driven apps, cloud flows, and scalable Dataverse solutions for complex business processes.
- [Contact](https://westerdale.blog/contact/) - Get in touch to discuss your Power Platform project, including model-driven apps, Power Automate, and scalable Dataverse solutions.
- [About](https://westerdale.blog/about-daniel-westerdale-blog/) - [et_pb_section fb_built=”1″ make_equal=”on” specialty=”on” background_color_2=”#0E4673″ padding_top_1=”12vw” padding_right_2=”5vw” padding_bottom_1=”80px” padding_left_1=”10vw” padding_1_tablet=”40px||0px|” padding_1_phone=”” padding_1_last_edited=”on|tablet” admin_label=”Header” _builder_version=”4.16″ background_color=”#0E4673″ inner_width=”100%” inner_max_width=”100%” custom_margin=”||156px|||” custom_margin_tablet=”||0px” custom_margin_phone=”” custom_margin_last_edited=”on|desktop” custom_padding=”0px||0px||true|” box_shadow_style=”preset7″ box_shadow_horizontal=”0px” box_shadow_vertical=”-80px” box_shadow_color=”#ECF0F5″ locked=”off” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ text_font=”Montserrat||||||||” text_letter_spacing=”3px” header_font=”Source Sans Pro|700|||||||” header_font_size=”10vw” header_line_height=”0.9em” header_2_font=”Source Sans Pro|||on|||||” header_2_font_size=”24px” header_2_letter_spacing=”2px” header_2_line_height=”1.8em” background_layout=”dark” custom_margin=”-15px||16px|||” custom_margin_tablet=”13px||||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|tablet” header_font_size_tablet=”12vw” header_font_size_phone=”” header_font_size_last_edited=”on|tablet”
- [My Passions](https://westerdale.blog/passions/) - [et_pb_section fb_built=”1″ specialty=”on” admin_label=”Resume” _builder_version=”4.16″ background_color=”#0E4673″ width=”90%” width_tablet=”100%” width_phone=”” width_last_edited=”on|desktop” module_alignment=”right” inner_width=”90%” inner_width_tablet=”80%” inner_width_phone=”” inner_width_last_edited=”on|desktop” inner_max_width=”1600px” inner_module_alignment=”left” custom_margin=”||0px|||” custom_padding=”47px||0px|||” locked=”off” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https://westerdale.blog/wp-content/uploads/2021/01/f6d6eeec2c7e827d17f2057c2dd683da.jpg” title_text=”f6d6eeec2c7e827d17f2057c2dd683da” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ background_image=”https://westerdale.blog/wp-content/uploads/2020/12/actor-02-1.png” background_size=”initial” background_position=”bottom_left” max_width=”400px” custom_margin=”-97px|||-10vw|false|false” custom_margin_tablet=”0px|-20vw|-100px|60vw|false|false” custom_margin_phone=”|||19vw|false|false” custom_margin_last_edited=”on|phone” custom_padding=”||0px|40px||” custom_padding_tablet=”||” custom_padding_phone=”” custom_padding_last_edited=”on|desktop” filter_saturate=”0%” filter_brightness=”109%” filter_contrast=”94%” box_shadow_style=”preset1″ box_shadow_vertical=”64px” box_shadow_blur=”64px” box_shadow_spread=”-12px” box_shadow_color=”rgba(20,22,23,0.59)” locked=”off” global_colors_info=”{}”][/et_pb_image][/et_pb_column][et_pb_column type=”3_4″
- [Power Platform](https://westerdale.blog/power-platform/) - [et_pb_section fb_built=”1″ next_background_color=”#ffffff” admin_label=”Hero Section” _builder_version=”4.16″ use_background_color_gradient=”on” background_color_gradient_stops=”#8f8f8f 10%|rgba(0,0,0,0.1) 100%” background_color_gradient_overlays_image=”on” background_color_gradient_start=”#8f8f8f” background_color_gradient_start_position=”10%” background_color_gradient_end=”rgba(0,0,0,0.1)” background_enable_image=”off” background_position=”center_right” custom_padding=”6%||6%|” top_divider_color=”#0e4673″ bottom_divider_style=”clouds2″ bottom_divider_height=”60px” global_colors_info=”{}” background_color_gradient_direction__hover=”180deg” background_color_gradient_direction__hover_enabled=”180deg” background_color_gradient_start_position__hover=”0%” background_color_gradient_start_position__hover_enabled=”0%” background_color_gradient_end_position__hover=”100%” background_color_gradient_end_position__hover_enabled=”100%” background_color_gradient_stops__hover=”#8f8f8f 0%|rgba(0,0,0,0.1) 100%”][et_pb_row admin_label=”Page Title Area” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Hero Section Title” _builder_version=”4.16″ text_font=”Montserrat||||||||” text_font_size=”18px” text_line_height=”1.8em” header_font=”Montserrat|600||on|||||” header_font_size=”48px” header_letter_spacing=”3px” header_line_height=”1.3em” header_2_font=”Montserrat|700|||||||”
- [Microsoft 365](https://westerdale.blog/microsoft-365/) - [et_pb_section fb_built=”1″ next_background_color=”#ffffff” admin_label=”Hero Section” _builder_version=”4.16″ use_background_color_gradient=”on” background_color_gradient_stops=”#0e4673 4%|rgba(0,0,0,0.15) 100%” background_color_gradient_overlays_image=”on” background_color_gradient_start=”#0e4673″ background_color_gradient_start_position=”4%” background_color_gradient_end=”rgba(0,0,0,0.15)” background_enable_image=”off” background_position=”center_right” custom_padding=”6%||6%|” bottom_divider_style=”clouds2″ bottom_divider_height=”60px” global_colors_info=”{}” background_color_gradient_direction__hover=”180deg” background_color_gradient_direction__hover_enabled=”180deg” background_color_gradient_start_position__hover=”0%” background_color_gradient_start_position__hover_enabled=”0%” background_color_gradient_end_position__hover=”100%” background_color_gradient_end_position__hover_enabled=”100%” background_color_gradient_stops__hover=”#0e4673 0%|rgba(0,0,0,0.15) 100%”][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.16″ _module_preset=”default” max_width=”793px” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https://westerdale.blog/wp-content/uploads/2020/12/office-365.png” title_text=”office-365″ _builder_version=”4.16″ _module_preset=”default” max_width=”150px” module_alignment=”center” filter_saturate=”0%” filter_brightness=”200%” filter_contrast=”200%” global_colors_info=”{}”][/et_pb_image][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default”
- [Power App](https://westerdale.blog/power-app/) - [et_pb_section fb_built=”1″ next_background_color=”#ffffff” admin_label=”Hero Section” _builder_version=”4.9.1″ use_background_color_gradient=”on” background_color_gradient_start=”#0e4673″ background_color_gradient_end=”rgba(0,0,0,0.15)” background_color_gradient_start_position=”4%” background_color_gradient_overlays_image=”on” background_enable_image=”off” background_position=”center_right” custom_padding=”6%||6%|” bottom_divider_style=”clouds2″ bottom_divider_height=”60px” background_color_gradient_direction__hover=”180deg” background_color_gradient_direction__hover_enabled=”180deg” background_color_gradient_start_position__hover=”0%” background_color_gradient_start_position__hover_enabled=”0%” background_color_gradient_end_position__hover=”100%” background_color_gradient_end_position__hover_enabled=”100%”][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.7.7″ _module_preset=”default” max_width=”793px”][et_pb_column type=”1_3″ _builder_version=”4.7.7″ _module_preset=”default”][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.7.7″ _module_preset=”default”][et_pb_image src=”https://westerdale.blog/wp-content/uploads/2020/12/powerapps@4x.png” alt=”Power Apps” title_text=”powerapps@4x” _builder_version=”4.9.2″ _module_preset=”default” max_width=”150px” module_alignment=”center”][/et_pb_image][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.7.7″ _module_preset=”default”][/et_pb_column][/et_pb_row][et_pb_row admin_label=”Page Title Area” _builder_version=”4.7.7″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Hero
- [Sa Calobra 2020](https://westerdale.blog/sa-calobra-2020/) - [et_pb_section fb_built=”1″ admin_label=”Hero” _builder_version=”4.7.7″ background_image=”https://westerdale.blog/wp-content/uploads/2019/11/Cala-St-Vincenc.jpg” parallax=”on” custom_padding=”110px|||”][et_pb_row column_structure=”1_4,3_4″ use_custom_gutter=”on” module_class=” et_pb_row_fullwidth” _builder_version=”3.25″ width=”100%” width_tablet=”100%” width_phone=”” width_last_edited=”on|desktop” max_width=”100%” max_width_tablet=”100%” max_width_phone=”” max_width_last_edited=”on|desktop” custom_margin=”|||” custom_padding=”|||” make_fullwidth=”on”][et_pb_column type=”1_4″ _builder_version=”3.25″ background_position=”top_left” custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://westerdale.blog/wp-content/uploads/2020/12/bicycle-4917180_640.png” title_text=”bicycle-4917180_640″ show_bottom_space=”off” force_fullwidth=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” disabled_on=”on|on|off” _builder_version=”4.7.7″ module_alignment=”center” custom_margin=”|||” custom_padding=”|||22px|false|false” filter_invert=”100%” animation_direction=”%22fade_in%22″ animation=”fade_in”][/et_pb_image][/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ background_position=”top_left” custom_padding=”|10%||10%” custom_padding__hover=”|||”][et_pb_text admin_label=”Hero Title” _builder_version=”3.27.4″ text_font=”||||” text_text_color=”#1a1a1a” header_font=”Oswald|on||on|” header_text_align=”left”
- [Privacy Policy](https://westerdale.blog/privacy-policy/) - Who we are Our website address is: https://westerdale.wpmudev.host. What personal data we collect and why we collect it Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymised string created from

## Categories

- [Uncategorised](https://westerdale.blog/category/uncategorised/)
- [Office 365](https://westerdale.blog/category/microsoft-365/office-365/) - Content that is related to Office 365: collaboration tools , administration and governance
- [My Passions](https://westerdale.blog/category/mypassions/) - I am passionate about cycling, walking and live music. Follow me on my adventures and share in my experiences.
- [Power Platform](https://westerdale.blog/category/powerplatform/) - Groups content related to PowerApps, Flow and PowerBI
- [Microsoft 365](https://westerdale.blog/category/microsoft-365/)
- [Cycling](https://westerdale.blog/category/mypassions/cycling/)
- [Walking](https://westerdale.blog/category/mypassions/walking/)
- [Tools and Techniques](https://westerdale.blog/category/tools-and-techniques/)
- [SharePoint](https://westerdale.blog/category/microsoft-365/office-365/sharepoint/)
- [Power App](https://westerdale.blog/category/powerplatform/power-app/)
- [Power Automate](https://westerdale.blog/category/powerplatform/power-automate/)
- [SQL Server](https://westerdale.blog/category/sql-server/)
- [WIndows](https://westerdale.blog/category/windows/)

## Tags

- [SharePoint Online](https://westerdale.blog/tag/sharepoint-online/)
- [Governance](https://westerdale.blog/tag/governance/)
- [Storage](https://westerdale.blog/tag/storage/)
- [Security](https://westerdale.blog/tag/security/)
- [Power Automate](https://westerdale.blog/tag/flow/)
- [My Work](https://westerdale.blog/tag/my-work/) - Collection of my recent practical work demonstrating my skills and projects I have worked on.
- [Training](https://westerdale.blog/tag/training/)
- [App-only](https://westerdale.blog/tag/app-only/)
- [Permissions](https://westerdale.blog/tag/permissions/)
- [VSCode](https://westerdale.blog/tag/vscode/)
- [SQL Server](https://westerdale.blog/tag/sql-server/)
- [Connector](https://westerdale.blog/tag/connector/)
- [cycling](https://westerdale.blog/tag/cycling/)
- [Naming Standards](https://westerdale.blog/tag/naming-standards/)
- [Edge](https://westerdale.blog/tag/edge/)
- [Extension](https://westerdale.blog/tag/extension/)
- [PowerShell](https://westerdale.blog/tag/powershell/)
- [Microsoft 365 CLI](https://westerdale.blog/tag/m365cli/)
- [Powershell7](https://westerdale.blog/tag/powershell7/)
- [Fixes](https://westerdale.blog/tag/fixes/)
- [Tips & Tricks](https://westerdale.blog/tag/tips-tricks/)
- [Docker](https://westerdale.blog/tag/docker/)
- [Azure SQL Edge](https://westerdale.blog/tag/azure-sql-edge/)
- [SQL Server 2019](https://westerdale.blog/tag/sql-server-2019/)
- [Ubuntu](https://westerdale.blog/tag/ubuntu/)
- [Banner](https://westerdale.blog/tag/banner/)
- [Cloud Flow](https://westerdale.blog/tag/cloud-flow/)
- [Try-Catch-Exception-Finally](https://westerdale.blog/tag/try-catch-exception-finally/)
- [Dev Disk](https://westerdale.blog/tag/dev-disk/)