How to Show Remaining Balance by Group in Microsoft Lists
Question details
The user needs to calculate and display a remaining budget at the bottom of a grouped view in Microsoft Lists, and restrict specific field editing by user.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Managing grouped budgets and restricting field-level edit permissions for specific users.
- Observed behavior
- Microsoft Lists does not natively support calculating a remaining budget in grouped views or restricting field-level editing without external tools.
Ensure you have adequate permissions to create Power Automate flows and customize forms in Microsoft Lists, as native calculation features for remaining balances are limited.
Calculate Remaining Balance Using Power Automate
Since Microsoft Lists cannot natively subtract group totals from a set budget in the view footer, use Power Automate to calculate the remaining balance and store it.
Microsoft Lists allows for basic sums in grouped views, but subtracting those sums from a static budget requires an external workflow.
Create a 'Net Total' Number column in your list, select 'Sum' for the total aggregation, and group the view by your target category such as Program Area.
Open Power Automate and create an automated cloud flow that triggers when an item is created or modified in your Microsoft List.
Initialize variables in your flow to calculate the total sum of the 'Net Total' column for the specific group, and subtract it from your allocated budget.
Add a final step in your flow to update a separate list or a specific column with the newly calculated Remaining Balance.
Restrict Field-Level Editing Using Power Apps
Use Power Apps form customization to conditionally hide or disable specific fields based on the current user.
Manage Budgets and Grouped Data Easily with WPS Office
If you are struggling with complex Power Automate flows to manage budgets, consider WPS Office. It is a free, lightweight Microsoft Office alternative that offers seamless migration, a familiar UI, and high format compatibility. You can easily manage budgets and grouped calculations natively in WPS Spreadsheet without needing additional apps.
Frequently Asked Questions
Can I show a subtracted total directly in a Microsoft Lists grouped view footer?
No, Microsoft Lists natively supports basic aggregations like Sum or Average in view footers, but it cannot perform complex custom calculations like subtracting a sum from a fixed budget directly in the view footer.
Is it possible to set field-level permissions in Microsoft Lists natively?
Microsoft Lists supports item-level permissions, allowing users to only see or edit items they created. However, native field-level permissions (restricting edit access to specific columns) are not supported without customizing the form using Power Apps.
What should I do if Power Apps is disabled by my administrator?
If your organization disables Power Apps, you cannot apply conditional visibility to list forms. You will need to rely on creating separate lists with different permissions, or submit a request via the Microsoft Feedback portal.
