# jeanDosher.blog

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

## Sitemaps

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

## Posts

- [Blog](https://jeandosher.blog/blog/)
- [Optional Chaining in Power Automate: Prevent Errors accessing nested items in a JSON return](https://jeandosher.blog/optional-chaining-in-power-automate-prevent-errors-accessing-nested-items-in-a-json-return/): Optional chaining to prevent errors when acquiring nested items
- [Handling Power Automate actions outputs](https://jeandosher.blog/handling-power-automate-actions-outputs/): A friend was struggling to get the desirable output of a "Get from SharePoint" action, there is a way or another to do it -depends on what you do with the data in upcoming actions. So, I got this not-so-orthodox method to create an JSON object that fits perfectly in this friend's need. So,lets elaborate...
- [Usage of App.OnError in Power Apps - Dead programs tell no lies](https://jeandosher.blog/usage-of-app-onerror-in-power-apps-dead-programs-tell-no-lies/): Error handling in Power Apps has many possibilities depending on your project goals. One great implementation is the usage of App.OnError to handle errors globally. In this post a use case is shown, with increnental implementation but amussing that you reader has a minimum comfort or curiosity with error handling (IsBlank, IfError, IsError, Error, Errors,
- [Microsoft Power Platform Community call](https://jeandosher.blog/microsoft-power-platform-community-call/): Building Naming Refactoring tool for Power Apps As a continuation of my YAML in Power Apps exploration I came across a problem that truly demanded some YAML manipulation, refactoring more then 100 Canvas App Control names.So, I did it! And write the "YAML in Power Apps (part 2): Refactoring Power Apps Canvas App Control Names"
- [Microsoft Power Apps Cookbook, 3rd Edition by Eickhel Mendoza launched!](https://jeandosher.blog/microsoft-power-apps-cookbook-3rd-edition-by-eickhel-mendoza-launched/): I recently had the opportunity to receive a review copy of it, so, I thought it would be interesting to put my perspective.I'm using it to address current and recent challenges, and it’s proven his purpose! 🚩Some topics I have delved into: 𝑂𝑣𝑒𝑟𝑐𝑜𝑚𝑖𝑛𝑔 𝑃𝑜𝑤𝑒𝑟 𝐴𝑝𝑝𝑠 𝑑𝑒𝑙𝑒𝑔𝑎𝑡𝑖𝑜𝑛 𝑤𝑖𝑡ℎ 𝑃𝑜𝑤𝑒𝑟 𝐴𝑢𝑡𝑜𝑚𝑎𝑡𝑒: 🔹This is 𝑻𝑯𝑬 cleaver approach I’ve
- [Microsoft Copilot Studio: Building a chatbot with generative IA fed with my portfolio, resume and personal sites](https://jeandosher.blog/microsoft-copilot-studio-building-a-chatbot-with-generative-ia-fed-with-my-portfolio-resume-and-personal-sites/): Some of my experience trying to implement an AI-based bot to read my blogs, LinkedIn and some documents. Context: About Copilot Studio Power Virtual Agent gets a Power UP! Now it is Copilot Studio with a lot of new and extended features. Microsoft Copilot Studio lets you create powerful AI-powered copilots for a range of
- [Use Graph Api in Power Automate to read (very)large Excel files from SharePoint](https://jeandosher.blog/use-graph-api-in-power-automate-to-read-verylarge-excel-files-from-sharepoint/): Use Graph Api in Power Automate to read (very)large Excel files from SharePoint Current scenario Quantity of items: The sample file has 50K items: Running time: The scope of obtaining data from an Excel File hosted in a SharePoint Library takes around an hour to execute (in my study environment took eight hours 😭): In
- [Solution: Asset Management (Built with Model Driven App)](https://jeandosher.blog/solution-asset-management-built-with-model-driven-app/): Complete solution with Approvals and Microsoft Flow to support the business processes. Context This App decentralizes the control of asset allocations and uses the contacts/employes database already implemented in the organization’s Dataverse. With this we get rid of yet another use case of Excel spreadsheets for control and database. Also guaranteeing the security of information
- [How to filter Subgrid in a Model-driven App using code](https://jeandosher.blog/how-to-filter-subgrid-in-a-model-driven-app-using-code/): Using Form Context and some code, it is possible to set the Subgrid filter.This article assumes that you already have some familiarity with Model-Driven Apps and Form customization using code. But don't worry if you're not familiar with it, at the end of the article I suggest an Udemy course that will guide you through
- [Return data from office scripts and integrate systems with Power Automate](https://jeandosher.blog/return-data-from-office-scripts-and-integrate-systems-with-power-automate/): Business case of systems integration with Power Automate and a help of office scripts to make it error proof, effective and fancy. Context Let's suppose that you need to integrate a legacy system with your SharePoint List and the only source of data is an excel spreadsheet (😖). Power Automate handles this very well, but
- [SharePoint Premium -Content management evolution](https://jeandosher.blog/sharepoint-premium-content-management-evolution/): Solidify your content management foundation to unlock the full potential of your intranet with artificial intelligence and advanced security and governance features. Introduction SharePoint Premium is an extended version of SharePoint, adding AI, automation, and intensified security capabilities for organizations with content management needs. The main idea here is to give value to your data,
- [YAML in Power App Canvas](https://jeandosher.blog/yaml-in-power-app-canvas/): What is useful and practical in the new YAML feature in Canvas Apps? And how could impact an entire development process. Introduction Some contents about YAML have already been released, but only the code view feature in Canvas Apps Studio is not quite a practical feature. There’s a lot more going on, I would like
- [YAML in Power Apps (part 2): Refactoring Power Apps Canvas App Control Names](https://jeandosher.blog/yaml-in-power-apps-part-2-refactoring-power-apps-canvas-app-control-names/): This post explores a simple application I’ve developed to streamline control name refactoring within Power Apps Canvas Apps code that save a bunch of time renaming duplicated controls in Power Apps Studio 🤦‍♂️ Lots of Controls to rename‍ Recently I got into a project were a “legacy” Canvas Power Apps. I appropriated the term here, but

## Pages

- [Home](https://jeandosher.blog/)
- [About](https://jeandosher.blog/about/): I'm a former electrical engineer with 13 years of experience in Automotive Industry, dad of a teenager and 10 cats 🐈Now developing and deploying solutions using Microsoft Power Platform in NEXER EA Brazil: from Power Apps, Power Automate, Power BI, Dataverse to Azure DevOps. Proficient in SharePoint integration and automation. Skilled in creating canvas and

## Categories

- [Power Apps](https://jeandosher.blog/category/power-platform/papps/)
- [Power Platform](https://jeandosher.blog/category/power-platform/)
- [Power Automate](https://jeandosher.blog/category/power-platform/automate/)
- [SharePoint](https://jeandosher.blog/category/sharepoint/)
- [Copilot Studio](https://jeandosher.blog/category/power-platform/copilot-studio/)
- [Model-driven APP](https://jeandosher.blog/category/power-platform/model-driven-app/)
- [GraphAPI](https://jeandosher.blog/category/graphapi/)
- [Latest Works](https://jeandosher.blog/category/latestworks/)

## Tags

- [Spreedsheets](https://jeandosher.blog/tag/spreedsheets/)
- [YAML](https://jeandosher.blog/tag/yaml/)
- [Copilot](https://jeandosher.blog/tag/copilot/)
- [JavaScript](https://jeandosher.blog/tag/javascript/)
- [ErrorHandling](https://jeandosher.blog/tag/errorhandling/)
- [PowerApp](https://jeandosher.blog/tag/powerapp/)