flow can give a graphical representation of information
that changes frequently. You can for example let a flow
update a progress bar in a Tasks list each time the "% Complete"
value is changed.
In the demo below, Peter Kalmström, CEO and Systems Designer
of kalmstrom.com Business Solutions, shows how to create
such a flow for progress bar updates.
uses a list that build on the Tasks template, but he changes
the content type into a type that has a "Progress" site
If you want to create the flow for just one list, you can
keep the default content type and just add a list column
for the progress bar instead. It must be a multiple lines
of text column with Enhanced rich text enabled.
The "Progress" column should of course be visible in the
default view, but it can very well be hidden from the form.
Hide the "Progress" column from the form
Users don't need the Progress column when they fill out
the item forms, so it is suitable to hide it there.
Allow management of content types under List settings
Open the content type you use for the list.
Open the column you want to hide and select the
The progress bar HTML code
The HTML code used for the progress bars in the image above
<table style="width: 100px; border: 0px">
<td style="padding: 0px; width: 100px; background-color: green"></td>
<td style="padding: 0px; min-height: 16px; background-color: red"></td>
NOTE: “100” is marked bold above, because in the flow it
will be replaced by dynamic content that calculates the
Steps to create a flow that updates progress bars
You can build other graphics in a similar way, for example
for conditional formatting.
At https://flow.microsoft.com/, go into 'My Flows'
and click on 'Create from blank'.
Select the trigger 'SharePoint – When an item is
created or modified'.
Select the SharePoint site URL, or enter the URL
as a custom value.
Select the SharePoint Tasks list or enter its name
as a custom value.
Click on 'New step' and then 'New action'.
Select the action 'SharePoint - Update item'.
Select the same site and list as in step 3 and 4.
At Id, add the dynamic content ‘ID’.
At ‘Task Name’ the dynamic content ‘Task Name’.
At ‘Progress’, enter the progress bar HTML code.
Calculate the pixels needed for the width by replacing
100 in “width:100px” with an expression:
Start typing “mul” and select it among the suggestions,
Add a parenthesis
Put the cursor inside the parenthesis and select
the dynamic content “% Complete”.
Remove “100” after “width:” in the HTML code
and keep the cursor at that place.
Click OK under the expression.
Remove the default entries in other fields so that
all fields are empty except the ones you have filled