234 posts tagged with "Low Code"

Plenty of teams still track career development in spreadsheets: which skills each role needs, how far each person has got, and who has signed it off. This series replaces that with a Power Apps app. Each person sees the competencies their role expects and writes a short response for each one. Their manager then approves or declines it, all on SharePoint and the Microsoft 365 licenses you already have.

Power Apps keeps numbers the way a calculator does — 123456.789 — but the people using your app expect to read 123,456.79. The Text() function converts a number or integer to text and formats it in the same step, as long as you know the one situation where it silently does nothing.

Sooner or later a flow needs to find a person — the manager to notify, the owner of a request, the account behind an email address. The Search for users (V2) action from the Office 365 Users connector does exactly that: give it part of a name or an email address and it returns every matching Microsoft 365 user.

Power Automate is strict about data types. If you try to concatenate a number into a message, save it into a text column, or pass it to a connector that expects text, the flow fails with a type mismatch. The fix is the built-in string() expression, which converts a number or integer into its text or string representation.