SharePoint Online Sites, Lists, Libraries and Permissions
View All Tags
Patch saves to a data source without a form. Give it a new record from Defaults and it creates an item; give it a record loaded from the list and it updates that item. One formula can do both, so the same button handles the first save and every one after.
Patch fails with Network error when using Patch function: [YourList] ETAG mismatch. It isn't a network problem. The SharePoint item changed after your app read it, so SharePoint refused to overwrite the newer version. Catch it with IfError, tell the person what happened, and reload the item.
People open the Career Development Plan app to see what's expected of them. This part builds that screen: My plan lists the competencies for the person's job title, each with its level and a badge saying where their response stands. It also explains how the app asks SharePoint for exactly those items, and nothing more.
When a Power Apps formula filters a SharePoint list, there are two ways it can run. Either SharePoint does the filtering and sends back only the matching items, or Power Apps downloads some items and filters them itself. The first is delegation, and it's the only way that works on a big list.
A collection is a table that your app keeps in memory and can change: add rows, remove them, edit them. ClearCollect empties a collection and fills it again in one step, which makes it the usual way to load data into one.
Filter gives you every matching row; LookUp gives you the first one. Use it when you need one record, or one value from it: the job title of a competency, a person's response to a question, the item with a given ID.
A SharePoint Choice column looks like text in the list, but Power Apps gets it as a record. To show the choice, or to compare it with some text, use its Value: ThisItem.Level.Value, not ThisItem.Level.
A gallery shows a list: one row per record, all with the same design. You design the first row, the template, and the gallery repeats it for every record. Here's how to add a vertical gallery, connect it to a SharePoint list and set it up properly.
A yellow triangle appears next to a gallery, and the formula says Delegation warning. The "Filter" part of this formula might not work correctly on large data sets. The app still works today, but on a list with more than 500 items it will quietly miss some. The fix is to rewrite the part SharePoint can't run.
You set a label in a gallery to a SharePoint column, and instead of text you get a red error icon and Expected Text value. The column is a Choice column, and Power Apps gets a Choice as a record, not as text. Add .Value and it works.
