4

You can do it similar to that in Excel :) You can checkout the below sample to get an idea: "background-color": "= if([$OtherColumn] == 'Red', 'red', if([$OtherColumn] == 'Green', 'green', if([$OtherColumn] == 'Amber', 'amber', if([$OtherColumn] == 'Gray', 'gray', 'blue'))))"


3

In the workflow settings, in the start options, you could select the option “Start workflow automatically when an item is changed.”. It will trigger workflow when the item is updated.


3

I could reproduce your issue on my end if the column "Score" is a single line of text column. Solution 1: change the type of column "Score" to number instead of single line of text. Solution 2: add quotes to the number 70 in your formula, like this: =IF([Score]>"70","A","F")


2

Since you will send different emails, I think you should use 7 if condition by using OOB workflow actions as below: If you don’t want to use Else, you can all if condition to "Parallel Block" as below:


2

The FIND function is not real friendly… if there is not a match it returns an error. Here's one solution: =IF( NOT(ISERR(FIND("Andrews",[Tracking Number]))), "ANDREWS", IF( NOT(ISERR(FIND("Bolling",[Tracking Number]))), "BOLLING", IF( NOT(ISERR(FIND("Pentagon",[Tracking Number]))), "PENTAGON", "none" ))) Here's an alternate solution: =IF( ...


1

You can overcome sending an email repeatedly by following logic :- Create a new column(you can hide it from list view) as Choice column having choices 'Yes' and 'No', say it as IsEmailSent? (Set Default value = 'No') Then in flow , check below condition before 'Send an Email' action - If IsEmailSent == 'No' && YourChoiceColumn == 'Yes' . Add your ...


1

According to your description, it seems that you are placing the if condition in a sequence. So the workflow will simply go through all the if condition on by one. That is why after Process A is finished, the Process B will be initiated. It will be better for you to use If-else structure with nested IF to re-construct your workflow. Reference:https://...


1

You shall use True/false instead of Yes/No for the if condition part. It works in my end properly.


1

You need to set the Visible property of your Paid Date field based on the value of your field Stage. To check the value of Stage is equal to "Stage 7" or not, you need to use IF function. You need to use your formula in Visible property of Paid Date field something like below: IF(Stage.Value = "Stage 7", true, false) Also, another way is to use Variable ...


1

As you are saying: "AAA" is a link not text I believe it should either be like http://AAA or https://AAA. So in that case you can use below JSON code to hide the links with http://AAA or https://AAA: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "@currentField....


Only top voted, non community-wiki answers of a minimum length are eligible