0

So I have a SharePoint list and I implemented a flow that sends me an email if a value in a certain column has been changed. However, I have many columns and I was wondering if there is a way to change the background color of an item that has recently been edited? I just want to easily scroll through the list and be able to see in red, what values have been edited in the last 24 hours or so. is this possible?

0

You can implement your design through MS Flow and JSON.

Please the following steps:

Step1.Create a Choice column named "Status" in your list

enter image description here

Step2.Create a MS Flow for your list

a) Add a Trigger "When an item is created or modified" enter image description here

b) Add an Action "Get item" enter image description here

c) Add an Action "Send an email (V2)" enter image description here

d) Add a Control "Condition"

  • (Get item)Modified is greater than or equal to addDays(utcNow(),-1)

enter image description here

  • If yes

Add an Action "Update item". Change Status value is "Edit in the last 24 hours"

enter image description here

  • If not

Add an Action "Update item". Change Status value is "Edit more than 24 hours"

enter image description here

e) Save and Test it enter image description here

Step3.View Formatting

Use below JSON code to color the rows in your list:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "additionalRowClass": "=if([$Status] == 'No Changing','sp-css-backgroundColor-noFill',if([$Status] == 'Edit in the last 24 hours','sp-css-backgroundColor-blockingBackground50','sp-css-backgroundColor-blueBackground27'))"
}

enter image description here

2
  • Thanks for the answer. So the entire row changes color when it has been edited. But is there anyway instead of the whole row, I can have just the single value change color? Basically highlight the value that was changed in the row. – mmmmm Feb 9 at 10:57
  • Hi, Mik. I'm sorry, I cannot currently implement how to highlight the value changed in the row. If there is a solution in the future, I will share with you as soon as possible. Have a nice day! – EchoDu_MSFT Feb 10 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.