SharePoint & Power Apps Learning

      Reference:  https://www.c-sharpcorner.com/article/power-automate-break-inheritance-and-set-list-item-level-permissions-in-sharep/#:~:text=the%20button%20below%20this%20first,remove%20all%20permissions%20from%20it. http://

 Save button: If(     Connection.Connected,     If(         FormModeIs = "New",         Patch(             'Spill Reporting',             Defaults('Spill Reporting'),             {                 Division: Division_DataCardValue.Text,                 District: District_DataCardValue.Text,                 Facility: Facility_DataCardValue.Text,                 State: State_DataCardValue.Text,                 County: County_DataCardValue.Text,                 'Date/Time of Discovery': DateValue_DateTimeDiscovery.SelectedDate + Time(                    ...

In Power Apps, delegation refers to whether a data processing task (like filtering, searching, or sorting) is performed by the  data source  (server-side) or by  Power Apps  itself (locally on the device).   Power Apps Land  +1 Delegable Functions These functions allow the data source to handle the heavy lifting. The app sends the query to the server, and only the results matching the criteria are returned to the device. This is essential for performance and accuracy when working with datasets exceeding 2,000 records.   LinkedIn  +3 Filter  &  LookUp : Delegable for most tabular data sources (Dataverse, SQL, SharePoint). Sort  &  SortByColumns : Generally delegable, but often restricted to single columns or specific data types. StartsWith : Frequently delegable and often used as a performance-friendly alternative to  Search . Sum, Average, Min, Max : Delegable on advanced data sources like SQL and Dataverse, though...