I need putting some triggers in Microsoft lists through Power automate

Question

Hi Team,

I created a list in Microsoft List and need to add two triggers to one of the column through power automate. One trigger would be compare the value the input with another column value and then change the color of another cell. For instance if we have a value of 500 in a cell, and if someone enters a new entry, then automate should compare the input with 500 and if it is less than 500, it should change the color of entry to green otherwise red

The other condition would be to compare two cell and if the condition is true, it should send a custom email to the sender whose email is already saved on another column

Thanks

Kamran

Answer 1

Hi @Muhammad Kamran ,

To your first requirement, I think it cannot be achieved using Power Automate flow but using JSON column formatting.

For example:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "font-size": "30px",
    "color": "=if([$n1]<[$n2], 'green', 'red')"
  }
}

As to the second requirement, you can design an automated cloud flow using "condition" control and "Send an email(V2)" action like the below example. The trigger of the flow should be "When an item is created".

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.