utcNow('format') / formatDateTime Tester
Test .NET date formats for Power Automate live and get utcNow('format').
Open the tool PowerPlatformTip
Power Platform Learning Hub
Learn faster. Build better. Ship practical Power Platform solutions.
Short, implementation-focused tips for Power Apps, Power Automate, Dataverse, Power Pages and Copilot Studio.
Free browser tools
27 tools for the jobs you repeat every week
Test a date format or build a trigger condition in seconds. Everything runs locally in your browser.
Trigger Condition Builder
Build Power Automate trigger conditions from a JSON sample.
Open the toolParseJSON in Power Apps (JSON to Power Fx)
Turn a JSON sample into Power Fx: ParseJSON with Type(), field access and ClearCollect/ForAll.
Open the toolFetchXML Builder
Build FetchXML queries for Dataverse from List rows output.
Open the toolChoose your path
A clearer entry point, inspired by academy-style learning journeys
Move from discovery to execution with focused paths instead of digging through content one post at a time.
Start with foundations
Use a curated collection of trainings, certifications and learning paths to build solid platform knowledge.
Open learning resources →Solve real implementation problems
Search through practical Power Platform tips by archive, category and tag when you need an answer fast.
Explore the archive →Keep improving every week
Get fresh patterns, shortcuts and platform updates delivered directly to your inbox.
Subscribe to the newsletter →Browse all posts
Go straight to the full archive when you already know you want tip-first learning.
View archive →Browse by topic
Jump into a curated collection for Power Apps, Power Automate, SharePoint, Dataverse or AI & Copilot.
Browse topics →Discover by tag
Scan platform-specific keywords and patterns when you want to pinpoint a niche topic quickly.
Explore tags →Learn the story
Understand the mission behind the site and how the content is designed to help busy makers ship faster.
Read the about page →#PowerPlatformTip 171: 'Debounce the Email Trigger with a Status Flag & Modified-Date Window'
TL;DR: Let the flow run in parallel, but guard it with a single SharePoint control row. Each run checks a Yes/No IsRunning flag. If it’s Yes, do nothing. If it’s No, read the stored WindowStart, re...
#PowerPlatformTip 168: 'Collect Failed Action Details with the result() Function'
TL;DR: Put your actions in a Scope, then in a Catch action (run after has failed) call result('Scope_name'). It returns an array with every top-level action in that scope - including the failed one...
#PowerPlatformTip 167: 'Date Math Without a dateDiff() - the ticks() Trick'
TL;DR: There is no function named dateDiff() in Cloud Flow expressions (the closest built-in is dateDifference(), which returns a timespan string, not a number). Convert both timestamps with ticks(...
#PowerPlatformTip 193: 'Export a Power Automate Flow When the Export Option Is Missing'
TL;DR: When the Export > Package (.zip) option is missing on a cloud flow, open the flow’s details page and replace /details at the end of the URL with /export. This forces the hidden export pag...
#PowerPlatformTip 166: 'Check if a Person Is Out of Office Before an Approval'
TL;DR: Use the standard Office 365 Outlook → “Get mail tips for a mailbox (V2)” action with the automaticReplies option to see whether an approver is away - no HTTP, no app registration. Need the e...
#PowerPlatformTip 169: 'Run a For-a-Selected-Item Flow from Any List with a Column Button'
TL;DR: The SharePoint Automate menu only lists For a selected item flows from the Default environment, which many companies forbid for productive flows. Instead of switching to the premium HTTP tri...
#PowerPlatformTip 174: 'Self-Healing Connector Actions in Copilot Studio - Retry & Remember'
TL;DR: A connector bound directly as a Copilot Studio tool ends the call with an error such as HTTP404NotFound or HTTP422UnprocessableEntity when the API answers with a non-2xx status. The agent ge...
#PowerPlatformTip 173: 'Let Copilot Studio Build the Call - Your Connector as an AI Tool'
TL;DR: Add your Custom Connector (#172) to a Copilot Studio agent on the Tools page with Add a tool. Generative orchestration reads the operation names and descriptions, picks the right operation a...
#PowerPlatformTip 170: 'One Flow, Many Tools – a Switch Router for Copilot Studio Agents'
TL;DR: Build one flow with the agent trigger with an action and an input parameter. A Switch on action routes to get (OData filter), create or update (JSON body), and Respond to the agent returns J...
#PowerPlatformTip 165: 'Read On-Prem AD Attributes via the User Profile and $select'
TL;DR: The on-prem AD attributes synced by Entra Connect (onPremisesSamAccountName, onPremisesDistinguishedName, onPremisesExtensionAttributes, …) are not returned by a default user profile lookup....
Microsoft and the Power Platform product names (for example Power Apps, Power Automate, Copilot Studio) are trademarks of the Microsoft group of companies. This is an independent website. It is not operated, sponsored or endorsed by Microsoft.