218 posts tagged with "Power Apps"

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.

When a canvas app adds a SharePoint list from Recent sites, it remembers that site's address. To have it follow environment variables instead, so a new environment only needs new values, add the lists through the Advanced tabs. They take a few more clicks, and they're easy to miss.

The Office 365 Users connector gives a canvas app people's Microsoft 365 profiles: name, email, job title, department, manager and direct reports. It's a standard connector, so it comes with Microsoft 365 licenses that include Power Apps. Adding it takes a minute from Studio's Data pane.

A new canvas app starts with App layout set to Fixed: Power Apps zooms the whole screen to fit the device, so a tablet-shaped app on a phone becomes a thin strip. Switch it to Responsive and each screen takes the size of the window instead. It's one setting, and it's the first step to an app that works on phones, tablets and desktops.

A canvas app's description is a sentence or two about what the app is for. Power Apps Studio keeps it in the app's Settings, and its own hint says why: "Provide a description to help end-users find and use your app." Here's where to type it and where it shows up afterwards.

An environment variable can point at a SharePoint document library as well as at a list. There's no separate Library type: you choose List, and the site's libraries are offered alongside its lists. Here's the whole thing, using a payroll library as the example.

Overtime is pay, and pay is private. This part makes SharePoint itself enforce that, not just the app: each person can open only their own overtime entries, nobody but the site's owners can delete them, editing an approved entry sends it back for approval, and payroll's library is for payroll alone. Then four people sign in and try it.