Forum Discussion
Getting total percentages from text fields
Pankaj,
Thank you for the reply. This is kind of what I want, BUT I would like the percentage to be in the "Completed Percentage" column. Is this possible?
Like in your example, BUT I would like it in the Percentage column and not "grouped by" (in my case Completed Percentage column)
Also, the Power Automate part, what settings did you use to calculate this percentage from the items in your grouping?
Thanks.
Displaying Value in Percentage Column:
Group by in SharePoint does not allow selecting a specific column to display in the group header.
However, you can adjust the margins and layout using JSON formatting to visually align the group header closer to the desired column.
Power Automate Implementation:
Trigger: When an item is created or modified
Option 1: Copy the value from a calculated column into a new column.
Option 2: Use a Condition Expression to replicate the logic currently used in your calculated column.
--------------------------------------------------
If the solution provided was helpful, please consider marking it as the accepted answer.
