Power Apps: ISOWeekNum function
Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.
Function Day is where I’ll explore the basics of some functions and provide some recommendations on how to use them. I’ll focus on Microsoft Flow, SharePoint, and PowerApps since there’s a lot to explore there, but there may be other references showing up in the future. Please don’t expect an exhaustive list of all functions. You can find that on Microsoft’s excellent reference. I’ll focus on the most common ones and build from there, but I want to make Function Day a thing on this site. Articles will come out every Thursday, always 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate, SharePoint, and Power Apps articles, every three weeks. Time permitting I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.
Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.
Builds an array from mixed types: strings, booleans, integers, and nested arrays.
Combines strings, booleans, integers, and arrays into a single string.
Wraps a single value into an array. Accepts strings, booleans, integers, and floats.
Returns the hour component (0-23) of a date or time value.
Divides two numbers. Has a 19-digit precision limit that silently corrupts large results.