A horizontal container lines its controls up in a row. On a wide screen that's what you want; on a phone, the row is wider than the screen and the last controls are cut off or disappear. The container's Wrap property moves the controls that don't fit onto the next row, and one formula makes them full width on phones.
A SharePoint list often names people in a Person column: a department's approvers, a project's owners, a request's reviewers. A canvas app can find the items that include the signed-in person by comparing their email with the column's Email values. With a column that allows several people, it takes one extra step to keep SharePoint's delegation rules happy.
Apps often show different things to different people: reports for payroll staff, a settings screen for admins. When those people are in Microsoft Entra security groups, a canvas app can ask the Office 365 Groups connector who's in a group and check whether the signed-in person is one of them. One named formula per group does it.
The Office 365 Groups connector lets a canvas app read and manage the groups in your organization, including who is in a group. Despite its name, it lists the members of security groups too. It's a standard connector, and adding it takes a minute from Studio's Data pane.
Some values an app needs are different for every organization that installs it, such as the IDs of its security groups. Typed into formulas, they would have to be changed inside the app each time. A small SharePoint list of settings keeps them outside the app, where a site owner can change them and the app looks them up by name.
Every group in Microsoft Entra has an Object ID, a long code that never changes, even when someone renames the group. Apps, connectors and scripts ask for the group by this ID. Finding and copying it in the Microsoft Entra admin center takes a minute.
Power Apps kept one delegation warning even after the filter behind it was fixed: Delegation warning. The named formula MyApproverDepartments is not delegable so its usage in this formula might not work correctly on large data sets. The named formula returned a table built from a SharePoint list. Returning what the app needed, a line of text, cleared it.
Power Apps put a squiggle under in and said: Delegation warning. The highlighted part of this formula might not work correctly on large data sets. SharePoint can't check whether someone is in a multi-person column, so Power Apps would only check the items it had downloaded, 500 by default. Letting SharePoint do the part it can, and the app the rest, removed the warning.
The Power Apps App checker shows a tip on Screen1 under Accessibility: Revise screen name. A screen reader announces a screen's name each time the screen opens, and "Screen1" doesn't tell anyone where they are. Rename the screen after what it's for, select Recheck, and the tip is gone.
The app gets its home in this part: a Power Apps solution that holds the Overtime Timesheet canvas app and four environment variables, which tell it where its SharePoint data is. By the end, the app exists, it's responsive with modern controls, and it's connected to both lists and to people's Microsoft 365 profiles.
