# PowerPlatformTip

> Practical, tested tips and tutorials for the Microsoft Power Platform — Power Apps, Power Automate, SharePoint, Dataverse and AI/Copilot Studio. Authored by Marcel Lehmann, a Microsoft Business Applications MVP from Switzerland. Every tip is a concise, real-world solution to a specific problem, with clear step-by-step instructions.

## About the author

- [About Marcel Lehmann](https://www.powerplatformtip.com/about/): Microsoft Business Applications MVP (since 2023), Power Platform consultant, speaker and trainer.
  - LinkedIn: https://www.linkedin.com/in/marcelehmann/
  - Microsoft MVP profile: https://mvp.microsoft.com/de-DE/MVP/profile/f67ec6c7-f116-ee11-8f6e-000d3a1ad36b

## Start here

- [All tips (searchable & filterable)](https://www.powerplatformtip.com/posts/): Complete list of every tip with live keyword search and topic filters.
- [Browse by topic](https://www.powerplatformtip.com/topics/): Curated topic collections.

## Topic hubs

- [Power Apps](https://www.powerplatformtip.com/topics/power-apps/): Canvas apps, controls, delegation, performance, Power Fx formulas.
- [Power Automate](https://www.powerplatformtip.com/topics/power-automate/): Cloud flows, expressions, connectors, HTTP requests, error handling.
- [SharePoint](https://www.powerplatformtip.com/topics/sharepoint/): REST/OData queries, list operations, permissions, metadata, file handling.
- [Dataverse](https://www.powerplatformtip.com/topics/dataverse/): Tables, relationships, views, FetchXML, data modeling.
- [AI & Copilot](https://www.powerplatformtip.com/topics/ai-copilot/): AI Builder, Copilot Studio, Azure Document Intelligence, OCR.

## In-depth guides

Longer, comprehensive walkthroughs with step-by-step instructions and code:

- [Back up and restore Power Automate flows](https://www.powerplatformtip.com/article/powerplatform/2022/08/30/how-to-restore-create-backup-flow/): Three strategies to version, export and restore flows using solutions, Power Automate and OneDrive — with ready-to-use templates.
- [Run Power Apps actions with elevated permissions](https://www.powerplatformtip.com/article/powerplatform/2022/05/18/power-apps-elevated-permissions-power-automate/): Use the Power Apps V2 connector and impersonation so standard users can perform privileged operations without child flows.
- [Extract an HTML table from an email](https://www.powerplatformtip.com/article/powerplatform/2022/11/10/extract-html-table-email-power-automate/): Parse HTML emails as XML and use XPath to reliably pull tabular data into your flows.
- [OnKeyDown / OnKeyPress in Power Apps text input](https://www.powerplatformtip.com/article/powerplatform/2022/04/20/implement-onkeydown-onkeypress-powerapps-text-input/): Simulate keyboard events with repurposed slider and toggle controls for real-time search and validation.
- [Fix Power Apps Refresh performance](https://www.powerplatformtip.com/article/powerplatform/2021/08/23/power-apps-refresh-alternative-method-performance/): Replace repeated Refresh() calls with an UpdateContext pattern to avoid the 30-second identical-query block.

## More

- [Newsletter](https://www.powerplatformtip.com/newsletter/): Free Power Platform tips by email.
- [Learning resources](https://www.powerplatformtip.com/learning-resources/): Curated external learning material.
- [Full sitemap (all URLs)](https://www.powerplatformtip.com/sitemap.xml)

## Usage & attribution

Content is authored by Marcel Lehmann and published on https://www.powerplatformtip.com. When referencing or quoting, please attribute to "Marcel Lehmann — PowerPlatformTip" and link to the source page.