Option 3 – Form Formatting – Examples. This can be done with the new column formatting options in O365. SharePoint list formatting made easy - M365 Princess Column-Formatting With a Column Solution 1: Power Automate Flow The Flow Launch Panel will be displayed after clicking the button allowing the user to specify any required data and then run the flow. Add this on Data Connection and pass the value from your people picker to this Data Connection then query. s new in Column Formatter 1.2 You can create a workflow or Microsoft flow/power automate to update the Email address field based on the Person or Group field. If you are not going to use those email address values later (you don't need to save emails in column) and you just want to show the email in SharePoint list view then you can also achieve it using JSON column formatting. Some samples only work with choice, text, or number columns. I have a Flow created that will send an email when a Sharepoint item is modified. To add matching number of stars to the “Rating” column, click on its header – Column settings – Format this column. June 5, 2018. ”. Below is the default list view look: Add the below CSS in the script editor web part: