Excel: Right Function
Returns characters from the end of a text string. Defaults to one character and always returns text.
Here I share the best practices I use for the Power Platform tools, drawn from my own experience and plenty of learning from other people's mistakes so I don't repeat them. None of this is set in stone, so adjust it to fit how you work. Consistency matters, especially when several people share a platform. I see it constantly: SharePoint sites with mismatched naming, lists with convoluted names, and flows nobody can follow. When you agree on rules, everyone always knows what something means, and onboarding a new person becomes far easier. Even if you never adopt my conventions, at least write your own down. And even if you work alone, building your own reference makes you think, and you will often spot places where things could be better. That reflection is half the value.
Returns characters from the end of a text string. Defaults to one character and always returns text.
Returns characters from the start of a text string. Defaults to one character and always returns text.
Pre-fills form answers through the link so each person opens the form with their own values.
Starts a flow when someone joins a chosen team. Returns only the user ID and polls every 5 minutes.
Adds an interval to the current time and returns a UTC timestamp. Whole-number intervals only.
Converts an array of objects into an HTML table for emails and messages. No styling built in.
Converts a base64-encoded string back into readable text. Takes a string, not a file object; UTF-8 only.
Returns a SharePoint file's library column values. Needs the integer item ID, not the file identifier.
Subtracts an interval from a timestamp you supply. Returns a string; months clamp to month end.
Returns the body output of a named action. Names use underscores for spaces and are case-sensitive.
Runs a flow from a message's More actions menu. Optional adaptive card; default environment only.
Project Online and Publisher are retiring. Plus wave 2 dates, a Power Pages permissions check, and security news.