# Tag Info

Accepted

### Percentage formula showing extra numbers

Try to use Round function to rounds a number to a specified number of digits. Round Syntax = ROUND(number,num_digits) Where the num_digits the number of digits to which you want to round the number. ...
• 45.4k
Accepted

### Power Apps change Image based on field value

You have to nest the If statements. What that does is, if the criteria for the first condition evaluates to false, instead of having a value for a false result, you have another If statement to ...
• 12.6k

### Percentage formula showing extra numbers

You could set the calculated column as below：
• 3,968
Accepted

### PowerApps - Hide a Button if current user = created by

If you want to show the button based on condition, set "Visible" property of button control to: User().Email = ThisItem.'Created By'.Email OR User().Email = datacardvalue49.Selected.Email ...
• 42.8k

### SPO Calculate the difference between two dates

This question might help. The accepted answer says to just put your current column formula inside ROUND: =ROUND([your formula here],0)
• 268
Accepted

### How to launch home page on Power Apps Forms submit button Click in same tab?

The mentioned methods do not work for SharePoint custom forms, as is shown in the UserVoice post. And also quoting the community announcement post: LaunchTarget does not work in embedded apps, such ...
• 4,502
Accepted

### Power apps visible text

Set visible property of label control to: Not(Dropdown1_1.Selected.Site <> "Please Select") Update from comments: As @RobertLindgren suggested, below should also work for you: ...
• 42.8k
1 vote
Accepted

### Power Apps, Dropdown choice for column, Ascend/Descend based on Column choice

Use formula like below in items property of gallery control: If( Toggle2.Value = false, SortByColumns( Filter( [@'Documentation Tracker'], Or(Lower(...
• 42.8k
1 vote
Accepted

### Power Apps, TextSearchBox not searching for my String + integer field

Try using this formula in items property of your gallery control: If( Toggle2.Value = false, SortByColumns( Filter( [@'Documentation Tracker'], Or(Lower(...
• 42.8k
1 vote

### After submit, PowerApps field blank when viewing/editing

You have two choices to do : Either you apply for each new load for the new form the following function : OnVisible : NewForm('YourFormName') Either you apply OnSuccess Property of your form the ...
• 1,236
1 vote
Accepted

### Fill gallery rectangle based on value power apps

Try using below formula: If(ThisItem.'Risk Status'.Value = "OPEN", RGBA(235, 130, 125, 1), ThisItem.'Risk Status'.Value = "CLOSED", RGBA(115, 205, 170, 1), ThisItem.'Risk Status'....
• 42.8k
1 vote
Accepted

### Power app formula

Use below: If(IsBlank(TextInput7.Text) || IsBlank(TextInput1_4.Text), Disabled, Edit) OR If(Or(IsBlank(TextInput7.Text), IsBlank(TextInput1_4.Text)), Disabled, Edit)
• 42.8k
1 vote

### Validation on column between 2 values

SharePoint Column Validation Examples for your reference: https://techtrainingnotes.blogspot.com/2015/10/sharepoint-column-validation-examples.html
• 3,267
1 vote
Accepted

### SPO Calculate the difference between two dates

Use the formula. int(triggerBody()?['DateDif'])
• 4,271
1 vote
Accepted

### How to hide a SharePoint list column if its own value is empty?

Please the following steps: Step1: Select an item in the list to open the "Edit Form" panel Step2: On the "Edit Form" panel, click on "Edit columns" link Step3: On the &...
• 2,827
1 vote
Accepted

### How to copy single list attachment (as image) into the thumbnail/image column

Neither the new Image column or the Hyperlink or Picture column can be directly updated using flow. A workaround is to use Send HTTP request to SharePoint action to update Hyperlink or Picture field. ...
• 4,502
1 vote

### Power apps button & dropdown

A few things you should notice: There is no Selected property for Button control. As far as I know, you can only configure one-way action on one button control, there is no “release” or “unselect” ...
• 4,502
1 vote
Accepted

### Power apps button & dropdown

Add this formula on OnVisible property of Screen: UpdateContext({ddDefaultValue: ""}) Then set Default property of dropdown control to: ddDefaultValue Add below formula on OnSelect ...
• 42.8k
1 vote

### Validation for 2nd monday from today

Here is the Form validation formula: =IF(NOT(ISBLANK(DueDate)),IF(DueDate>(TODAY()+(7-WEEKDAY(TODAY(),2)+1+7)),TRUE,FALSE),TRUE) Find days from TODAY() to the first Monday using WEEKDAY(date,...
• 2,142
1 vote

### Assessment Calculator in Power Apps

The logic would be a lot easier to achieve in a SharePoint list - using Calculated column. Although I do not recommend writing the logic all in PowerApps since it increases the loading time ...
• 4,502
1 vote
Accepted

### Formula for swapping the choice in a drop down with a numerical value

Try below formula in your calculated column: =IF([Choice]="Doesn't align to current priorities","0",IF([Choice]="Somewhat aligns to current priorities","5",IF([Choice]="Aligns strongly with current ...
• 6,748
1 vote
Accepted

### How to enforce to input value from another column?

Try below formula: =IF([Choice]="Banana",IF(OR(ISBLANK([Start date]),ISBLANK(End date)),false,true),true) This satisfy the condition: If [Choice] is equal to "Banana" then user cannot leave Start ...
• 42.8k
1 vote

### Formula IF time between ranges (Calculated column)

"9:35:00 AM" is not a date or a time. It is just text. In any case using ">" will have issues with one and two digit times. ("12" is less than "9" when compared as text.) The TIME function creates a ...
• 6,807
1 vote
Accepted

### SP Online Flow add() syntax

The syntax for add function is like below: add(<summand_1>, <summand_2>) Where, <summand_1>, <summand_2> should of type Integer, Float, or mixed. Reference: Flow - add() ...
• 42.8k
1 vote
Accepted

### Help with Traffic Light SharePoint Calculated Formula

Use below formula: ="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Review Status]="Approaching","Green",IF([Review Status]="OverDue","...
• 42.8k
1 vote
Accepted

### Calculated Column Depending on Different Column Value

Try using below formula: =IF([ChoiceField]="New York","Person1",IF([ChoiceField]="Florida","Person2",[ChoiceField])) This formula is similar to: if(ChoiceField === "New York") { CalculatedValue ...
• 42.8k
1 vote

### Remove all commas from single line of text field

SharePoint JSON formatting now supports replaceAll operator which you can use to remove all commas from a single line of text. Example: { "\$schema": "https://developer.microsoft.com/...
• 42.8k
1 vote

### Date validation to specific year for list Column in view

You need change the validation formula to this: =TEXT([Data documento],"yyyy")="2018" Try to use this in list validation. Go to list settings-> validation settings:
• 5,181
1 vote
Accepted

### List Validation settings Error in Formula

I don't know all your requirements. But I guess you want "Billing Status" field to be mandatory if "A La Carte" is equal to "Yes"(Correct me if I am wrong). In this case you need to use below formula:...
• 42.8k
1 vote
Accepted

### InfoPath If Statement

Make sure you've got the appropriate spaces between terms. So between any [Field] or any operator (+,*,/), and I think your parenthesis, too? Your syntax looks correct to me. If the spaces doesn't ...
• 1,745

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