111 posts tagged with "SharePoint"

Filter takes a table and keeps only the rows that match a condition: the competencies for one job title, the active people in a team, the requests still waiting. It works on SharePoint lists, connector results and any other table, and it's the formula behind almost every gallery. Here's how it works, with two real examples.

The app gets its home in this part: a Power Apps solution that holds the canvas app and three environment variables, which tell the app where its SharePoint data is. By the end, the app is created, connected to both lists and to Microsoft 365 user profiles, and ready for its first screen.

A canvas app that reads a SharePoint list normally has the site's address and the list built into it. Move the app to another organization and it still points at the old site. Environment variables fix that: the app asks the variables where its data is, and each environment gives them its own values.

You open a SharePoint list environment variable in your Power Apps solution to change something small, such as its display name, and the panel starts with a red error: We are unable to find the list. Site is empty, the list isn't shown, and Save is disabled. The variable still works. The edit panel just needs you to choose the site and list again.

You're creating a SharePoint environment variable in a Power Apps solution, you've typed its name, and you have no SharePoint connection yet. You choose + New connection, and Power Apps asks Are you sure you want to discard changes? Discarding throws your form away, and no connection page opens. The fix is to do things in a different order.

Every screen of the Career Development Plan app reads from or writes to two SharePoint lists. This part builds them, and the site they live on, column by column and setting by setting, exactly as the app will expect them.

A SharePoint list can hold millions of items, but SharePoint blocks any single query that has to work through more than about 5,000 of them at once. An index on the column you filter by lets SharePoint jump straight to the matching items instead. It takes a minute to add, and the best time to add it is while the list is still small.

A new SharePoint list accepts file attachments on every item, and anything in it can turn up in your organization's search results. That suits a team's task list. It doesn't suit a list an app writes private records to. Four settings on the list's settings page fix that.

A SharePoint list is a table that lives on a SharePoint site: rows are items, and columns describe them. Creating one takes a minute. Getting its columns right takes a little more thought, because the name you give a column on day one is the name that apps and flows use for good.

When an app keeps its data in SharePoint, everyone who uses the app needs permission on the SharePoint site too. SharePoint's obvious Share site button can't give the permission an app's users usually need, and its other sharing dialog quietly adds people to the site's Members group. This guide gives a security group exactly Contribute, and nothing more.